PHP code to display on your page any table from MySQL db

By Sergey Skudaev

+++++

By Sergey Skudaev

Here you will find PHP code example that pulls data from MySQL database and displays it on the form. If you are developing a PHP application you have to display records from different tables and each time you have to write HTML code for table with different column numbers and names. This PHP code example is universal for any query.

As a result you can use the same php template that reads meta data: counts fields, reads field names and creates a suitable HTML table. Pulls fields values and display data inside the table. You can create any table in MySQL database, write any SQL query and copy it in place of my query in my code example.

<?php

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

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

     mysql_select_db(&dbname)
     or die("Unable to connect to the database");

        $fields_array=array();
        $num_fields=0;
        $num_row=0;
       

        $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
        $result=mysql_query($sql);
        $num_row=mysql_numrows($result);

        print('<html>');
        print('<head><title>');
        print('View&nbsp'.$table.'</title>');
        print('<link rel="stylesheet" href="style.css">');

        print("</head>");
        print('<body><br>');

        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('<br><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><b>'.strtoupper($fields_array[$i]).'</b></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>');
            }

}

?>

Did you find information useful?
Send to your friend a link to this page

Please rate the tutorial

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10

My eBooks on Amazon.com

Learn C++ Programming By Examples

Learn SQL Programming By Examples

Learn PHP Programming by Examples

Visual Basic Programming By Examples

How to Build Your Own Web Site from Scratch

New-trip.com website source code

Comments
 
Register to add comments ( 1000 char ) for display_any_table.php.