PHP Classes

mdb: Access Microsoft Access .mdb database files

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 63%Total: 10,020 All time: 137 This week: 47Up
Version License Categories
mdb 1.0.0FreewareDatabases, Files and Folders, Windows
Description 

Author

Peter Klauer

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.

Innovation Award
PHP Programming Innovation award nominee
June 2004
Number 4

Prize: One downloadable copy of PHPEd		 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
Picture of Peter Klauer
Name: Peter Klauer <contact>
Classes: 18 packages by
Country: Germany Germany
Innovation award
Innovation award
Nominee: 3x

  Files folder image Files (3)  
File Role Description
Plain text file class_mdb.php Class The class file
Accessible without login Plain text file example.php Example example
Accessible without login Plain text file issue_date.txt Doc. Known issue with date < 1970

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadmdb-2006-03-07.zip 3KB
Downloadmdb-2006-03-07.tar.gz 3KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:10,020
This week:0
All time:137
This week:47Up
User Ratings User Comments (1)
 All time
Utility:79%StarStarStarStar
Consistency:81%StarStarStarStarStar
Documentation:75%StarStarStarStar
Examples:76%StarStarStarStar
Tests:-
Videos:-
Overall:63%StarStarStarStar
Rank:852
 
Perfect!!! I loooove you
17 years ago (ly manh)		80%StarStarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.