Create a generic function to generate html tables from mySQL database with Php

Asked Aug 23 '22 at 12:18

Active Aug 23 '22 at 12:36

Viewed 19 times

As you can read in the title, I'm trying to create a generic function in order to generate a table from a mySQL database. I want to reuse it for every table I need to create in this project and for the next ones.

function table_generator($nameTable, $db) {

    $requete = $db->prepare("SELECT * FROM " . $nameTable);
    $requete->execute();
    $i = '0';

foreach($requete AS $data) {
        echo "<tr>";
        foreach($data as $vars){
            echo "<td>$vars</td>";
        }
        echo "</tr>";
    }
}

Edit: the echo write every field twice.

edited Aug 23 '22 at 12:36

asked Aug 23 '22 at 12:18

Wymee

Hint: You can `foreach` through `$data` as well – ADyson Aug 23 '22 at 12:19
P.S. Unless you whitelist the table names this is going to be vulnerable to SQL injection. – ADyson Aug 23 '22 at 12:19
I did this, but it write every field twice... Thank you for your advice about SQL injection, I'll take a look later on it. – Wymee Aug 23 '22 at 12:33
Are you using mysqli or PDO here? – ADyson Aug 23 '22 at 12:51
I'm using pdo, unfortunately I didn't find the issue. So I changed my script to this one : https://stackoverflow.com/questions/64293916/dynamic-table-in-html-using-mysql-and-php – Wymee Aug 25 '22 at 08:16
Good idea...no point in re-inventing the wheel! – ADyson Aug 25 '22 at 08:18

Create a generic function to generate html tables from mySQL database with Php

0 Answers0