关于用php调用mysql分页存储过程的例子老是出错？分页的存储过程是正确的，
调用的php代码是这样写的
PHP code:
define('CLIENT_MULTI_RESULTS', 131072);
$mysqli = new mysqli("localhost", "root", "123456", "eimage");
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
if ($result = $mysqli->query("call P_viewPage("scms_product","*","id","id>70","id desc","3","0","3","1",@$TotalCount,@$TotalPageCount)")) {
while($row = $result->fetch_row())
{
echo $row[2]."<br>";
}
}
运行php的时候就会报错
Parse error: syntax error, unexpected T_STRING in D:\wamp\www\test1.php on line 14
提示是这一行出现错误if ($result = $mysqli->query("call P_viewPage("scms_product","*","id","id>70","id desc","3","0","3","1",@$TotalCount,@$TotalPageCount)"))
问下 高手我的问题出现在哪里？非常感谢
你的引号太乱了，整理一下，并且需要加上转义符。
SP代码是什么，直接在MYSQL中调用是否正常
mysql种调用正常，就是php种调用就不正常了
存储过程的代码是
SQL code
Code highli
<!--购买数量-->
<div class='buyinfo'>
<table width='auto'>
<tr>
<td><span>购买数量：</sp ......
