| Dumping mySQL Tables to HTML |
pages (2): [1] 2 |
|
|
In this tutorial we are going to expose basic mySQL queries, and how they can be
used to print all data from a mySQL table into an HTML table.
This might be useful if you want to display all the data for review reasons.
A couple of things to take into consideration however when following this
tutorial; For one thing, this tutorial will assume that the mySQL table we will
print does not contain a lot of records. Obviously, if the table contains
thousands of records, the script will take a long time to process and the
rendered HTML page itself will be enormous. You should only use this tutorial to
get a basic understanding of how to print the data, and they modify the code to
suit your needs.
Secondly, the code shown does not require you to know the mySQL table field
names. It is dynamic, meaning it only requires a mySQL table and then the code
does everything else automatically. This makes the code more portable. Finally, you should have a common knowledge of working with PHP and mySQL in
order to stay up to speed when reading this tutorial.
So, let's get started! We will first display the
entire code, then break it down and explain each section, and how it works...
The Code
<?php
// Open Connection To mySQL.
// Replace 'username' and 'password' with appropiate login values for
// your server.
$mysqlLink = mysql_connect( 'localhost' , 'username' , 'password' );
// Select mySQL Database.
// Replace 'database' with appropriate database for your server.
mysql_select_db( 'database' , $mysqlLink );
// Select mySQL Table.
// Replace '$table' with appropriate table for your server.
$table = 'table';
/**
* Print Table.
*
* Print Table consists of selecting the mySQL table, determine
* if there is data in it, selecting
* that data, then actually formatting it in an HTML table.
*
* If there is no data, then appropriate messages are displayed.
*/
// Check If Query Was A Success.
if( $result = mysql_query('SELECT * FROM ' . $table ) )
{
// Start Table.
echo '<table border="1">';
// Get Number Of Fields In Table.
$fieldCount = mysql_num_fields( $result );
// Start First Row.
echo "<tr>";
// Loop Through Each Field And Display It In Row.
for( $i = 0; $i < $fieldCount; $i++ ) {
echo '<td><strong>' . mysql_field_name( $result, $i ) . '</strong></td>';
}
// Close First Row.
echo "</tr>";
// Check If There Is Data In Table.
if( mysql_num_rows( $result ) )
{
// Loop Through Each Row And Display It.
while( $row = mysql_fetch_row( $result ) )
{
// Start Row.
echo '<tr>';
// Loop Through Each Field For Current Row.
for( $i = 0; $i < $fieldCount; $i++ ) {
echo '<td>' . $row[$i] . '</td>';
}
// Close Row.
echo '</tr>';
}
}
// No Data In Table.
else {
echo '<tr><td colspan="' . $fieldCount . '">No rows selected...</td></tr>';
}
// Close Table.
echo '</table>';
}
// Invalid Query Or Un-Success.
else {
echo 'Query Error: ' . mysql_error( );
}
// Close mySQL Connection.
mysql_close( $mysqlLink );
?>
|
That was a lot of code! Its simple but rather long.
So, let's break
down the code into smaller parts and explain what each section does:
- Tutorial written by Limitless
|
|
 |
|
|
 [WIP] Hairdresser Site Design
Author: YinToniq
Posted: Jul 03rd, 5:58am
Activity: 1 replies, 26 views
| | Simple Flash Help Needed (AS2)
Author: stiney51
Posted: Jul 02nd, 2:40pm
Activity: 9 replies, 53 views
| | Transformers
Author: Jacorre
Posted: Jun 29th, 6:33pm
Activity: 2 replies, 72 views
| |  Quick question about Jasc PaintShop Pro 9.
Author: Rydium-41
Posted: Jun 28th, 8:21pm
Activity: 2 replies, 71 views
| | I bought film today!!
Author: NikonErik
Posted: Jun 27th, 12:04am
Activity: 2 replies, 73 views
| | New Battle
Author: MoodsR4Cattle
Posted: Jun 26th, 6:28pm
Activity: 2 replies, 80 views
| | Image Loading
Author: funkyfela
Posted: Jun 22nd, 9:00pm
Activity: 1 replies, 81 views
| | Headshot Critique Please
Author: NikonErik
Posted: Jun 19th, 11:32pm
Activity: 6 replies, 151 views
| |  imagecopy() and imagecopyresized() problem
Author: thatpyrokid
Posted: Jun 18th, 3:05pm
Activity: 1 replies, 146 views
| | Problem With Regitration Code...?
Author: RXS
Posted: Jun 17th, 3:18am
Activity: 2 replies, 146 views
| | Topaz Labs do it again!
Author: Tamlin
Posted: Jun 17th, 12:08am
Activity: 5 replies, 226 views
| | [Photoshop] Anime Coloring Tutorial
Author: Wavechan
Posted: Jun 16th, 3:47pm
Activity: 2 replies, 288 views
| |
|
 |
 |
 |
|
|
|
| --- Site Resources --- |
| Total Tutorials: | 212 |
| Total Downloads: | 415 |
| Linkbase Links: | |
|
|
|
|
|
|
