stored procedure in mysqlLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

Example of stored procedure in mysql/php

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>";

}