Introduction

方法名不区分大小写

A SAME TO B

Examples

Example #1 Asf\Db::QBS()

<?php
// SELECT * FROM `test` a

$select = Asf\Db::QBS();
$select
->cols()
->from('test', 'a');

Example #2 Asf\Db::QBI()

<?php
use Asf\Db;

// INSERT INTO `test` SET `user` = ? [BVALUES] lisi2

$insert = Db::QBI();
$insert->table('test')->set('user', 'lisi2');

// INSERT IGNORE INTO `test` SET `user` = ? [BVALUES] lisi2

$insert = Db::QBI(true);
$insert->table('test')->set('user', 'lisi2');

Example #3 Asf\Db::QBU()

<?php
// UPDATE `test` SET `user` = ? where `pass` like ? [BVALUES] lisi2, %11111%

$update = Asf\Db::QBU();
$update->table('test')->set('user', 'lisi2')->like('pass', '%11111%');

Example #4 Asf\Db::QBD()

<?php
// DELETE `test` WHERE `user` = ? AND `pass` like ? [BVALUES] lisi2, %11111%

$delete = Asf\Db::QBD();
$delete->from('test')->where('user', 'lisi2')->like('pass', '%11111%');