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.*

Unknown License

• Tony Chen

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();

slim-pdo documentation