[PHP] Practical functions 7_PHP tutorial

//Open a connection to the MySQL server. Returns the connection character successfully, false on failure

int mysql_connect([string server[,string username[,string password]]])
//Open a persistent connection to the MySQL server

int mysql_pconnect([string server[,string username[,string[password]]])
//Close a MySQL connection. Does not affect persistent connections

bool mysql_close([resource link_identifier])
//Select a MySQL database

bool mysql_select_db(string database_name[,int link_identifier])
// Create a MySQL database

bool mysql_create_db(string database name[,int link_identifier])
//Delete a MySQL database

bool mysql_drop_db(string database_name[,int link_identifier])
//Send a SQL query to MySQL

int mysql_querry(string query[,int link_identifier])
//Select a MySQL database and send a SQL query to MySQL

int mysql_db_query (string database,string query[,int link_identifier])
//List the databases available on a MySQL server

int mysql_list_dbs(string database[,int link_identifier])
//List A table in a MySQL database

int mysql_list_tables(string database[,int link_identifier])
//Retrieve information about table field definitions in the MySQL database. The returned result pointer can be mysql_field_flags(), mysql_field_len (), mysql_field_name() and mysql_field_type() functions use

int mysql_list_fields(string database_name,string table_name[,int link_identifier])
//Return the error message of the previous MySQL operation

string mysql_error([int link_identifier])
//Return the error number of the previous MySQL operation

int mysql_errno([int lind_identifier])
//Get the rows affected by the previous MySQL operation Number

int mysql_affected_rows([int link_identifier])
//Get the primary key value generated by the previous Insert operation, which is generated by the auto_increment field of the table

int mysql_insert_id( [int link_identifier])
//Can be used to obtain a data item in the query result data record

mixed mysql_result(resource result,int row[,mixed field])
//Get the result Number of records in the set

int mysql_num_rows(int result)
//Get the number of fields in the result set

int mysql_num_fields(int result)
//Get it in the form of an enumerated array Represented result record

array mysql_fetch_row(int result)
//Get a result record in object mode

object mysql_fetch_object(int result,int[result_type]
//Use To disassemble the query result result into an array variable

array mysql_fetch_array(int result[,int result_type])
//Move the internal pointer in the result record set. If an invalid record is given, an error will occur

int mysql_data_seek(int result_identifier,int row_number)
//Return the length of each field of the record accessed by the previous mysql_fetch_row() in the form of an array

array mysql_fetch_lengths(int result)
//Get the field information from the result and return it as an object

object mysql_fetch_field(int result,int[field_offset])
//Return the result The pointer is set to a specific field offset. The offset will be used the next time mysql_fetch() is called

int mysql_field_seek(int result,int field_offset)
//Get the field name specified in result

string mysql_field_name(int result ,int field_index)
//Get the specified field name

string mysql_field_table(int result,int field_offset)
//Return the length of the specified field

int mysql_field_len(int result, int field_offset)
//Get the type of the specified field in result

string mysql_field_type(int result_offset)
//Get the flag associated with the specified field in result. The returned flag may be: not_null , primary_key, unique_key, multiple_key, blob, unsigned, zerofill, binary, enum, auto_increment, timestamp

string mysql_field_flags(int result,int field_offset)
//Release the memory occupied by result

bool mysql_free_result(int result)