Two ways to connect MySQL with PHP

MySQL can be connected to the Web through PHP in two ways, a MySQL-related function via PHP, and another ODBC-related function via PHP

The related functions are as follows:

MySQL function

Mysql_affected_rows: Gets the number of columns affected by the MySQL last 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 internal return indicator.
Mysql_db_query: Send query string to MySQL database.
mysql_drop_db: Remove the repository.
Mysql_errno: Returns the error message code.
Mysql_error: Send back the error message.
Mysql_fetch_array: Returns the array data.
Mysql_fetch_field: Get field information.
Mysql_fetch_lengths: Returns the maximum length of column data.
Mysql_fetch_object: Returns the object data.
Mysql_fetch_row: Returns a single column of fields.
Mysql_field_name: Returns the name of the specified field.
Mysql_field_seek: Sets the indicator to a field that returns a value.
Mysql_field_table: Gets the table name for the current field.
Mysql_field_type: Gets the current field type.
Mysql_field_flags: Get the flag for the current field.
Mysql_field_len: Gets the current field length.
Mysql_free_result: Release back to occupy memory.
MYSQL_INSERT_ID: Returns the ID for the last time the insert instruction was used.
Mysql_list_fields: Lists the fields (field) for the specified table.
Mysql_list_dbs: Lists the database (database) available for the MySQL server.
Mysql_list_tables: Lists the table (table) for the specified database.
Mysql_num_fields: Gets the number of returned fields.
Mysql_num_rows: Gets the number of returned columns.
Mysql_pconnect: Open the MySQL server long-term connection.
Mysql_query: Send out a query string.
Mysql_result: Gets the results of the query.
mysql_select_db: Select a database.
Mysql_tablename: Gets the table name.
ODBC functions

Use ODBC functions to install MySQL ODBC

Odbc_autocommit: Switch automatic change function.
Odbc_binmode: Set binary data processing mode.
Odbc_close: Close ODBC connection.
Odbc_close_all: Closes all ODBC connections.
Odbc_commit: Changes ODBC database.
Odbc_connect: Link to ODBC repository.
Odbc_cursor: Gets the cursor name.
Odbc_do: Execute SQL directives.
Odbc_exec: Execute SQL directives.
Odbc_execute: Executes preset SQL directives.
Odbc_fetch_into: Gets the specified column returned.
Odbc_fetch_row: Get a column back.
Odbc_field_name: Gets the field name.
Odbc_field_type: Get field data form.
Odbc_field_len: Gets the field data length.
Odbc_free_result: Release the memory that returns the data.
Odbc_longreadlen: Sets the maximum value for the return column.
Odbc_num_fields: Gets the number of fields.
Odbc_pconnect: Link to ODBC database for a long time.
Odbc_prepare: Presets SQL directives.
Odbc_num_rows: Gets the number of returned columns.
Odbc_result: Get the information back.
Odbc_result_all: Returns HTML form data.
Odbc_rollback: Undo current transaction.
Odbc_setoption: adjust ODBC settings.

The example shows my article in "Program and Code" in this website and the following routines:

Foreground 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, or you can use electricity
Sub-mail contact,< a href= "mailto:likai333@21cn.com" >likai333@21cn.com</a >. </small ></td >
</tr >
< tr >
< TD valign= "top" width= "251" height= "to" >< small > Your name:</small ></td >
< TD width= "462" height= ">< small >< input name=" name "size=" "> </small ></td >
</tr >
< tr >
< TD valign= "top" width= "251" height= ">< small > your email:</small ></td >
< TD width= "462" height= ">< small >< input name=" Usermail "size=" Notoginseng "></small ></td >
</tr >
< tr >
< TD valign= "top" width= "251" height= ">< small > you want to advertise Web address:</small ></td >
< TD width= "462" height= "a" >< small >< small >< input name= "Userurl" size= "Notoginseng" value= "http://" > </small ></small ></td >
</tr >
< tr >
< TD valign= "top" width= "251" height= ">< small > you want to advertise website name:</small ></td >
< TD width= "462" height= ">< small >< input name=" sitename "size=" "></small ></td >
</tr >
< tr >
< TD valign= "top" width= "251" height= ">< small > Your company name:</small ></td >
< TD width= "462" height= ">< small >< input name=" Company "size=" Notoginseng "></small ></td >
</tr >
< tr >
< TD valign= "top" width= "251" height= ">< Small > Your tel:</small ></td >
< TD width= "462" height= ">< small >< input name=" phone "size=" "></small ></td >
</tr >
< tr >

Background 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 "Error occurred, please notify < a href=mailto:likai333@21cn.com > I </a >";
echo "";
}
Else
{echo "successfully warehousing";}

? >

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) is not null default "Notcompany",
Phone varchar (255) NOT NULL default "Notphone",
);