DB::rows($sql,$params=[])执行SQL查询并返回多行结果。基于PDO预处理,防止SQL注入。
$rows = DB::rows(
'SELECT * FROM `' . DB_PREFIX . 'article` WHERE cat_id = ? AND status = 1 ORDER BY id DESC LIMIT 10',
[$catId]
);
foreach ($rows as $row) {
echo e($row['title']);
}