/PHP/How to display data from mysql database into html table using php

How to display data from mysql database into html table using php

<?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);
?>

Source: stackoverflow.com

Mysql data to html table

<?php
$host    = "localhost";
$user    = "username_here";
$pass    = "password_here";
$db_name = "database_name_here";

//create connection
$connection = mysqli_connect($host, $user, $pass, $db_name);

//test if connection failed
if(mysqli_connect_errno()){
    die("connection failed: "
        . mysqli_connect_error()
        . " (" . mysqli_connect_errno()
        . ")");
}

//get results from database
$result = mysqli_query($connection,"SELECT * FROM products");
$all_property = array();  //declare an array for saving property

//showing property
echo '<table class="data-table">
        <tr class="data-heading">';  //initialize table tag
while ($property = mysqli_fetch_field($result)) {
    echo '<td>' . $property->name . '</td>';  //get field name for header
    array_push($all_property, $property->name);  //save those to array
}
echo '</tr>'; //end tr tag

//showing all data
while ($row = mysqli_fetch_array($result)) {
    echo "<tr>";
    foreach ($all_property as $item) {
        echo '<td>' . $row[$item] . '</td>'; //get items using property value
    }
    echo '</tr>';
}
echo "</table>";
?>

Source: stackoverflow.com

Similar codes

3 votes257 views2 answers
Undefined method JeroenNoten\LaravelAdminLte\Helpers\MenuItemHelper::isSearchBar()
PHP Laravel
1 vote231 views1 answer
Remove all attributes from HTML tags in PHP
PHP
1 vote278 views1 answer
[InvalidArgumentException] Could not find package laravel/laravel with version 7.0 in a version installable using your PHP version, PHP extensions and Composer version.
PHP Laravel
0 vote238 views1 answer
Laravel follow and unfollow relationship
PHP Laravel
3 votes273 views3 answers
Loop index foreach laravel
PHP
0 vote232 views1 answer
Php array differ
PHP
0 vote277 views3 answers
Get index number wordpress loop
PHP Wordpress
51 votes300 views6 answers
Laravel run all seeders
PHP Laravel
12 votes284 views4 answers
Laravel get second last record
PHP Laravel
20 votes229 views6 answers
Cmd run php file
PHP