Skip to main content

Posts

Showing posts from August, 2007

[Template] PHP显示MySQL数据

只需要修改数据库的信息。 <html> <head> <title>View Database</title> <body> <?php //connect database $db_host = 'localhost' ; $db_user = 'username' ; $db_pwd = 'password' ; $database = 'database' ; $table = 'table' ; if ( ! mysql_connect ( $db_host , $db_user , $db_pwd ) ) die ( "Can't connect to database" ) ; if ( ! mysql_select_db ( $database ) ) die ( "Can't select database" ) ; // sending query $result = mysql_query ( "SELECT * FROM {$table}" ) ; if ( ! $result ) { die ( "Query to show fields from table failed" ) ; } $fields_num = mysql_num_fields ( $result ) ; echo "<h1>Table: {$table}</h1>" ; echo "<table border='1'><tr>" ; // printing table headers for ( $i = 0 ; $i < $fields_num ; $i ++ ) { $field = mysql_fetch_field ( $result ) ; echo "<td>{$fiel