PHP Classes
Icontem

Class: mdb


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Peter Klauer  >  mdb  >  Download  >  Support forum Support forum (6)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: mdb Support forum
Base name: mdb
Description: Access Microsoft Access .mdb database files
Related top rated classes: , ,
Version: -
Required PHP version: -
License: Freeware
All time users: 6868 users
All time rank: 140
Week users: 29 users
Week rank: 170
 
  Author   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Files Files  

Author

Picture of Peter Klauer
Name: Peter Klauer <e-mail contact>
Published packages: 18 Browse this author's classes Browse this author's classes
Country: Germany Germany - PHP jobs in Germany
Home page: http://www.ingoknito.de/
Age: 50
All time rank: 26
Week rank: 48

Innovation Award

PHP Programming Innovation award nominee
June 2004
Number 4
 Microsoft Access is a popular database manager application for Windows. Despite it is not very suitable for Web database applications that may be updated by many simultaneous users, there is always people willing to use their Microsoft Access database files (.mdb) on the Web.

One of the difficulties of using .mdb files from PHP is that when you use the ODBC API to access the databases, usually you need to setup a Data Source Name (DSN) in the Windows system that works as a server.

This class provides an alternative solution that takes only the path of the .mdb file to access it using Microsoft COM objects.

The class automatically constructs a suitable DSN to instantiate a COM object that can be used to execute and retrieve the result sets of SQL queries that can be run on Microsoft Access databases.

Manuel Lemos

Groups

Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Files and Folders Listing, accessing and manipulating files and folders View top rated classes
Group folder image Windows Use of capabilities specific of the Windows operating systems View top rated classes

Detailed description

This class is meant to access Microsoft Access .mdb database files by specifying their filenames.

It uses a Windows ADODB COM object to open the .mdb database. From then on you can execute SQL queries and retrieve the result set date like with any SQL based database.

User ratings

Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (81.3%)
Good (81.3%)
Sufficient (75.0%)
Good (81.3%)
-
-
Sufficient (64.4%)
380
Month:
Not yet rated by the users

Applications that use this class

No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

Files

File Role Description
Plain text file class_mdb.php Class The class file
Plain text file example.php Example example
Plain text file issue_date.txt Doc. Known issue with date < 1970
Download all files: mdb.tar.gz mdb.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products