Analyze two methods of connecting PHP to MYSQL_PHP tutorial

Mysql can be connected to the web through PHP in two ways, one through php's Mysql related functions, and the other through php's ODBC related functions.

The relevant functions are as follows:

　MYSQL function

　mysql_affected_rows: Get the number of columns affected by the last MySQL operation.

　mysql_close: Close the MySQL server connection.

mysql_connect: Open the MySQL server connection.

　mysql_create_db: Create a new MySQL database.

　mysql_data_seek: Move the internal return indicator.

　mysql_db_query: Send query string (query) to the MySQL database.

　mysql_drop_db: Remove the database.

mysql_errno: Return error message code.

mysql_error: Return error message.

　mysql_fetch_array: Return array data.

mysql_fetch_field: Get field information.

Mysql_fetch_lengths: Returns the maximum length of each column of data in a single column.

　mysql_fetch_object: Return object data.

mysql_fetch_row: Returns each column of a single column.

　mysql_field_name: Returns the name of the specified field.

　mysql_field_seek: Set the indicator to a field of the returned value.

　mysql_field_table: Get the name of the data table (table) of the current field.

　mysql_field_type: Get the type of the current field.

mysql_field_flags: Get the flags of the current field.

　mysql_field_len: Get the length of the current field.

　mysql_free_result: Release the occupied memory passed back.

　mysql_insert_id: Returns the ID of the last INSERT instruction used.

　mysql_list_fields: List the fields of the specified data table.

Mysql_list_dbs: Lists the databases available on the MySQL server.

　mysql_list_tables: List the tables (tables) of the specified database.

　mysql_num_fields: Get the number of fields returned.

Mysql_num_rows: Get the number of columns returned.

Mysql_pconnect: Enable long-term connection to the MySQL server.

　mysql_query: Send a query string.

　mysql_result: Get the result of the query.

　mysql_select_db: Select a database.

　mysql_tablename: Get the name of the data table.

ODBC function

To use ODBC functions, you need to install MYSQL ODBC

　odbc_autocommit: Switch the automatic change function.

　odbc_binmode: Set the binary data processing method.

　odbc_close: Close the ODBC connection.

　odbc_close_all: Close all ODBC connections.

　odbc_commit: Modify the ODBC database.

　odbc_connect: Connect to the ODBC database.

　odbc_cursor: Get the cursor name.

　odbc_do: Execute SQL instructions.

　odbc_exec: Execute SQL instructions.

　odbc_execute: Execute preset SQL instructions.

　odbc_fetch_into: Get the specified column returned.

　odbc_fetch_row: Get and return a column.

　odbc_field_name: Get the field name.

　odbc_field_type: Get the field data form.

　odbc_field_len: Get the field data length.

odbc_free_result: Release the memory of the returned data.

　odbc_longreadlen: Set the maximum value of the returned column.

　odbc_num_fields: Get the number of fields.

　odbc_pconnect: Long-term connection to the ODBC database.

　odbc_prepare: Prepare SQL instructions.

　odbc_num_rows: Get the number of returned columns.

　odbc_result: Get the returned data.

　odbc_result_all: Return HTML table data.

　odbc_rollback: Undo the current transaction.

　odbc_setoption: Adjust ODBC settings.

Example: Frontend HTML
< form enctype="multipart/form-data" action="hb_ggzd.php" method="post" >
< tr >
< td width="251" >< small >You can take some time to fill in the form below, or you can use electricity
Contact via email, < a href="mailto:likai333@21cn.com" >likai333@21cn.com< /a >. < /small >< /td >
< /tr >
< tr >
< td vAlign="top" width="251" height="31" >< small >Your name: < /small >< /td >
< td width="462" height="31" >< small >< input name="name" size="20" > < /small >< /td >
< /tr >
< tr >
< td vAlign="top" width="251" height="30" >< small >Your email: < /small >< /td >
< td width="462" height="30" >< small >< input name="usermail" size="37" >< /small >< /td >
< /tr >
< tr >
< td vAlign="top" width="251" height="25" >< small >The website address you want to advertise: < /small >< /td >
< td width="462" height="25" >< small >< small >< input name="userurl" size="37" value="http://" >< /small >< /small >< /td >
< /tr >
< tr >
< td vAlign="top" width="251" height="25" >< small >The name of the website you want to advertise: < /small >< /td >
< td width="462" height="25" >< small >< input name="sitename" size="20" >< /small >< /td >
< /tr >
< tr >
< td vAlign="top" width="251" height="30" >< small >Your company name: < /small >< /td >
< td width="462" height="30" >< small >< input name="company" size="37" >< /small >< /td >
< /tr >
< tr >
< td vAlign="top" width="251" height="25" >< small >Your contact number: < /small >< /td >
< td width="462" height="25" >< small >< input name="phone" size="20" >< /small >< /td >
< /tr >
< tr >

Backend PHP:
< ?php
= mysql_connect(localhost:3306,root,);
mysql_select_db(HBWEB);
="insert into usemsg (name,usermail,userurl,sitename, company,phone) values ​​(,,, , ,,,,,,)";
= mysql_query(, );
= mysql_error();
if(){
echo "An error occurred, please notify< a href=mailto:likai333@21cn.com >me< /a >";
echo "";
}
else
{ echo "Successfully entered into the database"; }
?>

Table structure:
CREATE TABLE usemsg (
name varchar(255) not null default "notname",
usermail varchar(255) not null default "notusermail",
userurl varchar(255) not null default "notuserurl",
sitename varchar(255) not null default "notsitename",
company varchar(255) not null default "notcompany",
phone varchar(255) not null default "notphone",
);

http://www.bkjia.com/PHPjc/486441.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/486441.htmlTechArticleMysql can be connected to the web through PHP in two ways, one through the Mysql related functions of php, and the other Through php's ODBC related functions. The related functions are as follows: MYSQL function mysql_affected_ro...