MySQL Forums
Forum List  »  Stored Procedures

PHP mysql stored procedure execution problem
Posted by: vibra narayanan
Date: August 12, 2005 07:44AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
PHP mysql stored procedure execution problem
5350
August 12, 2005 07:44AM


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.