mi1an's Blog

mi1an's Blog

List Of MySQLi Functions in PHP

List Of MySQLi Functions in PHP

mi1an's photo

Published on Apr 23, 2021

3 min read

  • mysqli_affected_rows — Get number of affected rows in previous MySQL operation
  • mysqli_client_encoding — Returns the name of the character set
  • mysqli_close — Close MySQL connection
  • mysqli_connect — Open a connection to a MySQL Server
  • mysqli_create_db — Create a MySQL database
  • mysqli_data_seek — Move internal result pointer
  • mysqli_db_name — Retrieves database name from the call to mysqli_list_dbs
  • mysqli_db_query — Selects a database and executes a query on it
  • mysqli_drop_db — Drop (delete) a MySQL database
  • mysqli_errno — Returns the numerical value of the error message from previous MySQL operation
  • mysqli_error — Returns the text of the error message from previous MySQL operation
  • mysqli_escape_string — Escapes a string for use in a mysqli_query
  • mysqli_fetch_array — Fetch a result row as an associative array, a numeric array, or both
  • mysqli_fetch_assoc — Fetch a result row as an associative array
  • mysqli_fetch_field — Get column information from a result and return as an object
  • mysqli_fetch_lengths — Get the length of each output in a result
  • mysqli_fetch_object — Fetch a result row as an object
  • mysqli_fetch_row — Get a result row as an enumerated array
  • mysqli_field_flags — Get the flags associated with the specified field in a result
  • mysqli_field_len — Returns the length of the specified field
  • mysqli_field_name — Get the name of the specified field in a result
  • mysqli_field_seek — Set result pointer to a specified field offset
  • mysqli_field_table — Get name of the table the specified field is in
  • mysqli_field_type — Get the type of the specified field in a result
  • mysqli_free_result — Free result memory
  • mysqli_get_client_info — Get MySQL client info
  • mysqli_get_host_info — Get MySQL host info
  • mysqli_get_proto_info — Get MySQL protocol info
  • mysqli_get_server_info — Get MySQL server info
  • mysqli_info — Get information about the most recent query
  • mysqli_insert_id — Get the ID generated in the last query
  • mysqli_list_dbs — List databases available on a MySQL server
  • mysqli_list_fields — List MySQL table fields
  • mysqli_list_processes — List MySQL processes
  • mysqli_list_tables — List tables in a MySQL database
  • mysqli_num_fields — Get number of fields in result
  • mysqli_num_rows — Get number of rows in result
  • mysqli_pconnect — Open a persistent connection to a MySQL server
  • mysqli_ping — Ping a server connection or reconnect if there is no connection
  • mysqli_query — Send a MySQL query
  • mysqli_real_escape_string — Escapes special characters in a string for use in an SQL statement
  • mysqli_result — Get result data
  • mysqli_select_db — Select a MySQL database
  • mysqli_set_charset — Sets the client character set
  • mysqli_stat — Get current system status
  • mysqli_tablename — Get table name of field
  • mysqli_thread_id — Return the current thread ID
  • mysqli_unbuffered_query — Send an SQL query to MySQL without fetching and buffering the result rows
Share this