在PHP中使用Stored Procedure(查詢、新增、修改)

查詢

$query="CALL sp_050q01($member_no)";

$result = mysql_query($query) or die(mysql_error());

( die(mysql_error())可以擷取資料庫端錯誤的訊息)

新增

$VAR_SEQNO =66;

$VAR_ITEMNO = $_POST['item_number'];

$VAR_PERIODS = $_POST['periods'];

$VAR_INVAMT = $_POST['amount'];

$VAR_TAXAMT = $_POST['tax'];

$query = "CALL sp_020i01(" . $VAR_SEQNO . "," . $VAR_ITEMNO . "," . $VAR_PERIODS . "," . $VAR_INVAMT . "," . $VAR_TAXAMT . ")";

$result = mysql_query($query) or die(mysql_error());
(PHP字串相加使用.)

更新

$VAR_tx_id= $_POST['tx_id'];

$VAR_rtext= $_POST['rtext'];

$query="call sp_052u02('$VAR_tx_id',$dp,'$VAR_rtext')";

$result = mysql_query($query) or die(mysql_error());