SQL code:
$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ÀàÐͲÎÊýµÄÖµ£¬ÈçºÎÀ´×ö
mysql_query("select @$TotalCount,@$TotalPageCount");
mysql_query("select @$TotalCount,@$TotalPageCount");
SQL code:
$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-