duc / query-builder
There is no license information available for the latest version (dev-main) of this package.
composer package for simple query builder
dev-main
2024-02-27 06:27 UTC
Requires
- php: >=7.0
- ext-pdo: *
This package is auto-updated.
Last update: 2024-09-27 07:45:54 UTC
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();