Setting MySQL procedure results to PHP variables

Question

I am trying to set the two outputs from this MySQL stored procedure as PHP variables:

$result = mysql_query("CALL mst2('$q', @eset, @leng)");
if (!$result) {  
  die('Invalid query: ' . mysql_error());
} 

while($row = @mysql_fetch_assoc($result))
{
debug($row);

}
$eset = $row->{'@eset'};
$length= $row->{'@leng'};

The last two line are throwing an error Trying to get property of non-object . Does anybody know the proper way to do this?

$row is an associative array so you need to use $row['indexName'] to access the values stored there. — Saladin Akara
– Saladin Akara, Commented Dec 6, 2012 at 0:52
It is cause $row is probably false on these two last lines cause it is after the while loop which is conditioned by it evaluating to true. So try to put these lines inside the while or get rid of the while as I am not sure if it is really needed. — clime
– clime, Commented Dec 6, 2012 at 0:53
Also, the mysql_ functions are now deprecated, you should be using mysqli_ instead. — Saladin Akara
– Saladin Akara, Commented Dec 6, 2012 at 0:54
@clime I tried getting rid of the loop but it threw another error : Undefined variable: row', I guess you can't reference the associative array outside of the loop. When I put the statement inside the loop though, the $eset` doesn't get set to the proper value, it instead remains the default value which is '' — Mike
– Mike, Commented Dec 6, 2012 at 1:03
@Mike It should be the column name you want to extract from the results of your query. — Saladin Akara
– Saladin Akara, Commented Dec 6, 2012 at 2:15

Petrogad · Accepted Answer · 2012-12-06 01:01:28Z

2

mysql_fetch_object instead of mysql_fetch_assoc should fix your query up.

Secondly though you should really look at either using mysqli_ or pdo statements.

Links here:

answered Dec 6, 2012 at 1:01

Petrogad

4,4335 gold badges41 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike Over a year ago

Petrogad, I attempted the mysqli_ approach, I got stuck with that about 2 hours ago: (stackoverflow.com/questions/13733873/…) I also tried your suggestion with mysql_fetch_object, but I had the same issues as I described to clime above.

Mike · Accepted Answer · 2012-12-06 01:24:53Z

1

Here's how I got it to work with mysql_query:

$result = mysql_query("CALL mst2('$q', @eset, @leng)");
$result = mysql_query("SELECT @eset, @leng");
if (!$result) {  
  die('Invalid query: ' . mysql_error());
} 

while($row = @mysql_fetch_object($result))
{
$eset = $row->{'@eset'};
}

right after the procedure I called a SELECT statement, then in the while loop, the $eset variable gets set properly.

answered Dec 6, 2012 at 1:24

Mike

8253 gold badges12 silver badges30 bronze badges

1 Comment

Petrogad Over a year ago

One other thing i'd mention, when you do things like @mysql_fetch_object; you're essentially suppressing error messages (which is costly in PHP) and will be slower.

Collectives™ on Stack Overflow

Setting MySQL procedure results to PHP variables

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related