Welcome to HBH! If you had an account on hellboundhacker.org you will need to reset your password using the Lost Password system before you will be able to login.

Quick and Dirty MySQL DB Preview - PHP Code Bank

Quick and Dirty MySQL DB Preview

This is a quick and dirty script I cooked up for previewing a site's MySQL database in the event that I do not have CPanel or command-line access (but FTP access is available).

<?php
// Specify DB connect include / code here
include 'connect.php';
// End DB connect code

// Specify initial HTML and HEAD include / code here

// Get all the table names
if ($result1 = mysql_query("SHOW TABLES")) { while ($row1 = mysql_fetch_array($result1)) {
echo '<table>';

// Get the table fields for each table and make the HTML table headings
if ($result2 = mysql_query("DESCRIBE ".$row1[0])) { while ($row2 = mysql_fetch_array($result2)) { echo '<th>'.$row2[0].'</th>'; } }

// Get the each table's contents
if ($result3 = mysql_query("SELECT * FROM ".$row1[0]." LIMIT 10")) { while ($row3 = mysql_fetch_array($result3)) {
echo '<tr>';
$count = count($row3);

for ($x = 0; $x < $count; $x++) { echo '<td>'.$row3[$x].'</td>'; }

echo '</tr>';
} } echo '</table>'; } }
?>

ghost