#native_company# #native_desc#

Display any table in PHP

By Sergey Skudaev
on January 11, 2006

Display Any Table (PHP script)

$hostname = "localhost";
$dbuser = "myuser";
$dbpassword = "mypasswprd";
$dbname = "mydbname";

     $db_link=mysql_connect($hostname, $dbuser, $dbpassword) 
     or die("Unable to connect to the server!");

     or die("Unable to connect to the database");


        $sql="select product, price from products where catid=1 order by product ";

// find position of "FROM" in query
        $fpos=strpos($sql, 'from');

        // get string starting from the first word after "FROM"
        $strfrom=substr($sql, $fpos+5, 50);

        // Find position of the first space after the first word in the string
        $Opos=strpos($strfrom,' ');

        //Get table name. If query pull data from more then one table only first table name will be read.
        $table=substr($strfrom, 0,$Opos);

// Get result from query

        print('<link rel="stylesheet" href="style.css">');

'); if($num_row >0) { //Get number of fields in query $num_fields=mysql_num_fields($result); # get column metadata $i = 0; //Set table width 15% for each column $width=15 * $num_fields; print('
<table width='.$width.'% align=center><tr>'); print('<tr><th colspan='.$num_fields.'>View&nbsp'.$table.'</th></tr>'); while ($i < $num_fields) { //Get fields (columns) names $meta = mysql_fetch_field($result); $fields_array[]=$meta->name; //Display column headers in upper case print('<th>'.strtoupper($fields_array[$i]).'</th>'); $i=$i+1; } print('</tr>'); //Get values for each row and column while($row=mysql_fetch_row($result)) { print('<tr>'); for($i=0; $i<$num_fields; $i++) { //Display values for each row and column print('<td>'.$row[$i].'</td>'); } print('</tr>'); } } ?>

see also www.configure-all.com