0

Hi. I'm currently trying my hands on PHP and MySQL.
I understand how to retrieve results from SELECT statements in PHP? However, I'm not exactly sure of how to do it when a procedure call is made e.g.

$query = "CALL mach_validity($student_id, @result)";
[B]if[/B] ($result = $mysqli->query($query)
{ [B]while[/B]($row = $result->fetch_assoc())
   { $ returned_val =$row['@result']}
}

...(code continues)
1 row is expected from the CALL statement so there may be no need of the While Loop.
Can someone please help?

2
Contributors
2
Replies
3
Views
10 Years
Discussion Span
Last Post by tunday
0

It's been helpful. I've decided to use IN parameters only while declaring local variables in the procedure to receive the values I need. I then add a SELECT statement of these variables within the procedure.Thank you for your help. It got me far.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.