kimoslim / pdo
PHP 7.2 Compatible Fork of PDO database library for Slim Framework
1.10.2
2018-05-03 01:45 UTC
Requires
- php: >=5.3.0
- ext-pdo: *
README
PDO database library for Slim Framework
This is a fork of Fabien's project with support for PHP 7.2.
Please refer to the main package at https://github.com/faaPz/Slim-PDO for pull requests, support and documentation.
Installation
Use Composer
"require": { "kimoslim/pdo": "~1.10" }
Usage
Examples selecting, inserting, updating and deleting data from or into users
table.
require_once 'vendor/autoload.php'; $dsn = 'mysql:host=your_db_host;dbname=your_db_name;charset=utf8'; $usr = 'your_db_username'; $pwd = 'your_db_password'; $pdo = new \Slim\PDO\Database($dsn, $usr, $pwd); // SELECT * FROM users WHERE id = ? $selectStatement = $pdo->select() ->from('users') ->where('id', '=', 1234); $stmt = $selectStatement->execute(); $data = $stmt->fetch(); // INSERT INTO users ( id , usr , pwd ) VALUES ( ? , ? , ? ) $insertStatement = $pdo->insert(array('id', 'usr', 'pwd')) ->into('users') ->values(array(1234, 'your_username', 'your_password')); $insertId = $insertStatement->execute(false); // UPDATE users SET pwd = ? WHERE id = ? $updateStatement = $pdo->update(array('pwd' => 'your_new_password')) ->table('users') ->where('id', '=', 1234); $affectedRows = $updateStatement->execute(); // DELETE FROM users WHERE id = ? $deleteStatement = $pdo->delete() ->from('users') ->where('id', '=', 1234); $affectedRows = $deleteStatement->execute();
The
sqlsrv
extension will fail to connect when using error modePDO::ERRMODE_EXCEPTION
(default). To connect, you will need to explicitly passarray(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING)
(orPDO::ERRMODE_SILENT
) into the constructor, or override thegetDefaultOptions()
method when usingsqlsrv
.
Documentation
See DOCUMENTATION
Changelog
See CHANGELOG
License
See LICENSE