Is this possible through php-mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

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 through php-mysql

Post by dude81 »

Is Binding a database variable possible in mysql??
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);
please forget about the prcodeure

Code: Select all

PROCEDURE
being called there

Thanks
Dude
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post by Jenk »

I've got absolutely no clue what you mean by variable binding (this is me not knowing, not you explaining poorly)

But does this page explain anything at all?

http://dev.mysql.com/doc/refman/5.0/en/ ... types.html
User avatar
dude81
Forum Regular
Posts: 509
Joined: Mon Aug 29, 2005 6:26 am
Location: Pearls City

Solved

Post by dude81 »

Thank You for the link
Post Reply