PHP Mysql Functions List

  1. mysql_affected_rows — Get number of affected rows in previous MySQL operation
  2. mysql_change_user — Change logged in user of the active connection
  3. mysql_client_encoding — Returns the name of the character set
  4. mysql_close — Close MySQL connection
  5. mysql_connect — Open a connection to a MySQL Server
  6. mysql_create_db — Create a MySQL database
  7. mysql_data_seek — Move internal result pointer
  8. mysql_db_name — Get result data
  9. mysql_db_query — Send a MySQL query
  10. mysql_drop_db — Drop (delete) a MySQL database
  11. mysql_errno — Returns the numerical value of the error message from previous MySQL operation
  12. mysql_error — Returns the text of the error message from previous MySQL operation
  13. mysql_escape_string — Escapes a string for use in a mysql_query.
  14. mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both.
  15. mysql_fetch_assoc — Fetch a result row as an associative array
  16. mysql_fetch_field — Get column information from a result and return as an object
  17. mysql_fetch_lengths — Get the length of each output in a result
  18. mysql_fetch_object — Fetch a result row as an object
  19. mysql_fetch_row — Get a result row as an enumerated array
  20. mysql_field_flags — Get the flags associated with the specified field in a result
  21. mysql_field_len — Returns the length of the specified field
  22. mysql_field_name — Get the name of the specified field in a result
  23. mysql_field_seek — Set result pointer to a specified field offset
  24. mysql_field_table — Get name of the table the specified field is in
  25. mysql_field_type — Get the type of the specified field in a result
  26. mysql_free_result — Free result memory
  27. mysql_get_client_info — Get MySQL client info
  28. mysql_get_host_info — Get MySQL host info
  29. mysql_get_proto_info — Get MySQL protocol info
  30. mysql_get_server_info — Get MySQL server info
  31. mysql_info — Get information about the most recent query
  32. mysql_insert_id — Get the ID generated from the previous INSERT operation
  33. mysql_list_dbs — List databases available on a MySQL server
  34. mysql_list_fields — List MySQL result fields
  35. mysql_list_processes — List MySQL processes
  36. mysql_list_tables — List tables in a MySQL database
  37. mysql_num_fields — Get number of fields in result
  38. mysql_num_rows — Get number of rows in result
  39. mysql_pconnect — Open a persistent connection to a MySQL server
  40. mysql_ping — Ping a server connection or reconnect if there is no connection
  41. mysql_query — Send a MySQL query
  42. mysql_real_escape_string — Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection.
  43. mysql_result — Get result data
  44. mysql_select_db — Select a MySQL database
  45. mysql_stat — Get current system status
  46. mysql_tablename — Get table name of field
  47. mysql_thread_id — Return the current thread ID
  48. mysql_unbuffered_query — Send an SQL query to MySQL, without fetching and buffering the result rows

If you like the post & want to get more then Subscribe our blog posts. Subscribe SunwareTech.net RSS Feed Facebook Twitter Email

Both comments and pings are currently closed.

One Response to “PHP Mysql Functions List”

  1. banibrata says:

    I want to required for all function list

Copyright © Sunware Technologies - Your web partner