php调用存储过程执行多次,php执行多个存储过程

标签：

$viewPages = 0;

$db = new mysqli(‘localhost‘,$MYSQL_USER,$MYSQL_PASS,$MYSQL_DB);

if (!mysqli_connect_errno()){

$sql = "call proc_getrelativeviewids(‘201605101715444261‘)";

$result = $db->query($sql);

if($result) {

if($row= $result->fetch_assoc()){

$count = $row[‘cnt‘];

}

if (!empty($count))

$viewPages = ceil($count/PAGE_SIZE);

var_dump($viewPages);

$result->close();

$db->next_result();

$sql = "call proc_getrelativeviewids(‘201605101715444261‘)";

$result = $db->query($sql);

}

if($result) {

if($row= $result->fetch_assoc()){

$count = $row[‘cnt‘];

}

if (!empty($count))

$viewPages = ceil($count/PAGE_SIZE);

var_dump($viewPages);

$result->close();

$db->next_result();

}

}

$db->close();

标签：