Re: Calling MySQL(5) Stored Procedures from PHP(5)

[Johny Pukhrambam]

//Say following is the store procedure you have

DELIMITER //
DROP PROCEDURE IF EXISTS yourdbname.gsp_GetCountryList //
CREATE PROCEDURE yourdbname.gsp_GetCountryList()
BEGIN
SELECT Id,strCountryName from youtable;
END//

//the above has to be run on mysql prompt


//change the php variables according to your setting

<?php
function iconnect()
{
$mysqli = new mysqli($YOURHOST, $YOURUSERNAME, $YOURPASSWORD, $YOURDATABASE);

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
return $mysqli;
}

$retval=iconnect();

$sql1 = "call sp1()";
$query1 = $retval->query($sql1);
while ($data1 = $query1->fetch_row())
{
echo "<br />\n".$data1[0].":".$data1[1];
}

//*************OR*****************


$sql1 = "call sp1()";
$query1 = $retval->query($sql1);
$data1 = $query1->fetch_row();
while ($data1 = $query1->fetch_array())
{
echo "<br />\n".$data1['fiendname1'].":".$data1['fiendname2'];
}
?>


Hope this will help you!!!!! NJOI