Is this possible through php-mysql
Posted: Thu Nov 24, 2005 9:17 am
Is Binding a database variable possible in mysql??
like we do it with oracle
please forget about the prcodeure being called there
Thanks
Dude
like we do it with oracle
Code: Select all
$query="BEGIN BEGIN PROCEDURE.UPDATE_EVENT_RESERVATION ('$company','$xyz,'$ev_id',TRUNC(TO_DATE('$ev_date', 'DD-MON-YY')),'$ev_no','Y','Y',:V_RESERVATION_STATUS,:V_SEAT_NUMBER); END; END;"
OCIBindByName($stmt, ":V_RESERVATION_STATUS", $RESERVATION_STATUS, 1);
OCIBindByName($stmt, ":V_SEAT_NUMBER", $SEAT_NO, 6);Code: Select all
PROCEDUREThanks
Dude