PHP Classes

PdoDB: Connect to databases and execute queries using PDO

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
Not enough user ratingsTotal: 270 All time: 7,723 This week: 206Up
Version License PHP version Categories
pdodb 1.0Freely Distributable5.0PHP 5, Databases
Description 

Author

Krzysztof Piotrowicz

This class can connect to databases and execute queries using PDO.

It can connect to a database server using a given connection string.

The class can also execute arbitrary SQL queries and retrieves the query results one record at a time until it reaches the end of result records.

It can also measure the time queries take to execute.

Picture of Krzysztof Piotrowicz
  Performance   Level  
Name: Krzysztof Piotrowicz <contact>
Classes: 4 packages by
Country: Poland Poland

Level 1 Star

 Innovation award
Innovation award
Nominee: 1x

Details

README.TXT - PdoDB CLASS V1.0

ATTENTION: YOU MUST CONFIGURE CLASS AND EXAMPLE FILE BEFORE USING IT!

Class:PdoDB

$connect_array - array with database host,dbname,user,password
$set_names - if true, set names for mysql connection
$set_names_type - character encoding for mysql connection
$debug - show debug
$get_time - if true, get all connections time and sql queries time
$insert_delayed - if true, query sql with 'insert delayed' if insert
$version - current script version

FUNCTIONS
query($SQL) - query a given sql to database with pdo
next_record() - fetch next record
f($row) - return a given row name
Eof() - used for multiple fetch records in loops
print_all_time() - print_r all connection times if $get_time was set true

  Files folder image Files (3)  
File Role Description
Plain text file pdodb_class.php Class MAIN CLASS
Accessible without login Plain text file pdodb_example.php Example EXAMPLE FILE
Accessible without login Plain text file readme.txt Doc. README

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
Downloadpdodb-2012-08-29.zip 2KB
Downloadpdodb-2012-08-29.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:270
This week:0
All time:7,723
This week:206Up
User Comments (1)
 

  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.