MySQL Database Table To HTML Table

Here the value of $table will be passed from another file and it will be a table name in a database. With that table name ($table) am trying to fetch its column names and all the v

Solution 1:

Yes only columns will be printing because you are printing $rs[0];?> where $rs holds object for mysql_query qq and it holds your column query only not

"select * from $table"

this.

Why dont you try displaying columns as a single row in html table and then try displaying data from other php set with seperate query structure . Hope this way it helps.

Solution 2:

I coudn't fix your code because it was getting ugly, so i remade it:

php:

function mysql_fetch_all($res) {
    $result = array();
    while ($row = mysql_fetch_row($res)) {
        $result[] = $row;
    }
    return $result;
}

function getColumnsAndData($table) {
    $table = mysql_real_escape_string($table);
    $q1 = mysql_query("show columns from $table");
    $q2 = mysql_query("select * from $table");
    return array(mysql_fetch_all($q1), mysql_fetch_all($q2));
}

list($columns, $data) = getColumnsAndData($table);
?>

html

<table cellpadding="0" cellspacing="0" border="0" width="100%" class="display" rel="datatable">
    <thead>
        <tr>
            <?php foreach ($columns as $column): ?>
                <td><?php echo $column[0] . ' ' . $column[1] ?></td>
            <?php endforeach; ?>
        <tr>
    </thead>
    <tbody>
        <?php if (count($data) > 0): ?>
            <?php foreach ($data as $row): ?>
                <tr>
                    <?php foreach ($row as $value): ?>
                        <td><?php echo $value ?></td>
                    <?php endforeach; ?>
                <tr>
                <?php endforeach; ?>
            <?php else: ?>
            <tr>
                <td>No data to display</td>
            </tr>
        <?php endif; ?>
    </tbody>
</table>