PHP / PDO echo data from database into a table

by

Ok so I have figured it out

<?php
$getUser = $db->prepare("SELECT * FROM users");
$getUser->execute();
$users = $getUsers->fetchAll();

<table>
    <tr>
      <th>Username</th>
      <th>Password</th>
    </tr>
<?php foreach ($users as $user) { ?>
<tr>
   <td><?php echo $users['username'] ?></td>
   <td><?php echo $users['password'] ?></td>
</tr>
<?php } ?>
</table>

It now echo’s every username and password inside the table. even if I add new ones in the database I just hit refresh and they are added.

Sorry for writing my question in a confusing way.

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PDO Fetch statement only retrieves first column
  3. Insert form in MySQL with PDO [duplicate]
  4. Undefined index $_POST
  5. PHP – Using PDO with IN clause array
  6. Getting raw SQL query string from PDO prepared statements
  7. How do I set ORDER BY params using prepared PDO statement?
  8. “Invalid parameter number: parameter was not defined” Inserting data
  9. Having issue with matching rows in the database using PDO
  10. PDO binding values for MySQL IN statement [duplicate]
  11. PDO mysql: How to know if insert was successful
  12. How can I properly use a PDO object for a parameterized SELECT query
  13. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  14. implement LIKE query in PDO
  15. PHP PDO prepared statement — MySQL LIKE query
  16. Fetching single row, single column with PDO
  17. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  18. PDO Connection Test
  19. How do I loop through a MySQL query via PDO in PHP?
  20. PDO error: SQLSTATE[HY000]: General error: 2031
  21. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. Use of PDO in classes [duplicate]
  24. How to handle PDO exceptions [duplicate]
  25. Check if row exists in the database before inserting
  26. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  27. PDO and MySQL Fulltext searches
  28. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  29. PHP: mysql v mysqli v pdo [closed]
  30. PDO and MySQL ‘between’

Leave a Comment