README

提供简单易用的查询构建器

安装它

composer require dimensi0n/simple-query

像PDO实例一样初始化它

use SimpleQuery\QueryBuilder;
$queryBuilder = new QueryBuilder('mysql:host=localhost;dbname=test', $user, $pass);

创建一个表

$queryBuilder->create('users', [
    'username' => ['type' => 'varchar (15)', 'notNullable' => true, 'unique' => true],
    'password' => ['type' => 'varchar (200)'],
    'age' => ['type' => 'int', 'default' => 20]
]); 
/* CREATE TABLE IF NOT EXISTS ( 
    id INTEGER PRIMARY KEY, 
    username VARCHAR (15) NOT NULL UNIQUE,
    password VARCHAR (200),
    age INTEGER DEFAULT 20
)
*/

删除一个表

$queryBuilder->dropTable('users'); // DROP TABLE IF EXISTS users

选择

$statement = $queryBuilder->select('users', ['id', 'username', 'age', 'password']); // SELECT id, username, age, password FROM users
$statement = $queryBuilder->select('users', ['id', 'username', 'age', 'password'], ['age' => 16]); // SELECT id, username, age, password FROM users WHERE age = 17;
$statement->fetchAll(); // select returns a PDOStatement

插入

$queryBuilder->insert('users', ['username' => 'erwan', 'age' => 16, 'password' => 'this_is_a_secure_password']); // INSERT INTO users (username, age, password) VALUES ('erwan', 16, 'this_is_a_secure_password')

更新

$queryBuilder->update('users', ['age' => 17], ['username' => 'erwan']); // UPDATE users SET age = 17 WHERE username = erwan

删除

$queryBuilder->delete('users', ['age' => 17]); // DELETE users WHERE age = 17

更多信息请查看API文档： dimensi0n.github.io/simple-query/api

dimensi0n / simple-query

维护者

详细信息

README