mysqli query results to show all rows

by

Just replace it with mysqli_fetch_array or mysqli_result::fetch_array 🙂

while( $row = $result->fetch_array() )
{
    echo $row['FirstName'] . " " . $row['LastName'];
    echo "<br />";
}

Almost all mysql_* functions have a corresponding mysqli_* function.

More Related Contents:

  1. How do I iterate over the results in a MySQLi result set?
  2. mysqli_fetch_array while loop columns
  3. php nested while loop. Inner loop works only once [closed]
  4. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  5. Using while in for loop (PHP) [closed]
  6. Can I mix MySQL APIs in PHP?
  7. How to change mysql to mysqli?
  8. Best way to INSERT many values in mysqli?
  9. Call to a member function bind_param() on a non-object [duplicate]
  10. MySQLi prepared statements error reporting [duplicate]
  11. How can I get an unknown username given an ID?
  12. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  13. mysqli_query() expects parameter 1 to be mysqli, object given
  14. MySQLi count(*) always returns 1
  15. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  16. php/mysql with multiple queries
  17. Use one bind_param() with variable number of input vars
  18. Using Mysqli bind_param with date and time columns?
  19. PHP UPDATE prepared statement
  20. Inserting data to table (mysqli insert) [duplicate]
  21. SELECT * FROM in MySQLi
  22. How to populate HTML dropdown list with values from database
  23. Mysqli fetch_assoc vs fetch_array
  24. Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]
  25. Is mysqli extension enabled in this php configuration?
  26. Unknown database error in PHP but it exists in PHPMyAdmin
  27. Can I blindly replace all mysql_ functions with mysqli_?
  28. Is mysqli_real_escape_string safe?
  29. Call to undefined function mysqli_result::num_rows()
  30. Strange problem with the length of the field gotten from database [duplicate]

Leave a Comment