[Resolved] How to print whole database table?

monkeyface

I searched here and on the Google, but couldn't find a script that is capable to print every (well, every simple) MySQL table to HTML.

One script that I found isn't working correctly. Here it is:

<?php require('php/db_connect.php'); // connect to database 
$query2 = mysql_query("SELECT * FROM stats");
$total_rows = mysql_num_rows($query2);
$rows = mysql_fetch_row($query2); 
$total_cols = count($rows);

?>
<html>
<head>
<title></title>
</head>

<body>

<p>
<table>
<?php
echo "<tr>"; 
$i=0; 
while($i < $total_cols){ 
  echo "<td>"; 
  echo $rows[$i]; 
  echo "</td>"; 
  $i++; 
} 
echo "</tr>";
while($row = mysql_fetch_row ($query2)) { 
  $i = 0; 
  echo "<tr>"; 
  while($i < $total_cols){ 
    echo "<td>"; 
    echo $rows[$i]; 
    echo "</td>"; 
    $i++; 
  } 
  echo "</tr>"; 
} 

?>
</table>
</body>
</html>

thanks in advance

maybl8r03

Here is a little function I wrote to make it easier to dump an array out to html (including collapsing etc). It's actually embedded in a class - and I haven't tested it outside of the class so I hope the recursive function work. The recursive funtion will help you display multi-dimension arrays. You will need to load your database into a multi-dimension array to see the best effect of this.

		function arrayout($arrvalue, $idtohide=NULL) {
			$vresult = "";
			if (is_array($arrvalue)) {
				@reset($arrvalue);
				if (empty($idtohide)) {
					$vresult .= "<table width=\"100%\" border=\"1\" cellpadding=\"0\" ".
								"cellspacing=\"0\" style=\"border-color:blue; font-family:verdana; font-size:10pt;\">";
					$vresult .= "<tr><td ".
								"style=\"color:white; font-weight:bold; background:blue;\" ".
								"><span id=\"arrayoutheader\" ".
								"onclick=\"if(document.all.item('arrayoutbodyx')) {document.all.item('arrayoutbodyx').style.display='';}\" ".
								"ondblclick=\"if(document.all.item('arrayoutbodyx')) {document.all.item('arrayoutbodyx').style.display='none';}\" ".
								"><center>Click here to show messages / Double Click to hide</center></span></td></tr>";
					$vresult .= "<tr><td><span id=\"arrayoutbodyx\" style=\"display:;\">";
				}
				$vresult .= "<table width=\"100%\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-color:black; font-family:verdana; font-size:8pt;\">";
				while (list($id,$value) = @each($arrvalue)) {
					$nextbodyid = uniqid("xxx",TRUE);
					$vresult .= "<tr><td valign=\"top\" onmouseover=\"this.style.background='#CCCCFF';\" ".
								"onmouseout=\"this.style.background='white';\" ".
								"onclick=\"if(document.all.item('{$nextbodyid}')) {".
								"document.all.item('{$nextbodyid}').style.display=''; ".
								"};\" ".
								"ondblclick=\"if(document.all.item('{$nextbodyid}')) {".
								"document.all.item('{$nextbodyid}').style.display='none'; ".
								"};\" ".
								"style=\"background:white;\">";
					$vresult .= "<span style=\"color:blue;\">$id</a></td><td>";
					$vresult .= arrayout($value, $nextbodyid); // recurse
					$vresult .= "</td></tr>\n";
				}
				$vresult .= "</table>\n";
				if (empty($idtohide)) {
					$vresult .= "</span></td></tr></table>\n";
				} else {
					$vresult = "<span id=\"{$idtohide}\" style=\"display:none;\">".$vresult."</span>\n";
				}
			} else {
				$vresult = "<span id=\"{$idtohide}\"><font style=\"color:red;\"><b><i>".$arrvalue . "</i></b></font></span>";
			}
			return ($vresult);
		}

$arTable = array();
$table = mysql_query("SELECT * FROM tablename");
while ($row = mysql_fetch_array($table, MYSQL_ASSOC))
{
    $arTable[] = $row;
}
echo arrayout($arTable);

monkeyface

sorry, but this is too difficult and to big.

is there really no simpeler way to print a simple table to the html?

stolzyboy

you can do it this way, kinda lame though, but don't really understand why the other posters is easy, it's pretty much cut and paste, all i had to do was add the connection info, which he likely had somewhere else

<?
$conn = mysql_connect('localhost', "username", "password") or die("Could not connect to mysql");
$db = mysql_select_db("intranet") or die("Could not connect to database");

$query = "select * from tablename";
$result = mysql_query($query) or die(mysql_error());
?>
<table border="1" width="800">
<tr>
<td nowrap>
<b>Field Names:</b>
</td>
<?
while ($row = mysql_fetch_field($result))
{
?>
<td>
<? echo $row->name; ?>
</td>
<?
}
?>
</tr>
<?
while ($row = mysql_fetch_array($result))
{
?>
<tr>
<td nowrap>
&nbsp;
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
<td>
<? echo $row['fieldname']; ?>
</td>
</tr>
<?
}
?>

monkeyface

thanks stolzyboy, thats what i looked for! extremely simple as hell, just like me!

thanks