Login   Register  
PHP Classes
elePHPant
Icontem

Class: mdb

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Peter Klauer  >  mdb  >  Download .tar.gz .zip  >  Support forum Support forum (6)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: mdb
Support forum Support forum
Base name: mdb
Description: Access Microsoft Access .mdb database files
Related classes: , , , , , , ,
Version: -
PHP version: -
License: Freeware
All time users: 8600 users
All time rank: 142
Week users: 7 users
Week rank: 493
Picture of Peter Klauer
Author: Peter Klauer <e-mail contact>
Packages: 18 Browse this author's classes Browse this author's classes
Country: Germany Germany - PHP jobs in Germany
Age: 53
All time rank: 292 in Germany Germany
Week rank: 144 Down6 in Germany Germany Down
Innovation award
Innovation award
Nominee: 3x


  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.

 

  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

  Rate classes User ratings   Applications   Files Files  

  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

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (78.6%)
Good (80.4%)
Sufficient (72.9%)
Sufficient (75.0%)
-
-
Sufficient (62.1%)
654
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 folder image 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.