PHP mysqli: next_result() function

mysqli_next_result() function / mysqli::next_result

The mysqli_next_result() function / mysqli::next_result prepares the next result set from mysqli_multi_query().


Object oriented style

bool mysqli::next_result ( void )

Procedural style

bool mysqli_next_result ( mysqli $link )


Name Description Required/Optional
link A link identifier returned by mysqli_connect() or mysqli_init() Required for procedural style only and Optional for Object oriented style

Usage: Procedural style



Name Description Required/Optional
connection Specifies the MySQL connection to use Required

Return value:

Returns TRUE on success or FALSE on failure.

Version: PHP 5, PHP 7


$con = mysqli_connect("localhost","user1","datasoft123","hr");


if (mysqli_connect_errno($con)){
  echo "Failed to connect to MySQL: " . mysqli_connect_error();

$sql = "SELECT emp_name FROM emp;SELECT country FROM emp";

if (mysqli_multi_query($con,$sql)){
    // Store first result set
    if ($result=mysqli_store_result($con)){
      while ($row=mysqli_fetch_row($result)){
        print $row[0];
        print "\n";
  }while (mysqli_next_result($con));


See also

PHP Function Reference

Previous: multi_query
Next: options

Follow us on Facebook and Twitter for latest update.

PHP: Tips of the Day

PHP: How to generate a random, unique, alphanumeric string for use in a secret link?

Security Notice: This solution should not be used in situations where the quality of your randomness can affect the security of an application. In particular, rand() and uniqid() are not cryptographically secure random number generators. See Scott's answer for a secure alternative.

If you do not need it to be absolutely unique over time:

md5(uniqid(rand(), true))

Otherwise (given you have already determined a unique login for your user):

md5(uniqid($your_user_login, true))

Ref : https://bit.ly/31fd9wa


We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook