|
|
Stored procedure:
/* =====================================================
Author: [ amper ]
Create date: [ 2007-02-18 ]
Description: [ add record to EmployeeFacts table ]
======================================================= */
DROP PROCEDURE proc_addempfact;
CREATE PROCEDURE proc_addempfact
(IN p_empno INT, IN p_txt VARCHAR(140), OUT v_status INT)
BEGIN
DECLARE EXIT HANDLER FOR NOT FOUND, SQLEXCEPTION,
SQLWARNING SET v_status = 1;
SET v_status = 0;
INSERT INTO employeefacts (empno, fact, crdate)
VALUES (p_empno, p_txt, CURDATE());
END
|
Sample code for "add_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_addempfact(".$_POST["no1"].",'".$_POST["txt1"]."',@status)");
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
|
|