Wallogit.com
2017 © Pedro Peláez
Qb: Simple query builder
Japanese README, (*1)
This was assumed per the provision of the back-end API, a simple PDO query builder. I was created in mind is that the write as short as possible the code., (*2)
$rows = Qb('contact')->toJson();
Just only this you can return a list of the contact table in JSON., (*3)
Though it is to use the raw PDO as it is troublesome, who full-fledged DB library feels overkill function., (*4)
doc/index.html is a reference., (*5)
only require 'qb.php'., (*6)
If you use the Composer is,, (*7)
composer require naga3/qb
Install Now you read in the autoload., (*8)
require_once 'vendor/autoload.php';
sample/contact.php is a sample of a simple contact list. sample/todo.php is a sample of the ToDo list that combines AngularJS. Both samples PDO_SQLITE module is I will work as it is if it is introduced., (*9)
Qb::connect('sqlite:sample.db');
Qb::connect('mysql:host=localhost;dbname=sample', 'user', 'pass');
Connect to the specified DSN., (*10)
$rows = Qb('contact')->toJson();
It will return a list of the contact table in JSON., (*11)
$rows = Qb('contact')->select('name')->select('tel')->toArray();
It will return the name column and tel column of the table contact list in the array., (*12)
$rows = Qb('contact')->select(['name', 't' => 'tel'])->toObject();
name column of the table contact list I returned unchanged. And tel column will return as an object with an alias t., (*13)
$row = Qb('contact')->where('id', 1)->oneArray();
id column of contact table will return one line of 1., (*14)
$row = Qb('contact')->where(1)->oneArray(); // In the case of id column, it can be omitted column specified
$row = Qb('contact')->oneArray('id', 1);
$row = Qb('contact')->oneArray(1);
There is also such shorthand., (*15)
$rows = Qb('contact')->whereGte('status', 1)->whereLike('name', '%Yamada%')->toJson();
In status column of the contact table is 1 or more, it will return the ones that contain "Yamada" in the name., (*16)
$rows = Qb('contact')->join('access', 'access.contact_id = contact.id')->toJson();
INNER JOIN. 'access.contact_id = contact.id' is binding conditions., (*17)
$rows = Qb('contact')->leftJoin('access', 'access.contact_id = contact.id')->toJson();
LEFT OUTER JOIN., (*18)
$id = Qb('contact')->save(['name' => 'Ichiro Suzuki', 'age' => 19]);
to contact table name column is "Ichiro Suzuki", insert the record age column is "19". The return value is the value of the primary key., (*19)
Qb('contact')->where('age', 20)->save(['name' => 'Ichiro Suzuki', 'age' => 19]);
In an attempt to first UPDATE If there is a WHERE clause to INSERT if there is no record of the target., (*20)
Qb('contact')->where('age', 20)->update(['name' => 'Ichiro Suzuki', 'age' => 19]);
Here even if there is no record of the target will not be INSERT., (*21)
Qb('contact')->where('age', 20)->update('name', 'Ichiro Suzuki');
1 column only change you can also be written as this., (*22)
Qb('contact')->where('age', 20)->set('age', 19)->set('name', 'Ichiro Suzuki')->update();
INSERT and from connecting the chain set, you can UPDATE., (*23)
Qb('contact')->where('age', 20)->delete();
age column of contact table will remove all 20 of the record., (*24)
Qb('contact')->delete(1);
id column of contact table will delete a record., (*25)
$rows = Qb('contact')->asc('created_at')->toJson();
It will return a list of the contact table in ascending order of created_at column., (*26)
$rows = Qb('contact')->desc('created_at')->asc('id')->toJson();
It will return a list of the contact table in descending order of created_at column, in ascending order of id., (*27)
$rows = Qb('contact')->offset(10)->limit(5)->toJson();
You get 5 from 10 th in the list of contact table., (*28)
$db = Qb('contact')->db();
You get the raw PDO object. Please, for example, when you put the transaction., (*29)
$options = [ // Primary key 'primary_key' => 'id', // ERRMODE 'error_mode' => PDO::ERRMODE_EXCEPTION, // json_encode options 'json_options' => JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_AMP | JSON_HEX_QUOT, ]; Qb::connect($dsn, $user, $pass, $options);
Qb: Simple query builder
MIT
pdo query builder
Qb: Simple query builder
MIT
pdo query builder
Very simple query builder
MIT
pdo query builder
Very simple query builder
MIT
pdo query builder