public function list($user_id,$page,$size){
if($size > 100) {
throw new Exception('Page limited 100', Error::PAGE_LIMIT_EXCEED);
}
$sql = "SELECT * FROM `article` WHERE `user_id`=:user_id LIMIT :offset OFFSET :limit";//LIMIT :limit , :offset
$limit = ($page-1)*$size;
// var_dump($limit);
$limit = $limit < 0 ? 0 : $limit;
$stmt = $this->_db->prepare($sql);
var_dump($stmt->bindParam(':user_id', $user_id,PDO::PARAM_INT));//这里一定要设置参数类型,PDO::PARAM_INT,不然进入sql后悔变成带有引号的字符串,造成sql语句报错
var_dump($user_id);
var_dump($stmt->bindParam(':limit', $limit,PDO::PARAM_INT));
var_dump($limit);
var_dump($stmt->bindParam(':offset', $size,PDO::PARAM_INT));
var_dump($size);
var_dump($stmt->execute());
var_dump($stmt->errorInfo());
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
// print_r($data);
return $data;
}
PHP PDO execute总是返回false
最新推荐文章于 2022-12-06 16:51:36 发布