php如何获取存储过程中的out参数变量

Question

$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>0','id desc','3','0','10','2',@$TotalCount,@$TotalPageCount)")) {  while($row = $result->fetch_row())
  {
  echo $row[2]."<br>";
  }
   
}上面是调用mysql分页存储过程的php代码，php如何获取@$TotalCount,@$TotalPageCount这两个out类型参数的值，如何来做

Answer 1

mysql_query("select @$TotalCount,@$TotalPageCount");

Answer 2

mysql_query("select @$TotalCount,@$TotalPageCount");

Answer 3

$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>0','id desc','3','0','10','2',@$TotalCount,@$TotalPageCount)")) {  while($row = $result->fetch_row())
  {
  echo $row[2]."<br>";
  }
   
}if($rs=$mysqli->query("select @$TotalCount,@$TotalPageCount")){
   while($rows=$rs->fetch_row()){
    echo $rows[0];
   }
}我要输出@$TotalCount的值，这样写对吗，怎么是输出是空的

Answer 4

谁能够帮我看看说的详细一点，这两个变量的值怎么获取@$TotalCount,@$TotalPageCount

Answer 5

$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>0','id desc','3','0','10','2',@$TotalCount,@$TotalPageCount)")) {if($rs=$mysqli->query("select @$TotalCount,@$TotalPageCount")){
   while($rows=$rs->fetch_row()){
    echo $rows[0];
   }
}
   
}

Answer 6

$mysqli->query("call eimage.P_viewPage('scms_product','*','id','id>0','id desc','3','0','10','2',@$TotalCount,@$TotalPageCount)");
$res=$mysqli->query("select @$TotalCount,@$TotalPageCount");
$row=$res->fetch_row();
echo $row[0];怎么提示是这个错误
Fatal error: Call to a member function fetch_row() on a non-object in D:\wamp\www\test1.php on line 17
那位高手再帮我瞧瞧，究竟错再哪里？