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
5350
August 12, 2005 07:44AM
4607
August 12, 2005 08:27AM
3069
August 12, 2005 10:56PM
3012
August 13, 2005 05:03AM
3253
September 15, 2005 01:06AM
3018
September 15, 2005 10:13AM
3952
October 03, 2005 08:57AM
6822
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.