查詢構造器
QueryBuilder是一個SQL構造器,用來構造prepare sql。例如:
use EasySwoole\Mysqli\QueryBuilder;
$builder = new QueryBuilder();
//執行條件構造邏輯
$builder->where('col1',2)->get('my_table');
//獲取最后的查詢參數
echo $builder->getLastQueryOptions();
//獲取子查詢
echo $builder->getSubQuery();
//獲取上次條件構造的預處理sql語句
echo $builder->getLastPrepareQuery();
// SELECT * FROM whereGet WHERE col1 = ?
//獲取上次條件構造的預處理sql語句所以需要的綁定參數
echo $builder->getLastBindParams();
//[2]
//獲取上次條件構造的sql語句
echo $builder->getLastQuery();
//SELECT * FROM whereGet WHERE col1 = 2
// 獲取最后插入的insert_id 使用客戶端從swoole mysql獲取
$client->mysqlClient()->insert_id