นำมาฝาก : ตัวอย่าง php เรียกใช้ storeprocedure แบบมีการคืนค่ากลับ
<?php $mysqli = new mysqli("localhost","user","password","db"); if(mysqli_connect_errno()){ printf("Connect failed : %s\n",mysqli_connect_error()); exit(); }else{ //calling storeprocedure $sql = "use db;"; $mysqli->query($sql); $sql = "CALL sp_search_member(@NumRec);"; $results = $mysqli->query($sql); if($mysqli->errno){ die('Ececution failed :'.$mysqli->errno.' : '.$mysqli->error); }else{ //printf('Stored procedure execution succeeded\n'); $sql = "select @iNumRec as iNumRec;"; $results = $mysqli->query($sql); while($row = $results->fetch_object()){ printf("%s\n",$row->iNumRec); } } } ?>
|