DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets Manager

Snippets has posted 5883 posts at DZone. View Full User Profile

Yubnub "data" Command To Display MySQL Data

11.04.2005

| 3922 views |

<?php
// Yubnub.org command "data" access this show.php file on the server
      
//    $dbname = "";
//    $loginname = "";
//    $loginpass = "";
//    $dbhost = "";
    
    echo('<html><body bgcolor="#FFFFFF">');
    echo('<font face="arial" size="+4"><center>');
    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("<center><h2> $arr_tablenames[$i] </h2></center>");
        echo('<table align="center" border="1"><tr>');
        $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link);
        for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) {
            echo("<th>");
            echo $hash_field_names[$i][$ii];
            echo("</th>");
        }
        echo("</tr><tr>");
        $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("<td>");
                // echo $record[$ii];
                $mytext = nl2br($record[$ii]);
                echo $mytext;
                echo("</td>");
            }
        echo("</tr>");
        }
        echo("</table>");
    }
    


    echo('</body></html>');

?>

Tags: