<! Doctype HTML public "-// W3C // dtd xhtml 1.0 transitional // en" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
">
<HTML xmlns = "http://www.w3.org/1999/xhtml
">
<Head>
<Meta http-equiv = "Content-Type" content = "text/html; charset = UTF-8"/>
<Title> temp </title>
</Head>
<Body>
<? PHP
// Database connection Parameters
$ Host = "localhost ";
$ User = "root ";
$ Pass = "zq19890319 ";
$ Db = "Flower ";
// Create a MySQL connection
$ Connection = mysql_connect ($ host, $ user, $ pass) or die ("unable to connect ");
// Select a database
Mysql_select_db ($ dB) or die ("unable to select database! ");
// Start Query
$ Query = "select * from login ";
// Execute the SQL statement
$ Result = mysql_query ($ query) or die ("error in query: $ query.". mysql_error ());
// Display the number of returned Record Sets
If (mysql_num_rows ($ result)> 0 ){
Echo "<Table cellpadding = 10 border = 1> ";
While ($ ROW = mysql_fetch_row ($ result )){
Echo "<tr> ";
Echo "<TD>". $ row [0]. "</TD> ";
Echo "<TD>". $ row [1]. "</TD> ";
Echo "<TD>". $ row [2]. "</TD> ";
}
Echo "</table> ";
}
Else {
Echo "record not found! ";}
// Release the memory occupied by the record set
Mysql_free_result ($ result );
// Close the connection to the database
Mysql_close ($ connection );
?>
</Body>
</Html>