tonychen / php-db
There is no license information available for the latest version (v0.1.2) of this package.
php pdo library
v0.1.2
2018-05-11 03:04 UTC
Requires
- php: >=5.4
- slim/pdo: ~1.9
Requires (Dev)
- codeception/codeception: 2.3.*
This package is not auto-updated.
Last update: 2025-03-21 08:32:27 UTC
README
数据库类库
基于slim-pdo做的一个pdo数据库类
Install
$ composer require tonychen/php-db
// 把下面的代码片段,加入到composer.json文件里面 "require": { "tonychen/php-db": "0.1" }
Usage
require_once 'vendor/autoload.php'; $pdo = \Tony\DB\DbFactory::getInstance(['dsn' => 'mysql:host=192.168.1.11;dbname=test;charset=utf8','user'=>'root', 'password' => '123456']); // 使用原生 $res = $pdo->fetchRow('SELECT * FROM player'); //------------------------使用sql builder---------------------------// // 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();