尝试执行时PDO bindparam错误 [英] PDO bindparam error when trying to execute

问题描述

大家好，



我的下一个问题，PDO bindparam显示错误：

致命错误：未捕获PDOException：SQLSTATE [42000]：语法错误或访问冲突：1064 SQL语法中有错误;查看与您的MariaDB服务器版本对应的手册，以便在'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' trace：＃0 C：\ xxxx \ ajaxfile.php（41）：PDOStatement-> execute（）＃1 {main}在第41行的C：\ xxx \ ajaxfile.php中抛出

我的尝试：

 $ stmt = $ con> prepare（select * from employees WHERE 1？order by？？limit？，？）; 
 
 $ stmt-> bindParam（1，$ searchQuery，PDO :: PARAM_STR）; 
 $ stmt-> bindParam（2，$ columnName，PDO :: PARAM_STR）; 
 $ stmt-> bindParam（3，$ columnSortOrder，PDO :: PARAM_STR）; 
 $ stmt-> bindParam（4，$ row，PDO :: PARAM_INT）; 
 $ stmt-> bindParam（5，$ rowperpage，PDO :: PARAM_INT）; 
 
 $ stmt-> execute（）; 
 $ data1 = $ stmt-> fetchAll（）; 

解决方案

stmt =

con> prepare（select * from employees WHERE 1？order by？？limit？，？）;

stmt-> bindParam（1，

Hi Everyone,

To my next question, PDO bindparam is showing an error:

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' ' order by 'emp_no' 'asc' limit 0, 10' at line 1 in C:\xxx\ajaxfile.php:41 Stack trace: #0 C:\xxx\ajaxfile.php(41): PDOStatement->execute() #1 {main} thrown in C:\xxx\ajaxfile.php on line 41

What I have tried:

$stmt = $con->prepare("select * from employees WHERE 1 ? order by ? ? limit ?, ?");

$stmt->bindParam(1, $searchQuery, PDO::PARAM_STR);
$stmt->bindParam(2, $columnName, PDO::PARAM_STR);
$stmt->bindParam(3, $columnSortOrder,PDO::PARAM_STR);
$stmt->bindParam(4, $row,PDO::PARAM_INT);
$stmt->bindParam(5, $rowperpage,PDO::PARAM_INT);

$stmt->execute();
$data1 = $stmt->fetchAll();

解决方案

stmt =

con->prepare("select * from employees WHERE 1 ? order by ? ? limit ?, ?");

stmt->bindParam(1,

这篇关于尝试执行时PDO bindparam错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！