[PHP] practical functions 7

[PHP] function 7 // open a connection to the MySQL server. Returns a connector. if the connection fails, returns false.

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. Persistent connection is not affected.

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 an SQL query to MySQL

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

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

Int mysql_list_dbs (string database [, int link_identifier])
// List tables in a MySQL database

Int mysql_list_tables (string database [, int link_identifier])
// Retrieves information about table field definitions in the MySQL database. the returned result pointers can be used by the mysql_field_flags (), mysql_field_len (), mysql_field_name (), and mysql_field_type () functions.

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

String mysql_error ([int link_identifier])
// Returns the error code of the previous MySQL operation.

Int mysql_errno ([int lind_identifier])
// Obtain the number of rows affected by the previous MySQL operation

Int mysql_affected_rows ([int link_identifier])
// Obtain the primary key value generated by the previous Insert operation. this value is generated by the auto_increment field of the table.

Int mysql_insert_id ([int link_identifier])
// Obtain a data item in the query result data record

Mixed mysql_result (resource result, int row [, mixed field])
// Obtain the number of records in the result set

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

Int mysql_num_fields (int result)
// Obtain The Result records in the enumerated array format

Array mysql_fetch_row (int result)
// Obtain a result record by object

Object mysql_fetch_object (int result, int [result_type]
// Used to disassemble the query 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)
// Returns the length of each field of the record accessed by the previous mysql_fetch_row () in an array.

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

Object mysql_fetch_field (int result, int [field_offset])
// Set the result pointer to a specific field offset. This offset will be used when mysql_fetch () is called next time.

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

String mysql_field_name (int result, int field_index)
// Obtain 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)
// Obtain the type of the specified field in result

String mysql_field_type (int result_offset)
// Obtain the flag associated with the specified field in the 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)