PHP Classes

PDO DB Connector: Connect and execute common 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: 373 All time: 6,782 This week: 206Up
Version License PHP version Categories
db-connector 1.0.3Freely Distributable5.6PHP 5, Databases
Description 

Author

This class can connect and execute common queries using PDO.

There is a base class that establishes connections to a given database using PDO. It has functions dedicated to connect to MySQL and Microsoft SQL server databases.

A sub-classe provides functions to perform common queries. Currently it can:

- Execute arbitrary SQL queries and return the results in an array
- Query a table and return a single column of results as an array
- Query a table and return all rows as an array
- Execute INSERT or UPDATE queries without prepared values
- Delete table rows that match a condition

Picture of Itay Segal
  Performance   Level  
Name: Itay Segal <contact>
Classes: 2 packages by
Country: Israel Israel

Recommendations

Edit, eliminate, search, and sort table records
Maintain tables in a MySQL database

  Files folder image Files (3)  
File Role Description
Plain text file db.php Class db connector
Plain text file DBMethods.php Class insert/update/delete
Accessible without login Plain text file example_mysql.php Example example for mysql usage

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
 Version Control Unique User Downloads Download Rankings  
 0%
Total:373
This week:0
All time:6,782
This week:206Up