PHP MySQL functions

Introduction: This is the PHP MySQL function detailed page, introduced and PHP, related knowledge, skills, experience, and some PHP source code and so on.

class= ' pingjiaf ' frameborder= ' 0 ' src= ' http://biancheng.dnbcw.info/pingjia.php?id=329781 ' scrolling= ' no ' >

Http://www.w3school.com.cn/php/php_ref_mysql.asp

Function Description PHP

Mysql_affected_rows ()	Gets the number of record rows affected by the previous MySQL operation.	3
Mysql_change_user ()	Not in favour. Change the user who is logged on in the active connection	3
Mysql_client_encoding ()	Returns the name of the currently connected character set	4
Mysql_close ()	Close the non-persistent MySQL connection.	3
Mysql_connect ()	Open a non-persistent MySQL connection.	3
mysql_create_db ()	Not in favour. Create a new MySQL database. Use mysql_query () instead.	3
Mysql_data_seek ()	Moves the record pointer.	3
Mysql_db_name ()	Returns the database name from a call to Mysql_list_dbs ().	3
Mysql_db_query ()	Not in favour. Send a MySQL query. Use mysql_select_db () and mysql_query () instead.	3
mysql_drop_db ()	Not in favour. Discard (delete) a MySQL database. Use mysql_query () instead.	3
Mysql_errno ()	Returns the numeric encoding of the error message in the previous MySQL operation.	3
Mysql_error ()	Returns the text error message generated by the previous MySQL operation.	3
Mysql_escape_string ()	Not in favour. Escapes a string for mysql_query. Use Mysql_real_escape_string () instead.	4
Mysql_fetch_array ()	Gets a row from the result set as an associative array, or as a numeric array, or both.	3
MYSQL_FETCH_ASSOC ()	Gets a row from the result set as an associative array.	4
Mysql_fetch_field ()	Gets the column information from the result set and returns it as an object.	3
Mysql_fetch_lengths ()	Gets the length of the contents of each field in the result set.	3
Mysql_fetch_object ()	Gets a row from the result set as an object.	3
Mysql_fetch_row ()	Gets a row from the result set as a numeric array.	3
Mysql_field_flags ()	Gets the flags associated with the specified field from the result.	3
Mysql_field_len ()	Returns the length of the specified field.	3
Mysql_field_name ()	Gets the field name of the specified field in the result.	3
Mysql_field_seek ()	Sets the pointer in the result set to the specified field offset.	3
Mysql_field_table ()	Gets the name of the table that contains the specified field.	3
Mysql_field_type ()	Gets the type of the specified field in the result set.	3
Mysql_free_result ()	Releases the resulting memory.	3
Mysql_get_client_info ()	Get MySQL client information.	4
Mysql_get_host_info ()	Get MySQL host information.	4
Mysql_get_proto_info ()	Get MySQL protocol information.	4
Mysql_get_server_info ()	Get MySQL server information.	4
Mysql_info ()	Gets the information for the most recent query.	4
MYSQL_INSERT_ID ()	Gets the ID generated by the INSERT operation in the previous step.	3
Mysql_list_dbs ()	Lists all databases in the MySQL server.	3
Mysql_list_fields ()	Not in favour. Lists the fields in the MySQL results. Use mysql_query () instead.	3
Mysql_list_processes ()	Lists the MySQL process.	4
Mysql_list_tables ()	Not in favour. Lists the tables in the MySQL database. Replace with use mysql_query ().	3
Mysql_num_fields ()	Gets the number of fields in the result set.	3
Mysql_num_rows ()	Gets the number of rows in the result set.	3
Mysql_pconnect ()	Open a persistent connection to the MySQL server.	3
Mysql_ping ()	Ping a server connection, and reconnect if there is no connection.	4
mysql_query ()	Send a MySQL query.	3
Mysql_real_escape_string ()	Escapes special characters in the string used in the SQL statement.	4
Mysql_result ()	Get the result data.	3
mysql_select_db ()	Select MySQL Database.	3
Mysql_stat ()	Gets the current system state.	4
Mysql_tablename ()	Not in favour. Gets the table name. Use mysql_query () instead.	3
MYSQL_THREAD_ID ()	Returns the ID of the current thread.	4
Mysql_unbuffered_query ()	Send a SQL query to MySQL (results are not fetched/cached).	4

More articles on "PHP MySQL functions"

Love EE focus on Java Michael Jackson Video station JSON online tool

Http://biancheng.dnbcw.info/php/329781.html Pageno:12

