Page 1 of 1

Is this possible through php-mysql

Posted: Thu Nov 24, 2005 9:17 am
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

Posted: Thu Nov 24, 2005 10:03 am
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

Solved

Posted: Fri Nov 25, 2005 6:08 am
by dude81
Thank You for the link