BEGIN

DECLARE var1 INT DEFAULT 0;

DECLARE done INT DEFAULT 0;

DECLARE cardsortID INT DEFAULT 0;

DECLARE alart INT DEFAULT 0;

DECLARE cur CURSOR FOR (SELECT sortID, alarmCount FROM monitoring WHERE hide=1 ORDER BY sortID ASC);

open cur;

FETCH cur INTO cardsortID, alart;

WHILE done <> 1 DO

SELECT cardName,cardsortID,count(*) AS leftCount,alart as cardCount FROM cards

WHERE endDate>now() AND cardStatus=3 AND operator=cardsortID;

FETCH cur INTO cardsortID, alart;

END WHILE;

CLOSE cur;

END

$dblink=mysqli_connect('localhost','root','root')

or die("can not connect to mysql");

mysqli_select_db($dblink,$db)

or die("can not select salecards");

//$query=mysqli_multi_query($dblink,"CALL proc_AlarmCount()")or die("Invalid query: " . mysqli_error());

$query=mysqli_query($dblink,"CALL proc_AlarmCount()")or die("Invalid query: " . mysqli_error());

//var_dump($query);

if ($query) {

$i=1;

mysqli_next_result($dblink);

do {

if ($result = mysqli_store_result($dblink)) {

while ($row = mysqli_fetch_assoc($result)) {

var_dump($row);

}

mysqli_free_result($result);

}

printf("
$i-----------------
");

$i++;

} while (mysqli_next_result($dblink));

}

//$row=mysqli_fetch_row($result);

//var_dump($row);

mysqli_close($dblink);

ITPub博客

mysql存储过程中的游标循环和PHP获取结果集