MySQL Table display

Read from database=".$db.", table=".$table.", user=".$un. ".

"; }else{ echo "

Read list of tables from database=".$db.", with user=".$un. ".

"; } if($host ==""){ $db_host = "localhost"; }else{ $db_host = $host; } $db_user = $un; $db_pwd = $pass; $db_name = $db; mysql_connect($db_host, $db_user, $db_pwd); mysql_select_db($db_name); ?> "; $field = Array(); $type = Array(); $null = Array(); $keys = Array(); $default = Array(); $extra = Array(); while($row = mysql_fetch_array($query,MYSQL_ASSOC)) { foreach($row as $key =>$value){ if($key == "Field"){ $field[] = $value; }elseif($key == "Type"){ $type[] = $value; }elseif($key == "Null"){ $null[] = $value; }elseif($key == "Key"){ $keys[] = $value; }elseif($key == "Default"){ $default[] = $value; }else{ $extra[] = $value; } } } // display data for($i = 0;$i< count($field);$i++){ echo ""; } }else{ //we want the data $sql = "SELECT * FROM ".$table; $query = mysql_query($sql); $rows = mysql_num_rows($query); while($row = mysql_fetch_array($query,MYSQL_ASSOC)) { echo ""; $count = 0; $bold = 0; // bold toggle foreach($row as $key =>$value){ if($count++ == 3){ // 3 columns echo "\n"; // new row $count = 1; } $nt = $value; if(strlen($value) >= 30){ $nt = wordwrap($value, 30, "
\n",true); } if($bold == 0){ echo ""; $bold =1; }else{ echo ""; } } // pad table $count = 3 -$count; for($i=0; $i < $count;$i++){ echo ""; } echo "\n"; } // end while } }else{ // list all tables in database $sql = "SHOW TABLES FROM ".$db_name; $query = mysql_query($sql); $rows = mysql_num_rows($query); while($row = mysql_fetch_array($query,MYSQL_ASSOC)) { echo "\n"; } } ?>
Field:Type:Null:Key:Default:Extra:
".$field[$i]."".$type[$i]."".$null[$i]."".$keys[$i]."".$default[$i]."".$extra[$i]."
".$key.":".$nt."".$key.":".$nt." 
"; foreach($row as $key =>$value){ echo $value; } echo "
Displayed ".$rows." records

\n"; ?>