README

另一个PDO包装器，它扩展了PDO类并添加了一些额外的功能。

安装

使用以下命令通过composer安装此包：

$ composer require phppackage/pdo-wrapper

使用示例

<?php
require 'vendor/autoload.php';

use PHPPackage\PDOWrapper\PDO;

// connect, a standard PDO constructor
$db = new PDO(
    'sqlite::memory:',
    'test_username',
    'test_password', 
    [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
    ]
);

// or default to an sqlite file
$db = new PDO();

// get database info
$info = $pdo->info();

// get databases
$databases = $pdo->databases();

// get tables
$tables = $pdo->tables();

// create a database
$pdo->createDatabase('test');

// get database name (from dsn)
$name = $pdo->getDatabaseName();

// export database (mysql only)
$filename = $pdo->export('./'); // ./ = destination folder

// import database (mysql only)
$pdo->import('./backup.sql.gz');

// create
$pdo->run('INSERT INTO table_name (name) VALUES (?)', ['foo']);

// create - multi
$pdo->run('INSERT INTO table_name (name) VALUES (?)', [['foo'], ['bar'], ['baz']]);

// retrieve - PDOStatement
$stmt = $pdo->run('SELECT * FROM table_name');
$stmt = $pdo->run('SELECT * FROM table_name WHERE id = ?', [1]);
$stmt = $pdo->run('SELECT * FROM table_name WHERE id = :id', ['id' => 1]);

// retrieve - single row
$result = $pdo->row('SELECT * FROM table_name WHERE id = ?', [1]);
$result = $pdo->row('SELECT * FROM table_name WHERE id = :id', ['id' => 1]);

// retrieve - single cell
$result = $pdo->cell('SELECT column FROM table_name WHERE id = ?', [1]);
$result = $pdo->cell('SELECT column FROM table_name WHERE id = :id', ['id' => 1]);

// retrieve - all array
$result = $pdo->all('SELECT * FROM table_name');
$result = $pdo->all('SELECT * FROM table_name WHERE id = ?', [1]);
$result = $pdo->all('SELECT * FROM table_name WHERE id = :id', ['id' => 1]);

// update
$pdo->run('UPDATE table_name SET column = ? WHERE id = ?', ['foo', 1]);

// delete
$pdo->run('DELETE FROM table_name WHERE id = ?', [1]);

// .. and all other standard PDO functionality

测试

$ composer test

贡献

请参阅CONTRIBUTING以获取详细信息。

鸣谢

• Lawrence Cherone
• 所有贡献者

许可证

MIT许可证（MIT）。有关更多信息，请参阅许可证文件。