PHP connection to MySQL database
<? PHP
$ Mysql_server_name = " Localhost " ; // Database Server Name
$ Mysql_username = " Root " ; // Database connection username
$ Mysql_password = " Root " ; // Database connection password
$ Mysql_database = " Lxr " ; // Database Name
// Connect to the database
$ Conn = Mysql_connect ( $ Mysql_server_name , $ Mysql_username ,
$ Mysql_password );
// SQL statement used to extract information from a table
$ Strsql = " Select * From personal_info " ;
// Execute SQL query
$ Result = Mysql_db_query ( $ Mysql_database , $ Strsql , $ Conn );
// Obtain query results
$ Row = Mysql_fetch_row ( $ Result );
Echo ' <Font face = "verdana"> ' ;
Echo ' <Table border = "1" cellpadding = "1" cellspacing = "2"> ' ;
// Show field name
Echo " \ N <tr> \ n " ;
For ( $ I = 0 ; $ I < Mysql_num_fields ( $ Result ); $ I ++ )
{
Echo ' <TD bgcolor = "#000f00"> <B> ' .
Mysql_field_name ( $ Result , $ I );
Echo " </B> </TD> \ n " ;
}
Echo " </Tr> \ n " ;
// Locate the first record
Mysql_data_seek ( $ Result , 0 );
// Retrieve records cyclically
While ( $ Row = Mysql_fetch_row ( $ Result ))
{
Echo " <Tr> \ n " ;
For ( $ I = 0 ; $ I < Mysql_num_fields ( $ Result ); $ I ++ )
{
Echo ' <TD bgcolor = "#00ff00"> ' ;
Echo " $ Row [ $ I ] " ;
Echo ' </TD> ' ;
}
Echo " </Tr> \ n " ;
}
Echo " </Table> \ n " ;
Echo " </Font> " ;
// Release resources
Mysql_free_result ( $ Result );
// Close connection
Mysql_close ();
?>