|
|
Stored procedure:
/* =====================================================
Author: [ amper ]
Create date: [ 2007-02-17 ]
Description: [ select record from EmployeeFacts table ]
======================================================= */
DROP PROCEDURE proc_getempfact;
CREATE PROCEDURE proc_getempfact
(IN p_empno INT)
BEGIN
/* If p_empno = -1, all records are selected */
IF (p_empno <> -1) AND
(EXISTS (SELECT * FROM Employees WHERE EmpNo=p_empno))
THEN
SELECT empno, fact, crdate)
FROM employeefacts WHERE EmpNo=p_empno;
ELSE
SELECT empno, fact, crdate)
FROM employeefacts;
END IF;
END
|
Sample code for "select_employee_fact.php" page:
$con = mysql_connect("localhost","george","george");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
# select database
mysql_select_db("colombo", $con);
# call MySQL stored procedure
$sql="call proc_getempfact(".$_POST["no1"].")");
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo $row['empno'] . " " . $row['fact'];
echo "[br]";
}
mysql_close($con)
|
|