Contributing

License

Installation

composer require co0lc0der/simple-query-builder

"co0lc0der/simple-query-builder":"*"

How to use

Editconfig.php and set the parameters up. Choose DB driver, DB name etc

$config =require_once__DIR__ .'/config.php';

Use composer autoloader

require_once__DIR__ .'/vendor/autoload.php';useco0lc0der\QueryBuilder\Connection;useco0lc0der\QueryBuilder\QueryBuilder;

InitQueryBuilder withConnection::make()

$query =newQueryBuilder(Connection::make($config['database']));// $printErrors = false// for printing errors (since 0.3.6)$query =new QueryBuilder(Connection::make($config['database']),true)

Usage examples

Select all rows from a table

$results =$query->select('users')->all();

SELECT*FROM`users`;

Select rows with two conditions

$results =$query->select('users')->where([  ['id','>',1],'and',  ['group_id',2],])->all();

SELECT*FROM`users`WHERE (`id`>1)AND (`group_id`=2);

Update a row

$query->update('posts', ['status' =>'published'])        ->where([['YEAR(`updated_at`)','>',2020]])        ->go();

UPDATE`posts`SET`status`='published'WHERE (YEAR(`updated_at`)>2020);

ToDo