Download the PHP package maggsweb/maggsweb-pdo without Composer
On this page you can find all versions of the php package maggsweb/maggsweb-pdo. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package maggsweb-pdo
Maggsweb PDO
An easy-to-use PDO Database wrapper for PHP & MySQL
Table of Contents
Initialization
Query
Insert Records
Update Records
Delete Records
Initialization
To use this class, set your database connection constants, download and include 'MyPDO.php' into your project and instantiate a database connection.
Query
Run a query, any query..
To execute a string of SQL, pass the complete SQL string to ->query
Call ->execute to execute the query. This returns true|false;
Run a query and return the results
To return the results from ->query for use call ->fetchAll() for multiple rows, ->fetchRow for a single row or ->fetchOne for a single value. Results are returned as an Array of Objects an Object or a value. Optionally, passing 'Array' to the fetch functions will return results as a Multi-dimensional Array.
On success, $result will be an Object Array (fetchAll) or an Object (fetchRow) or a value (fetchOne)
On failure, call ->getError to display the SQL error message
Run a query using 'bound' params and return results
To bind parameters to a query, pass the column identifier and value to ->bind(). Repeat this for each bound parameter in order.
Query Results
On failure, call ->getError to display the SQL error message
Insert Records
Insert a record using 'bind' params
Insert Results
Last Insert ID
Update Records
Update (all) records using 'bind' params
Update records using 'bind' params and 'where' string
Update specific records using 'bind' params and 'where'
Update Results
Delete Records
Delete records using a 'where' string
Delete records using a 'where' array
Delete Results
All versions of maggsweb-pdo with dependencies
ext-mysqli Version *
ext-pdo Version *