Question

mysql语句中添加php变量

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '".$page.",2' at line 1

SELECT Id, state, totalName, property, startTime, amountIn, amountOut, balanceIn, balanceOut FROM contract LIMIT ".$page.",2
以上是问题描述
那句代码是$query = $this->db->query('SELECT Id, state, totalName, property, startTime, amountIn, amountOut, balanceIn, balanceOut FROM contract LIMIT ".$page.",2');

Answer 1

一看就是标点符号加错了，试试下面这句

$query = $this->db->query('SELECT Id, state, totalName, property, startTime, amountIn, amountOut, balanceIn, balanceOut FROM contract LIMIT  '.$page.',2');

或者

$query = $this->db->query("SELECT Id, state, totalName, property, startTime, amountIn, amountOut, balanceIn, balanceOut FROM contract LIMIT  $page,2");

Answer 2

$query = $this->db->query('SELECT Id, state, totalName, property, startTime, amountIn, amountOut, balanceIn, balanceOut FROM contract LIMIT '.$page.',2');

单引号里面不能解析变量，需要用单引号分割