How to call procedure in MySQL to use in PHP?
-
Hi all, i have a procedure below: //==============MySQL======================================= CREATE PROCEDURE `sp_select_customer`(custid int) begin select * from customer where customer_id=custid; end; //================PHP code===================================== $con=mysql_connect("localhost","root","root") or die("Connection is fail."); $db=mysql_select_db("mydatabase",$con); $result=mysql_query("CALL sp_select_customer(9)"); // it's not working when i use CALL PROCEDURE $row=mysql_fetch_array($result); echo $row['0']; //=============================== Please help me! Thanks,
Hy Chan Han
-
Hi all, i have a procedure below: //==============MySQL======================================= CREATE PROCEDURE `sp_select_customer`(custid int) begin select * from customer where customer_id=custid; end; //================PHP code===================================== $con=mysql_connect("localhost","root","root") or die("Connection is fail."); $db=mysql_select_db("mydatabase",$con); $result=mysql_query("CALL sp_select_customer(9)"); // it's not working when i use CALL PROCEDURE $row=mysql_fetch_array($result); echo $row['0']; //=============================== Please help me! Thanks,
Hy Chan Han
What error are you getting?
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
-
What error are you getting?
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
Here is error: ============================= Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\itec\select.php on line 8 ============================= It's not working when procedure use select statement. I use insert statement it's working ok. Thanks,
Hy ChanHan
-
Here is error: ============================= Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\itec\select.php on line 8 ============================= It's not working when procedure use select statement. I use insert statement it's working ok. Thanks,
Hy ChanHan
Try to use
multi_queryinstead ofmysql_query.Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
-
Try to use
multi_queryinstead ofmysql_query.Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
Error appeared: Fatal error: Call to undefined function multi_query() in C:\AppServ\www\itec\select.php on line 5
Hy Chanhan
-
Error appeared: Fatal error: Call to undefined function multi_query() in C:\AppServ\www\itec\select.php on line 5
Hy Chanhan
I have tested in my machine. (Note: I'm using the latest version of PHP and MySQL. )
"; while($thisrow=mysql_fetch_row($result)) { $i=0; while ($i < mysql_num_fields($result)) { $field_name=mysql_fetch_field($result, $i); echo $thisrow[$i] . " "; //Display all the fields on one line $i++; } echo "
"; //put a break after each database entry } ?> Hope it will work in your side too.. Let me know the result.. Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :) -
I have tested in my machine. (Note: I'm using the latest version of PHP and MySQL. )
"; while($thisrow=mysql_fetch_row($result)) { $i=0; while ($i < mysql_num_fields($result)) { $field_name=mysql_fetch_field($result, $i); echo $thisrow[$i] . " "; //Display all the fields on one line $i++; } echo "
"; //put a break after each database entry } ?> Hope it will work in your side too.. Let me know the result.. Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)Hi, Thank you very much for your code, now it's working very well in my site. :rose:
Hy ChanHan
-
I have tested in my machine. (Note: I'm using the latest version of PHP and MySQL. )
"; while($thisrow=mysql_fetch_row($result)) { $i=0; while ($i < mysql_num_fields($result)) { $field_name=mysql_fetch_field($result, $i); echo $thisrow[$i] . " "; //Display all the fields on one line $i++; } echo "
"; //put a break after each database entry } ?> Hope it will work in your side too.. Let me know the result.. Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)Hello again, When i refreshed 4 or 5 times i appeared this error message: why????? PROCEDURE bbg.sp_select_customer can't return a result set in the given context
Hy ChanHan
-
Hello again, When i refreshed 4 or 5 times i appeared this error message: why????? PROCEDURE bbg.sp_select_customer can't return a result set in the given context
Hy ChanHan
Hy Chanhan wrote:
PROCEDURE bbg.sp_select_customer can't return a result set in the given context
I will check again and will let you know..
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
-
Hi, Thank you very much for your code, now it's working very well in my site. :rose:
Hy ChanHan
Hy Chanhan wrote:
Thank you very much for your code, now it's working very well in my site.
If my code is useful for you, please vote my message. thanks. :)
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
-
Hy Chanhan wrote:
PROCEDURE bbg.sp_select_customer can't return a result set in the given context
I will check again and will let you know..
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
seem like i forget to close the connection.. try to add the code for closing connection..
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
-
seem like i forget to close the connection.. try to add the code for closing connection..
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)
It's still not working. Error is the same above. :(
Hy ChanHan