README

Installation

composer require duc/query-builder:dev-main

How to use

Use Composer Autoloader:

require_once __DIR__ . '/vendor/autoload.php';
use Duc\QueryBuilder\QueryBuilder;

Change your information for $config:

$servername = "localhost";
$dbname = "query_builder_test";
$username = "root";
$password = "12345678";

$config = [
    'host' => $servername,
    'dbname' => $dbname,
    'username' => $username,
    'password' => $password
];

Initialize QueryBuilder:

$db = new QueryBuilder($config);

Usages:

Select

// Trả về dữ liệu từ CSDL
$data = $db->select('id', 'name')->from('users')->get();
print_r($data);     //Dữ liệu lấy được

// Chạy query rồi trả về query đó
$query = $db->select('id', 'name')->from('users')->execute();
print_r($query);     //SELECT id, name FROM users

Insert

//INSERT INTO users (id, name) VALUES (2, 'duc'), (3, 'hoa')
$query = $db->insert('users', array('id', 'name'), 'VALUES', array(2, 'duc'), array(3, 'hoa'))->execute();   

Delete

//DELETE FROM users WHERE id=4
$query = $db->delete('users', 'id', 4)->execute();

Update

//UPDATE users SET name = 'trung' WHERE id = 1
$query1 = $db->update('users', array('name' => 'trung'), array('id', '=', 1))->execute();

//UPDATE users SET name = 'trung', age = 1 WHERE id = 1
$query2 = $db->update('users', array('name' => 'trung', 'age' => 1), array('id', '=', 1))->execute();