Example of stored procedure in mysql/php | Learning Curve- Perfect Tutorial for the beginers

DELIMITER $$
CREATE PROCEDURE get_employee()
BEGIN
SELECT *
FROM employee;
END $$

above query will create stored procedure through you phpmyadmin.you can see the created stored procedure inside the Routines tab.

in php code use the below code to access the Store procedure

<?php
$linkfirst = mysql_connect('localhost', 'root', '');
if (!$linkfirst) {
   die('Could not connect: ' . mysql_error());
}
mysql_select_db('hello', $linkfirst) or die('Could not select database.');


$rs = mysql_query('CALL get_employee()');
while($row = mysql_fetch_assoc($rs))
{
echo $row['Name']; echo "<br>";
}
?>

<?php

$linkfirst = mysql_connect('localhost', 'root', '');

if (!$linkfirst) {

die('Could not connect: ' . mysql_error());

}

mysql_select_db('hello', $linkfirst) or die('Could not select database.');

$rs = mysql_query('CALL get_employee()');

while($row = mysql_fetch_assoc($rs))

{

echo $row['Name']; echo "<br>";

}