PHP mysql stored procedure execution problem
hi all
i am having problem with executing stored procedure with php any one please advice me
I have to use php 4.3.10 and mysql 5.0.4
i am using below SP and PHP script.Please advice me
SP
create procedure helloprocedure()
begin
select 'Hello Procedure 2' ;
end
PHP Script
<?php
$link = mysql_connect('localhost', 'root', '1234',);
if (!$link) { die('Could not connect: ' . mysql_error()); }
echo 'Connected successfully';
$qry=mysql_query("call helloprocedure()") or die(mysql_error());
$rs=mysql_fetch_object($qry);
print_r($rs);
?>
Please advice me
Subject
Views
Written By
Posted
PHP mysql stored procedure execution problem
5377
August 12, 2005 07:44AM
4623
August 12, 2005 08:27AM
3079
August 12, 2005 10:56PM
3028
August 13, 2005 05:03AM
3268
September 15, 2005 01:06AM
3032
September 15, 2005 10:13AM
3965
October 03, 2005 08:57AM
6838
October 11, 2005 07:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.