PHP – Build a HTML Table From any Query

Posted on September 26, 2015 by

As far as I am putting some efforts towards PHP and understanding why it is so hated by programmers all around, I have decided that the results from the queries should be always easily displayed in an HTML table. A beautiful one, if possible 🙂

Until now, what I have used to do was to tell php how to build the table, explicitly mentioning every column name. Today I have researched a little and I found out that this is really not needed – the PHP provides two beautiful options towards fetch_fields and fetch_arrays to understand the name of the columns in the table and the number of columns. Thus, without specifying them, with a few loops we are able to build table like this:

Just from the query. 🙂 And yes “Beauty” in programming is a formidable notion. 🙂

Ok, how have I done it? Pretty much through the help of two embedded loops, and the aforementioned fetch_fields and fetch_arrays.

Check the code yourself:

<html>
<head>
<title>VitoshAcademy Table
</title>
<style>
    .nice_style{
        background-color:yellow;
        color:blue;
    }
    .nicer_style{
        background-color:silver;
        color:pink;
    }
    .header_style{
        color:red;
        font-family:courier;
        font-size:160%;
    }
</style>
</head>
</html>

<?php
    
    function build_beautiful_table($my_result){
        $counter = 0;
        $columns_number = $my_result->field_count;
        $titles = $my_result->fetch_fields();
        
        echo "<table border='50'>";
        echo "<tr class = header_style>";

        foreach($titles as $title_needed){
            echo "<th>" . htmlspecialchars($title_needed->orgname) . "</th>";
        }
        echo "</tr>";
        
        while($value = $my_result->fetch_array()){
            if ($counter % 2 == 1){
                $my_style = " class='nice_style' ";    
            }else{
                $my_style = " class='nicer_style' ";
            }
            $counter += 1;

            echo "<tr $my_style>";
            for ($x = 0; $x< $columns_number; $x++){
                echo "<td>" . htmlspecialchars($value[$x]) . "</td>";
            }
            echo "</tr>";
        }
        echo "</table>";
    }

    $mysqli = new mysqli("localhost","root","","todo");
    if($mysqli->connect_error){
        echo "VitoshAcademy Error" . mysqli_connect_error();
        exit();
    }
    
    $my_result = $mysqli -> query("SELECT * FROM todos;");
    build_beautiful_table($my_result);
    $my_result->close();
    $mysqli->close();
?>

<html>

<head>

<title>VitoshAcademy Table

</title>

<style>

.nice_style{

background-color:yellow;

color:blue;

}

.nicer_style{

background-color:silver;

color:pink;

}

.header_style{

color:red;

font-family:courier;

font-size:160%;

}

</style>

</head>

</html>

<?php

function build_beautiful_table($my_result){

$counter = 0;

$columns_number = $my_result->field_count;

$titles = $my_result->fetch_fields();

echo "<table border='50'>";

echo "<tr class = header_style>";

foreach($titles as $title_needed){

echo "<th>" . htmlspecialchars($title_needed->orgname) . "</th>";

}

echo "</tr>";

while($value = $my_result->fetch_array()){

if ($counter % 2 == 1){

$my_style = " class='nice_style' ";

}else{

$my_style = " class='nicer_style' ";

}

$counter += 1;

echo "<tr $my_style>";

for ($x = 0; $x< $columns_number; $x++){

echo "<td>" . htmlspecialchars($value[$x]) . "</td>";

}

echo "</tr>";

}

echo "</table>";

}

$mysqli = new mysqli("localhost","root","","todo");

if($mysqli->connect_error){

echo "VitoshAcademy Error" . mysqli_connect_error();

exit();

}

$my_result = $mysqli -> query("SELECT * FROM todos;");

build_beautiful_table($my_result);

$my_result->close();

$mysqli->close();

Also available in GitHub! 🙂

Enjoy your day and have fun 😀

Tagged with: build table in html, fetch_arrays, fetch_fields, php build standard html table

PHP – Build a HTML Table From any Query

Related posts: