How to create Mysql Stored Procedure

Step-1
---------

Create Procedure First

Example
----------

USE DATASERVICE_SAMPLE ;
DROP PROCEDURE If EXISTS getEmployee ;
CREATE PROCEDURE getEmployee(empNo INTEGER) SELECT employeeNumber,lastName,firstName,email FROM Employees where employeeNumber = empNo ;
USE DATASERVICE_SAMPLE ;
DROP PROCEDURE If EXISTS getEmployee2 ;
CREATE PROCEDURE getEmployee2(empNo INTEGER) SELECT employeeNumber,lastName,firstName,email FROM Employees where employeeNumber = empNo ;

Step 1 : save above as the file in some path: $path(test.sql)

Step 2 : go to command prompt mysql -u root -p

Step 3 : run -> source $path (ex: source test.sql)

IN PHP FILE:

$link = mysqli_connect('localhost','root', '', 'DATASERVICE_SAMPLE');

$result = mysqli_query($link,"CALL getEmployee('1002')");
if( $result ){
while( $row = mysqli_fetch_array($result) ){
print_r($row );
}
}