How to echo out table rows from the db php

Question

i want to echo out everything from a particular query   If echo  res I only get one of the strings   If I change the 2nd mysql result argument I can get the 2nd  2rd etc but what I want is all of them  echoed out one after the other   How can I turn a mysql result into something I can use   I tried    query  SELECT   FROM MY TABLE    results   mysql query  query    res   mysql result  results  0    while   res- gt fetchInto  row         echo   lt form id    row 0    name    row 0    method post action      gt  lt td style   border-bottom 1px solid black   gt  row 0  lt  td gt  lt td style   border-bottom 1px solid black   gt  lt input type hidden name   remove   value    row 0    gt  lt input type submit value Remove gt  lt  td gt  lt tr gt  lt  form gt  n

User · Answer

All of the snippets on this page can be dramatically reduced in size.

The mysqli result set object can be immediately fed to a foreach() (because it is "iterable") which eliminates the need to maked iterated _fetch() calls.

Imploding each row will allow your code to correctly print all columnar data in the result set without modifying the code.

$sql = "SELECT * FROM MY_TABLE";
echo '<table>';
    foreach (mysqli_query($conn, $sql) as $row) {
        echo '<tr><td>' . implode('</td><td>', $row) . '</td></tr>';
    }
echo '</table>';

If you want to encode html entities, you can map each row:

implode('</td><td>' . array_map('htmlspecialchars', $row))

If you don't want to use implode, you can simply access all row data using associative array syntax. ($row['id'])

User · Answer

sql    SELECT   FROM YOUR TABLE NAME    result   mysqli query  conn   sql      First parameter is just return of  mysqli connect    function echo   lt br gt    echo   lt table border  1  gt    while   row   mysqli fetch assoc  result        Important line         echo   lt tr gt        foreach   row as  field   gt   value       If you want you can right this line like this  foreach  row as  value            echo   lt td gt      value     lt  td gt               echo   lt  tr gt      echo   lt  table gt      In PHP 7 x You should use mysqli functions and most important one in while loop condition use  mysqli fetch assoc    function not  mysqli fetch array    one  If you would use  mysqli fetch array     you will see your results are duplicated  Just try these two and see the difference

User · Answer

result  mysql query  SELECT   FROM MY TABLE     while  row   mysql fetch array  result          echo  row  whatEverColumnName

User · Answer

Expanding on the accepted answer   function mysql query or die  query         result   mysql query  query       if   result          return  result      else            err   mysql error            die   lt br gt   query  lt br gt       err      lt br gt                   query    SELECT   FROM my table    result   mysql query or die  query   echo   lt table gt      first row   true  while   row   mysql fetch assoc  result         if   first row             first row   false             Output header row from keys          echo   lt tr gt            foreach  row as  key   gt   field                echo   lt th gt     htmlspecialchars  key      lt  th gt                      echo   lt  tr gt              echo   lt tr gt        foreach  row as  key   gt   field            echo   lt td gt     htmlspecialchars  field      lt  td gt              echo   lt  tr gt      echo   lt  table gt       Benefits    Using mysql fetch assoc  instead of mysql fetch array with no 2nd parameter to specify type   we avoid getting each field twice  once for a numeric index  0  1  2       and a second time for the associative key  Shows field names as a header row of table  Shows how to get both column name   key  and value   field  for each field  as iterate over the fields of a row  Wrapped in  lt table gt  so displays properly   OPTIONAL  dies with display of query string and mysql error  if query fails    Example Output   Id      Name 777     Aardvark 50      Lion 9999    Zebra

User · Answer

Nested loop to display all rows  amp  columns of resulting table   rows   mysql num rows  result    cols   mysql num fields  result   for   i   0   i lt  rows   i          for   j   0   j lt  cols   j            echo mysql result  result   i   j   quot  lt br gt  quot           Can be made more complex with data decryption decoding  error checking  amp  html formatting before display  Tested in MS Edge  amp  G Chrome  PHP 5 6

User · Answer

sql    SELECT   FROM MY TABLE    result   mysqli query  conn   sql      First parameter is just return of  mysqli connect    function echo   lt br gt    echo   lt table border  1  gt    while   row   mysqli fetch assoc  result        Important line     Check summary get row on array        echo   lt tr gt        foreach   row as  field   gt   value       I you want you can right this line like this  foreach  row as  value            echo   lt td gt      value     lt  td gt       I just did not use  htmlspecialchars    function             echo   lt  tr gt      echo   lt  table gt

[php] How to echo out table rows from the db (php)

Examples related to php

Examples related to mysql