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