public static function goodsList $DB = SQLDB; Assume $DB is already defined as a database connection object $offset = 1 - 1 10; $name = isset$Dataname $DB-escape_string$Dataname ; $DB = S

public static function goodsList(){ $DB = SQL::DB(); // Assume $DB is already defined as a database connection object $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $limit = 10; $offset = ($page - 1) * $limit; $name = isset($_GET['name']) ? $DB->escape_string($_GET['name']) : '';

$result = $DB->select('goods', ['gid', 'money', 'name', 'note'], "name LIKE '%$name%'", "$offset, $limit");

$goods = array();
if ($result) {
    dier([
        'code' => 1,
        'msg' => '查询成功',
        'data' => $result,
    ]); 
} else {
    dier([
        'code' => -1,
        'msg' => '查询失败',
    ]); 
}

}