dbm2.php

<html><head><title>MySQL Table Viewer</title></head><body>
<?php
$db_host = 'localhost';
$db_user = '******';
$db_pwd = '******';

$database = 'smislich';
$table = 'Superhero';

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$table}");
if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

echo "<h1>Table: {$table}</h1>";
echo "<table border='1'><tr>";
// printing table headers
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    echo "<td>{$field->name}</td>";
}
$num_rows = mysql_num_rows($result);
for($row_num=1; $row_num<=$num_rows; $row_num++) {
    $row=mysql_fetch_array($result);
        print '<tr><td>';
        print $row['FirstName'];
        print '</td><td>';
        print $row['LastName'];
        print '</td><td>';
        print $row['HeroName'];
        print '</td><td>';
        print $row['Publisher'];
        print '</td><td><img src="';
        print $row['PictureLink'];
        print '" /></td><td>';
        print $row['Power'];
        print '</td></tr>';
        }
print '</table>';
mysql_free_result($result);
?>
<form method="link" action="dbm1.php"><input type="submit" value="Add new Superhero"></form>
</body></html>