|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2007-01-16 12:54 UTC] tony2001@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Oct 22 16:00:01 2025 UTC |
Description: ------------ I want to get parameter values of stored procedure in the php variable.. I have submited one procedure of mysql and now i want get value of 'id' in the php variable then how can i do this..?? Is it possible to do this.?? Reproduce code: --------------- create procedure test(OUT id INT) begin select e_id into id from table where name="Hardik"; end; <?php $link = mysqli_connect("localhost","root","mysql","shopping_cart"); $id=0; mysqli_multi_query($link, "call test($id)") mysqli_store_result($link)) mysqli_query($link,$query); echo $id; ?> Expected result: ---------------- my expected result is that the value of '$id' is the id of the person 'Hardik'... Actual result: -------------- It gives an error that can't pass direct value to OUT or INOUT parameter..