laravel 使用原生sql语句

使用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 分页参数