{"repo":"msbatal/PHP-PDO-Database-Class","free":true,"listed":false,"github":"https://github.com/msbatal/PHP-PDO-Database-Class","clone":"git clone https://github.com/msbatal/PHP-PDO-Database-Class.git","description":"PHP PDO database class that utilizes PDO and prepared statements (MySQL, MariaDB, MSSQL, SQLite, etc)","language":"PHP","stars":16,"topics":["class","mariadb","mssql","mysql","pdo","pdo-mysql","pdo-php","php","postgresql","sqlite"],"license":"LGPL-2.1","category":"databases-storage","readme_excerpt":"PHP PDO Database Class SunDB is a PHP PDO database class that utilizes PDO and prepared statements (MySQL, MariaDB, MSSQL, SQLite, etc). Technical Document: https://deepwiki.com/msbatal/PHP-PDO-Database-Class Table of Contents - Initialization - Security - Insert Query - Update Query - Delete Query - Transactions - Select Query - Join Method - Where Method - Ordering Method - Limiting Method - Pagination Method - Count Method - Grouping Method - Having Method - Raw SQL Queries - Backup Database - Maintaining Database - Helper Methods Installation To utilize this class, first import SunDB.php into your project, and require it. SunDB requires PHP 5.5+ to work. Initialization Simple initialization with utf8 charset set by default: Advanced initialization: Url, Port and Charset parameters are optional. You can use mysql, mssql, and sqlite driver types for Driver parameter. If you want use MSSQL: If you want use SQLite: Also it's possible to use already connected PDO object: Security - SunDB always uses native (non-emulated) prepared statements ( PDO::ATTR EMULATE PREPARES = false ) on every driver. This closes a known SQL injection technique that only affects PDO's emulated mode (details). - Table and column names can never be sent as bound parameters, so SunDB validates every identifier it receives (table names, column names, insert/update keys, join columns) before using it — an invalid identifier throws an exception instead of reaching the database. - The comparison operator p","default_branch":null,"files":null,"tree":[],"storefront":"/r/msbatal","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/msbatal/PHP-PDO-Database-Class/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."}