dimensi0n/simple-query

Provides a simple and easy to use query builder

1.0.1 2021-06-10 07:59 UTC

Requires (Dev)

• phpdocumentor/phpdocumentor: ^2.9
• phpunit/phpunit: ^9.1

MIT

• Erwan ROUSSEL

README

Provides a simple and easy to use query builder

Install it :

composer require dimensi0n/simple-query

Initialize it like a PDO instance :

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

Create a table :

$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
)
*/

Drop a table :

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

Select :

$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

Insert :

$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')

Update :

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

Delete :

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

For further information check the API docs : dimensi0n.github.io/simple-query/api