Is this Possible with Mysql??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
dude81
Forum Regular
Posts: 509
Joined: Mon Aug 29, 2005 6:26 am
Location: Pearls City

Is this Possible with Mysql??

Post by dude81 »

Is Binding a database variable possible in mysql??
like we do it with oracle

Code: Select all

$query="BEGIN BEGIN WEB_UTILS_PKG.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;"

Code: Select all

OCIBindByName($stmt, ":V_RESERVATION_STATUS", $RESERVATION_STATUS, 1);
OCIBindByName($stmt, ":V_SEAT_NUMBER", $SEAT_NO, 6);
Thanks
Dude
Post Reply