Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Yubnub "data" Command To Display MySQL Data

DZone's Guide to

Yubnub "data" Command To Display MySQL Data

·
Free Resource


  ');
    echo('
  
'); echo(" $dbname"); $id_link = @mysql_connect($dbhost, $login, $password); $tables = mysql_list_tables($dbname, $id_link); $num_tables = mysql_num_rows($tables); // store table names in an array $arr_tablenames[] = ''; // store number of fields per table(index 0,1,2..) in an array $arr_num_fields[] = ''; for ($i=0; $i < $num_tables; $i++) { $arr_tablenames[$i] = mysql_tablename($tables, $i); $arr_num_fields[$i] = mysql_num_fields(mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link)); } // store field names in a multidimensional array: // [i] == table number, [ii] == field number for that table for ($i=0; $i < $num_tables; $i++) { for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link); $hash_field_names[$i][$ii] = mysql_field_name($result, $ii); } } for ($i=0; $i < $num_tables; $i++) { echo("

$arr_tablenames[$i]

"); echo(' '); $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link); for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { echo(" "); } echo(" "); $number_of_rows = @mysql_num_rows($result); for ($iii = 0; $iii < $number_of_rows; $iii++) { $record = @mysql_fetch_row($result); for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { echo(" "); } echo(" "); } echo("
"); echo $hash_field_names[$i][$ii]; echo("
"); // echo $record[$ii]; $mytext = nl2br($record[$ii]); echo $mytext; echo("
"); } echo(''); ?>
Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}