mysqli_fetch_array while loop columns

by

Get all the values from MySQL:

    $post = array();
    while($row = mysql_fetch_assoc($result))
    {
        $posts[] = $row;
    }

Then, to get each value:

<?php 
     foreach ($posts as $row) 
        { 
            foreach ($row as $element)
            {
                echo $element."<br>";
            }
        }
?>

To echo the values. Or get each element from the $post variable

More Related Contents:

  1. How do I iterate over the results in a MySQLi result set?
  2. mysqli query results to show all rows
  3. SELECT COUNT(*) AS count – How to use this count
  4. mysqli bind_param() expected to be a reference, value given
  5. Should I manually check for errors when calling “mysqli_stmt_prepare”?
  6. mysqli_real_escape_string() expects exactly 2 parameters, 1 given
  7. parameters in MySQLi
  8. Retrieving Multiple Result sets with stored procedure in php/mysqli
  9. How do I count query result rows?
  10. How do you use IN clauses with mysqli prepared statements [duplicate]
  11. What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
  12. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  13. How to fetch all in assoc array from a prepared statement?
  14. Fatal error: Call to undefined function mysqli_result()
  15. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  16. Why I am getting an error when using w3school tutorial? [duplicate]
  17. Using wildcards in prepared statement
  18. New containing div after every 3 records
  19. mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
  20. How to remove the fatal error when fetching an assoc array
  21. Fatal error: Call to undefined method mysqli_stmt::get_result()
  22. PHP MySQLi Multiple Inserts
  23. Fatal error: Call to a member function prepare() on a non-object in
  24. Call to undefined method mysqli_result::fetch()
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. prepared parameterized query with PDO
  27. How to make mysqli connect function?
  28. Dynamically bind mysqli_stmt parameters and then bind result
  29. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  30. How to insert into MySQL using mysqli

Leave a Comment