{"repo":"adambinnersley/pdo-dbal","free":true,"listed":false,"github":"https://github.com/adambinnersley/pdo-dbal","clone":"git clone https://github.com/adambinnersley/pdo-dbal.git","description":"A simple database abstraction layer using PHP and PDO","language":"PHP","stars":17,"topics":["pdo-wrapper","pdo-mysql","mysql","php","pdo","pdowrapper","pdo-php","database","php-dbal","dbal"],"license":"MIT","category":"databases-storage","readme_excerpt":"PDO Database Abstraction Layer A simple database abstraction layer for MySQL PDO Installation Installation is available via Composer/Packagist, you can add the following line to your composer.json file: or Class Features - Optional cache support with Memcache / Memcached / Redis / XCache - Optional connection to secondary database incase the no connection to the primary MySQL server is available - Connects to a MySQL database via PDO - Simplify queries to SELECT / INSERT / UPDATE and DELETE - Built in prepared statements - Compatible with PHP5.6 and later License This software is distributed under the MIT license. Please read LICENSE for information on the software availability and distribution. Usage Example of usage can be found below with what queries they would result in (For security all queries are run using prepared statements with values added on execute() after the prepare() has been run) 1. Connect 2. Select 3. Insert 4. Update 5. Delete 6. Count 7. Query Any other queries can be run using the query command by passing the SQL query and values 8. FetchColumn 9. NumRows 10. LastInsertId 11. isConnected 12. Caching Database caching can be added to queries with support for Memcache / Memcached / Redis and XCache","default_branch":null,"files":null,"tree":[],"storefront":"/r/adambinnersley","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/adambinnersley/pdo-dbal/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}