ID: 40143
Updated by: [EMAIL PROTECTED]
Reported By: hd4_all at yahoo dot co dot in
-Status: Open
+Status: Bogus
Bug Type: MySQLi related
Operating System: windows 2000 prof.
PHP Version: 5.2.0
New Comment:
MySQL API does not provide any means for that.
Not PHP problem.
Previous Comments:
------------------------------------------------------------------------
[2007-01-16 12:02:37] hd4_all at yahoo dot co dot in
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..
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=40143&edit=1
