不显示表SQLite和php

Question

    $table = "<p><table width=\"770px\">
  <thead>
    <tr>
      <th><b>FECHA</b></th>
      <th><b>PRODUCTO</b></th>
      <th><b>CANTIDAD</b></th>
      <th><b>PRECIO</b></th>
    </tr>
    </thead>
  <tbody> " . while($res = $result->fetchArray(SQLITE3_ASSOC))
         { 
         echo
    "<tr>
      <td>" . $res['fecha'] . "</td>
      <td>" . $res['nombre'] . "</td>
      <td>" . $res['cantidad'] . "</td>
      <td>" . $res['precio_hospital'] . "<br></td>
    </tr>"; 
         }  . "
  </tbody>
</table>";

Hello friends, I have a php page that does not allow me to show the table correctly I do not know how to place the while, please can you help me.

works friend, but I want to save the result of this table in a php variable to print it in

$ pdf-> writeHTML ($table, true, false, true, false, '');

Answer 1

You can't use echo when you are already inside and echo. Try:

$output = '<p><table width="770px">
  <thead>
    <tr>
      <th><b>FECHA</b></th>
      <th><b>PRODUCTO</b></th>
      <th><b>CANTIDAD</b></th>
      <th><b>PRECIO</b></th>
    </tr>
    </thead>
  <tbody>';

while($res = $result->fetchArray(SQLITE3_ASSOC)) { 
    $output .= '<tr><td>' . $res['fecha']    . '</td>' .
                   '<td>' . $res['nombre']   . '</td>' .
                   '<td>' . $res['cantidad'] . '</td>' .
                   '<td>' . $res['precio_hospital']    . 
               '<br></td></tr>'; 
}
$output .= '</tbody></table>';