Show values from a MySQL database table inside a HTML table on a webpage [duplicate]

by

Example taken from W3Schools: PHP Select Data from MySQL

<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM Persons");

echo "<table border="1">
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['FirstName'] . "</td>";
echo "<td>" . $row['LastName'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysqli_close($con);
?>

It’s a good place to learn from!

More Related Contents:

  1. Trying to Show 87 mysql rows in 3 html tables using PHP and mysql [closed]
  2. Laravel one to many relation with a one to one relation
  3. Gather column name of a table from database [closed]
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. How to convert the json image url string into Bitmap image to display images in android application
  6. save user images in MYSQL database by which method? [closed]
  7. How to use multiple databases in Laravel
  8. Many-to-many relationships examples
  9. PDO get the last ID inserted
  10. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  11. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  12. How to upload images into MySQL database using PHP code
  13. Importing CSV data using PHP/MySQL
  14. MySQL check if a table exists without throwing an exception
  15. Maximum execution time in phpMyadmin
  16. How to store file name in database, with other info while uploading image to server using PHP?
  17. How to sort rows of HTML table that are called from MySQL
  18. PDO::PARAM for type decimal?
  19. How to store an array into mysql?
  20. Selecting a float in MySQL
  21. Get all child, grandchild etc nodes under parent using php with mysql query results
  22. How to execute raw queries with Laravel 5.1?
  23. Saving images in database mysql
  24. MySQL skipping first row
  25. PHP – Secure member-only pages with a login system
  26. Fatal error: Call to undefined function mysqli_result()
  27. Create table with PHP and populate from MySQL
  28. mysql injection damages?
  29. How do I save PHP session data to a database instead of in the file system?
  30. Mysqli multiple row insert, simple multi insert query [duplicate]

Leave a Comment