<? Phpheader ("Content-Type: text/html; charset = UTF-8"); echo '<a href = "#"> refresh </a> <br/> '; // echo "<br/> MySQL. connect_timeout = ". get_cmd_var ('mysql. connect_timeout '); // database connection-query-retrieve result-close // connection, return connection resource $ mysql = mysql_connect ('localhost: 100', 'fuxingdaima ', 'phf936300') or die ('could not Connect '. mysql_error); // echo "mysql_get_client_info () = ". mysql_get_client_info (). "<br/>"; // echo "mysql_get_host_info () = ". mysql_get_host_info ($ mysql ). "<br/>"; // echo "mysql_get_server_info () = ". mysql_get_server_info ($ mysql ). "<br/>";/* $ state = mysql_stat ($ mysql); echo "mysql_stat () ="; var_dump ($ State); echo "<br/> "; * /// select the database mysql_select_db ("test") or die ("cocould not select database test"); // query $ query = "select * from SC "; $ result = mysql_query ($ query) or die ("invalid query ". mysql_error (); // var_dump ($ result); // echo "mysql_info () = ". mysql_info ($ mysql ). "<br/>"; // obtain the result/* // Number of result columns $ rownum = mysql_num_rows ($ result); echo "num rows = ". $ rownum. "<br/>"; $ fieldnum = mysql_num_fields ($ result); echo "Num field = ". $ fieldnum. "<br/>"; * // fetch row data $ resarray = mysql_fetch_array ($ result, mysql_assoc); echo "mysql_fetch_array (, mysql_assoc) = "; var_dump ($ resarray); echo "<br/>"; $ resarray = mysql_fetch_array ($ result, mysql_num); echo "mysql_fetch_array (, mysql_num) = "; var_dump ($ resarray); echo "<br/>"; $ resarray = mysql_fetch_array ($ result, mysql_both); echo "mysql_fetch_array (, mysql_both) = "; var_dump ($ resarray); echo "<br/>"; $ lenarray = mysql_fetch_lengths ($ result); echo "mysql_fetch_lengths ="; var_dump ($ array len ); echo "<br/>"; $ resarray = mysql_fetch_object ($ result); echo "mysql_fetch_object ="; var_dump ($ resarray); echo "<br/> "; echo '$ resarray-> SID = '. $ resarray-> Sid. "<br/>";/** // * // retrieve the column Field Information $ field = mysql_fetch_field ($ result); echo "mysql_fetch_field () = "; var_dump ($ field); echo "<br/>"; $ field_flags = mysql_field_flags ($ result, 0); echo "mysql_field_flags () ="; var_dump ($ field_flags ); echo "<br/>"; * // release the memory associated with the result identifier $ result (optional) mysql_free_result ($ result); // close the connection Resource (optional) mysql_close ($ mysql );