查詢構(gòu)造器

QueryBuilder是一個(gè)SQL構(gòu)造器，用來構(gòu)造prepare sql。例如：

use EasySwoole\Mysqli\QueryBuilder;

$builder = new QueryBuilder();

//執(zhí)行條件構(gòu)造邏輯
$builder->where('col1',2)->get('my_table');

//獲取最后的查詢參數(shù)
echo $builder->getLastQueryOptions();

//獲取子查詢
echo $builder->getSubQuery();

//獲取上次條件構(gòu)造的預(yù)處理sql語句
echo $builder->getLastPrepareQuery();
// SELECT  * FROM whereGet WHERE  col1 = ? 

//獲取上次條件構(gòu)造的預(yù)處理sql語句所以需要的綁定參數(shù)
echo $builder->getLastBindParams();
//[2]

//獲取上次條件構(gòu)造的sql語句
echo $builder->getLastQuery();
//SELECT  * FROM whereGet WHERE  col1 = 2 

// 獲取最后插入的insert_id 使用客戶端從swoole mysql獲取
$client->mysqlClient()->insert_id