PDO Multi Connection Class: Access different types of SQL database using PDO

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (10)   DownloadInstall with Composer Download .zip   Reputation   Support forum (24)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 68%Total: 3,127 All time: 1,145 This week: 221Up
Version License PHP version Categories
pdo-multicnxn 2.3GNU General Publi...5.0PHP 5, Databases
Description Author

This class can access different types of SQL database using PDO.

It provides a common interface to access different types of database like MySQL, PostgreSQL, Microsoft SQL server, IBM DB2, SQLite, Oracle, Informix, and Firebird.

The class can establish connections, execute queries, retrieve single result rows or single row columns, the number of result rows, the last inserted record identifier, the names of tables columns, and execute INSERT, UPDATE and DELETE queries from parameters.

It can use prepared queries to prevent SQL injection attacks.

Recommendations

Best PDO class to use with MySQL
Need to connect to a MySql DB and perform all standard queries

Picture of Evert Ulises German Soto
  Performance   Level  
Name: Evert Ulises German Soto <contact>
Classes: 3 packages by
Country: Mexico Mexico
Age: 35
All time rank: 5867 in Mexico Mexico
Week rank: 256 Up5 in Mexico Mexico Up

Screenshots  
  • class_screenshot
  Files folder image Files  
File Role Description
Accessible without login Plain text file pdo_database.class_manual.php Doc. pdo multicnxn user manual
Plain text file pdo_database.class.php Class class file pdo multicnxn
Accessible without login Plain text file database.cnfg.php Conf. database.cnfg.php
Accessible without login Plain text file examples_advanced.php Example examples_advanced.php
Accessible without login Plain text file example_connect_to_db.php Example example_connect_to_db.php
Accessible without login Plain text file example_create_table.php Example example_create_table.php
Accessible without login Plain text file example_delete.php Example example_delete.php
Accessible without login Plain text file example_insert.php Example example_insert.php
Accessible without login Plain text file example_select.php Example example_select.php
Accessible without login Plain text file example_update.php Example example_update.php

 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,127
This week:0
All time:1,145
This week:221Up
User Ratings User Comments (5)
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:90%StarStarStarStarStar
Examples:95%StarStarStarStarStar
Tests:-
Videos:-
Overall:68%StarStarStarStar
Rank:531
 
thank you man , i wont use it in my cms & framework sfhati.
5 years ago (bassam alessawi)
80%StarStarStarStarStar
Methods for oracle are wrong.
8 years ago (Arnaud)
65%StarStarStarStar
Excellent class!
8 years ago (Marco Rossi)
80%StarStarStarStarStar
http://www.
9 years ago (RicardoSaracino)
50%StarStarStar
There is no SQL escaping methods, nor PDO data binding methods.
9 years ago (Artur Graniszewski)
30%StarStar
 

For more information send a message to info at phpclasses dot org.