使用DB::select() 里面放所有原生sql语句
$user = DB::select('
SELECT
CODE AS source,
cash AS fee,
id AS order_id,
title,
pay_time
FROM
order
WHERE
STATUS = 3
AND uid = ? order by pay_time desc', [225])
进阶
拼接变量,方便后期传入条件进行筛选。
$condition = ' AND fee <> 0';
$sql = '
SELECT
CODE AS source,
cash AS fee,
id AS order_id,
title,
pay_time
FROM
order
WHERE
STATUS = 3
AND uid = ?'.$condition. ' order by pay_time desc';
// 是否分页
if ($limitCondition) {
$sql .= ' limit ? offset ?';
}
echo $sql;
$user = DB::select($sql, $condition,$limitCondition, [225,6,6]);
// 基础sql 筛选条件 是否全选 用户id 分页参数