Write procedures to remember sloppy, not fine, really write program of taboo in the big taboo. So later write code must: careful careful not arrogant not dry, can write good code to avoid confusion.
<?php
echo "This is a test</br>";
echo "ASDFASDFADSF";
$mysql _server_name= "localhost"; Database server name
$mysql _username= "root"; Connect to database user name
$mysql _password= "??????"; Connect Database Password
$mysql _database= "??????"; The name of the database
Connecting to a database
$conn =mysql_connect ($mysql _server_name, $mysql _username,
$mysql _password);
SQL statement that extracts information from a table
$strsql = "SELECT * from ' Gbook '";
Execute SQL query
$result =mysql_db_query ($mysql _database, $strsql, $conn);
Get query Results
$row =mysql_fetch_row ($result);
Echo ' <font face= ' Verdana > ';
Echo ' <table border= ' 1 "cellpadding=" 1 "cellspacing=" 2 ">";
Show Field names
echo "</b><tr></b>";
for ($i =0; $i <mysql_num_fields ($result); $i + +)
{
Echo ' <td bgcolor= ' #000F00 ><b> '.
Mysql_field_name ($result, $i);
echo "</b></td></b>";
}
echo "</tr></b>";
Navigate to the first record
Mysql_data_seek ($result, 0);
Loop out Records
while ($row =mysql_fetch_row ($result))
{
echo "<tr></b>";
for ($i =0; $i <mysql_num_fields ($result); $i + +)
{
Echo ' <td bgcolor= ' #00FF00 > ';
echo $row [$i];
Echo ' </td> ';
}
echo "</tr></b>";
}
echo "</table></b>";
echo "</font>";
Freeing resources
Mysql_free_result ($result);
Close connection
Mysql_close ($conn);
?>
Shorthand:
<?php
$conn =mysql_connect ("localhost", "root", "password");
$result =mysql_db_query ("Database", "SELECT * from ' info '", $conn);
Get query Results
$row =mysql_fetch_row ($result);
Echo ' <font face= ' Verdana > ';
Echo ' <table border= ' 1 "cellpadding=" 1 "cellspacing=" 2 ">";
Show Field names
echo "</b><tr></b>";
for ($i =0; $i <mysql_num_fields ($result); $i + +)
{
Echo ' <td bgcolor= ' #000F00 ><b> '.
Mysql_field_name ($result, $i);
echo "</b></td></b>";
}
echo "</tr></b>";
Navigate to the first record
Mysql_data_seek ($result, 0);
Loop out Records
while ($row =mysql_fetch_row ($result))
{
echo "<tr></b>";
for ($i =0; $i <mysql_num_fields ($result); $i + +)
{
Echo ' <td bgcolor= ' #00FF00 > ';
echo $row [$i];
Echo ' </td> ';
}
echo "</tr></b>";
}
echo "</table></b>";
echo "</font>";
Freeing resources
Mysql_free_result ($result);
Close connection
Mysql_close ($conn);
?>
PHP connection to MySQL