MySQL

Reading OUT param in stored procedure

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 497

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Reading OUT param in stored procedure

Aug 29th, 2008

Hi,

Stored proc code below works fine in MySQL command prompt. It returns John because it is in table. However, i can't return or read the Out parametter in PHP. I mean i cant retrieve John. I did ask this in PHP forum but no answer.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
CREATE PROCEDURE `findname`(IN name_in VARCHAR(15), OUT name_out VARCHAR(15))
BEGIN
	SELECT name INTO name_out FROM table WHERE name=name_in;
END;
 
CALL findname('John', @out);
SELECT @out;
CREATE PROCEDURE `findname`(IN name_in varchar(15), OUT name_out varchar(15))
BEGIN
	SELECT name INTO name_out FROM table WHERE name=name_in;
END;

CALL findname('John', @out);
SELECT @out;

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
$query = "CALL findname('John', @err);";
$run = mysql_query("SELECT @err");
$query = "CALL findname('John', @err);";
$run = mysql_query("SELECT @err");

What do i write to check if result is returns John or not?

Thanks

•

Join Date: Jun 2008

Posts: 79

Reputation: varmadba is an unknown quantity at this point

Solved Threads: 8

varmadba

Offline

Junior Poster in Training

Re: Reading OUT param in stored procedure

Sep 4th, 2008

Why cant you run a single query

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 SELECT name FROM table WHERE name=name_in;
 SELECT name FROM table WHERE name=name_in;

Some thing like this....

$sql = "SELECT name FROM table WHERE nam='$name_out'";
$result = mysql_query($sql, $db);
$row = mysql_fetch_row($result);
$name_from_db=$row[0];

if($name_out = $$name_from_db)
{
echo "It's John";
exit;
}

I am not expert in Php though

Last edited by varmadba; Sep 4th, 2008 at 10:11 am.

:- Varma

We are Happy to inform launch of a new site with loads of database related information Site offers wide range of functionality Forums,Blogs,Articles,Editorials and much more
http://www.sqllibrarian.info/

•

Join Date: Apr 2008

Posts: 497

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Re: Reading OUT param in stored procedure

Sep 4th, 2008

Because, i want to learn how to read OUT parameter.

•

Join Date: Jun 2008

Posts: 79

Reputation: varmadba is an unknown quantity at this point

Solved Threads: 8

varmadba

Offline

Junior Poster in Training

Re: Reading OUT param in stored procedure

Sep 4th, 2008

Just My taught

@out variable means you are creating a temporary variable
Temporary variables are connection specific

make sure these both are executed on one connection

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
 $query = "CALL findname('John', @err);";
$run = mysql_query("SELECT @err");
 $query = "CALL findname('John', @err);";
$run = mysql_query("SELECT @err");

Quick Reply to Thread

Show Printable Version

Other Threads in the MySQL Forum

Previous Thread: Please seriously HELP ME!
Next Thread: pass php variables to mysql database

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes