return multiple rows from mySQL Stored PROC

[wayneforrest]

I am unable to return multiple rows from a stored procedure in php.

When I call the stored procedure using "Navicat", I do see multiple
results, yet when I call it from PHP using mysqli or mysql,

I only get one record :mad:

My Stored procedure has the following format:

BEGIN
SELECT name,surname from users;
END;

I have googled but found no solution, one mentioned PDO works,
but I would rather use the standard mysqli;

[laserlight]

wayneforrest wrote:

When I call the stored procedure using "Navicat", I do see multiple
results, yet when I call it from PHP using mysqli or mysql,

I only get one record

Show the relevant PHP code.

wayneforrest wrote:

I have googled but found no solution, one mentioned PDO works,
but I would rather use the standard mysqli;

Both MySQLi and PDO can be considered standard in this context.

[wayneforrest]

$mysqli = mysqli_init();
$mysqli->real_connect($db_host,$db_username,$db_password, $db_database);
if (mysqli_connect_errno())
{
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
if($mysqli->real_query ($cmdText))
{
if($objResult = $mysqli->store_result())
{
while($row = $objResult->fetch_assoc())
{
print_r($row);
$name = $row->name;
$surname = $row->surname;
echo "<br>Name: " . $name;
echo "<br>";
echo "Surname:" . $surname;
$ok = true;
}
$objResult->free_result();
}
else
{
print "no results found";
}
}
else
{
print $mysqli->error;
}
$mysqli->close();

[Randy_Jackson]

wayneforrest;10922134 wrote:

$mysqli = mysqli_init();

                                $ok = true;

What does $ok refer to? What's it being used for?

[wayneforrest]

Ok is used to know when the function succeeds.
it is returned via the function .... return $ok;