UNIDAD 7: PHP INTRODUCION A LAS BASES DE DATOS

TEMA 6: FUNCIONES MYSQL

Mysql es un servidor de bases de datos muy rico en funciones, instrucciones y objetos, muchos de las cuales se estaran usando a lo largo de los programas en esta unidad.

Las principales funciones que se usaran algunas son:

mysql_affected_rows - Get number of affected rows in previous MySQL operationmysql_change_user - Change logged in user of the active connectionmysql_client_encoding - Returns the name of the character setmysql_close - Close MySQL connectionmysql_connect - Open a connection to a MySQL Servermysql_create_db - Create a MySQL databasemysql_data_seek - Move internal result pointermysql_db_name - Get result datamysql_db_query - Send a MySQL querymysql_drop_db - Drop (delete) a MySQL databasemysql_errno - Returns the numerical value of the error message from previous MySQL operationmysql_error - Returns the text of the error message from previous MySQL operationmysql_escape_string - Escapes a string for use in a mysql_query.mysql_fetch_array - Fetch a result row as an associative array, a numeric array, or both.mysql_fetch_assoc - Fetch a result row as an associative arraymysql_fetch_field - Get column information from a result and return as an objectmysql_fetch_lengths - Get the length of each output in a resultmysql_fetch_object - Fetch a result row as an objectmysql_fetch_row - Get a result row as an enumerated arraymysql_field_flags - Get the flags associated with the specified field in a resultmysql_field_len - Returns the length of the specified fieldmysql_field_name - Get the name of the specified field in a resultmysql_field_seek - Set result pointer to a specified field offsetmysql_field_table - Get name of the table the specified field is inmysql_field_type - Get the type of the specified field in a resultmysql_free_result - Free result memorymysql_get_client_info - Get MySQL client infomysql_get_host_info - Get MySQL host infomysql_get_proto_info - Get MySQL protocol infomysql_get_server_info - Get MySQL server infomysql_info - Get information about the most recent querymysql_insert_id - Get the ID generated from the previous INSERT operationmysql_list_dbs - List databases available on a MySQL servermysql_list_fields - List MySQL table fieldsmysql_list_processes - List MySQL processesmysql_list_tables - List tables in a MySQL databasemysql_num_fields - Get number of fields in resultmysql_num_rows - Get number of rows in resultmysql_pconnect - Open a persistent connection to a MySQL servermysql_ping - Ping a server connection or reconnect if there is no connectionmysql_query - Send a MySQL querymysql_real_escape_string - Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection.mysql_result - Get result datamysql_select_db - Select a MySQL databasemysql_stat - Get current system statusmysql_tablename - Get table name of fieldmysql_thread_id - Return the current thread IDmysql_unbuffered_query - Send an SQL query to MySQL, without fetching and buffering the result rows

FUENTE: MANUAL DE AYUDA DE PHP

Politica de Privacidad