MySQLi Class

MySQLi Class

  1. mysqli::$affected_rows
  2. mysqli::autocommit()
  3. mysqli::change_user()
  4. mysqli::character_set_name()
  5. mysqli::$client_info
  6. mysqli::$client_version
  7. mysqli::close()
  8. mysqli::commit()
  9. mysqli::$connect_errno
  10. mysqli::$connect_error
  11. mysqli::__construct()
  12. mysqli::debug()
  13. mysqli::dump_debug_info()
  14. mysqli::$errno
  15. mysqli::$error_list
  16. mysqli::$error
  17. mysqli::$field_count
  18. mysqli::get_charset()
  19. mysqli::get_client_info()
  20. mysqli_get_client_stats()
  21. mysqli_get_client_version()
  22. mysqli::get_connection_stats()
  23. mysqli::$host_info
  24. mysqli::$protocol_version
  25. mysqli::$server_info
  26. mysqli::$server_version
  27. mysqli::get_warnings()
  28. mysqli::$info
  29. mysqli::init()
  30. mysqli::$insert_id
  31. mysqli::kill()
  32. mysqli::more_results()
  33. mysqli::multi_query()
  34. mysqli::next_result()
  35. mysqli::options()
  36. mysqli::ping()
  37. mysqli::poll()
  38. mysqli::prepare()
  39. mysqli::query()
  40. mysqli::real_connect()
  41. mysqli::real_escape_string()
  42. mysqli::real_query()
  43. mysqli::reap_async_query()
  44. mysqli::refresh()
  45. mysqli::rollback()
  46. mysqli::rpl_query_type()
  47. mysqli::select_db()
  48. mysqli::send_query()
  49. mysqli::set_charset()
  50. mysqli::set_local_infile_default()
  51. mysqli::set_local_infile_handler()
  52. mysqli::$sqlstate
  53. mysqli::ssl_set()
  54. mysqli::stat()
  55. mysqli::stmt_init()
  56. mysqli::store_result()
  57. mysqli::$thread_id
  58. mysqli::thread_safe()
  59. mysqli::use_result()
  60. mysqli::$warning_count

MySQLi Stmt Class

  1. mysqli_stmt::$affected_rows
  2. mysqli_stmt::attr_get()
  3. mysqli_stmt::attr_set()
  4. mysqli_stmt::bind_param()
  5. mysqli_stmt::bind_result()
  6. mysqli_stmt::close()
  7. mysqli_stmt::data_seek()
  8. mysqli_stmt::$errno
  9. mysqli_stmt::$error_list
  10. mysqli_stmt::$error
  11. mysqli_stmt::execute()
  12. mysqli_stmt::fetch()
  13. mysqli_stmt::$field_count
  14. mysqli_stmt::free_result()
  15. mysqli_stmt::get_result()
  16. mysqli_stmt::get_warnings()
  17. mysqli_stmt::$insert_id
  18. mysqli_stmt::more_results()
  19. mysqli_stmt::next_result()
  20. mysqli_stmt::$num_rows
  21. mysqli_stmt::$param_count
  22. mysqli_stmt::prepare()
  23. mysqli_stmt::reset()
  24. mysqli_stmt::result_metadata()
  25. mysqli_stmt::send_long_data()
  26. mysqli_stmt::$sqlstate
  27. mysqli_stmt::store_result()

MySQLi Result Class

  1. mysqli_result::$current_field
  2. mysqli_result::data_seek()
  3. mysqli_result::fetch_all()
  4. mysqli_result::fetch_array()
  5. mysqli_result::fetch_assoc()
  6. mysqli_result::fetch_field_direct()
  7. mysqli_result::fetch_field()
  8. mysqli_result::fetch_fields()
  9. mysqli_result::fetch_object()
  10. mysqli_result::fetch_row()
  11. mysqli_result::$field_count
  12. mysqli_result::field_seek()
  13. mysqli_result::free()
  14. mysqli_result::$lengths
  15. mysqli_result::$num_rows

MySQLi Driver Class

  1. mysqli_driver::embedded_server_end()
  2. mysqli_driver::embedded_server_start()
  3. mysqli_driver::$report_mode
  4. mysqli_driver::$client_info
  5. mysqli_driver::$client_version
  6. mysqli_driver::$driver_version
  7. mysqli_driver::$embedded
  8. mysqli_driver::$reconnect
  9. mysqli_driver::$report_mode

MySQLi Warning Class

  1. mysqli_warning::__construct()
  2. mysqli_warning::next()
  3. mysqli_warning::$message
  4. mysqli_warning::$sqlstate
  5. mysqli_warning::$errno

MySQL Constants

MYSQLI_READ_DEFAULT_GROUP

Read options from the named group from my.cnf or the file specified with MYSQLI_READ_DEFAULT_FILE

MYSQLI_READ_DEFAULT_FILE

Read options from the named option file instead of from my.cnf

MYSQLI_OPT_CONNECT_TIMEOUT

Connect timeout in seconds

MYSQLI_OPT_LOCAL_INFILE

Enables command LOAD LOCAL INFILE

MYSQLI_INIT_COMMAND

Command to execute when connecting to MySQL server. Will automatically be re-executed when reconnecting.

MYSQLI_CLIENT_SSL

Use SSL (encrypted protocol). This option should not be set by application programs; it is set internally in the MySQL client library

MYSQLI_CLIENT_COMPRESS

Use compression protocol

MYSQLI_CLIENT_INTERACTIVE

Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection. The client’s session wait_timeout variable will be set to the value of the session interactive_timeout variable.

MYSQLI_CLIENT_IGNORE_SPACE

Allow spaces after function names. Makes all functions names reserved words.

MYSQLI_CLIENT_NO_SCHEMA

Don’t allow the db_name.tbl_name.col_name syntax.

MYSQLI_CLIENT_MULTI_QUERIES

Allows multiple semicolon-delimited queries in a single mysqli_query() call.

MYSQLI_STORE_RESULT

For using buffered resultsets

MYSQLI_USE_RESULT

For using unbuffered resultsets

MYSQLI_ASSOC

Columns are returned into the array having the fieldname as the array index.

MYSQLI_NUM

Columns are returned into the array having an enumerated index.

MYSQLI_BOTH

Columns are returned into the array having both a numerical index and the fieldname as the associative index.

MYSQLI_NOT_NULL_FLAG

Indicates that a field is defined as NOT NULL

MYSQLI_PRI_KEY_FLAG

Field is part of a primary index

MYSQLI_UNIQUE_KEY_FLAG

Field is part of a unique index.

MYSQLI_MULTIPLE_KEY_FLAG

Field is part of an index.

MYSQLI_BLOB_FLAG

Field is defined as BLOB

MYSQLI_UNSIGNED_FLAG

Field is defined as UNSIGNED

MYSQLI_ZEROFILL_FLAG

Field is defined as ZEROFILL

MYSQLI_AUTO_INCREMENT_FLAG

Field is defined as AUTO_INCREMENT

MYSQLI_TIMESTAMP_FLAG

Field is defined as TIMESTAMP

MYSQLI_SET_FLAG

Field is defined as SET

MYSQLI_NUM_FLAG

Field is defined as NUMERIC

MYSQLI_PART_KEY_FLAG

Field is part of an multi-index

MYSQLI_GROUP_FLAG

Field is part of GROUP BY

MYSQLI_TYPE_DECIMAL

Field is defined as DECIMAL

MYSQLI_TYPE_NEWDECIMAL

Precision math DECIMAL or NUMERIC field (MySQL 5.0.3 and up)

MYSQLI_TYPE_BIT

Field is defined as BIT (MySQL 5.0.3 and up)

MYSQLI_TYPE_TINY

Field is defined as TINYINT

MYSQLI_TYPE_SHORT

Field is defined as SMALLINT

MYSQLI_TYPE_LONG

Field is defined as INT

MYSQLI_TYPE_FLOAT

Field is defined as FLOAT

MYSQLI_TYPE_DOUBLE

Field is defined as DOUBLE

MYSQLI_TYPE_NULL

Field is defined as DEFAULT NULL

MYSQLI_TYPE_TIMESTAMP

Field is defined as TIMESTAMP

MYSQLI_TYPE_LONGLONG

Field is defined as BIGINT

MYSQLI_TYPE_INT24

Field is defined as MEDIUMINT

MYSQLI_TYPE_DATE

Field is defined as DATE

MYSQLI_TYPE_TIME

Field is defined as TIME

MYSQLI_TYPE_DATETIME

Field is defined as DATETIME

MYSQLI_TYPE_YEAR

Field is defined as YEAR

MYSQLI_TYPE_NEWDATE

Field is defined as DATE

MYSQLI_TYPE_INTERVAL

Field is defined as INTERVAL

MYSQLI_TYPE_ENUM

Field is defined as ENUM

MYSQLI_TYPE_SET

Field is defined as SET

MYSQLI_TYPE_TINY_BLOB

Field is defined as TINYBLOB

MYSQLI_TYPE_MEDIUM_BLOB

Field is defined as MEDIUMBLOB

MYSQLI_TYPE_LONG_BLOB

Field is defined as LONGBLOB

MYSQLI_TYPE_BLOB

Field is defined as BLOB

MYSQLI_TYPE_VAR_STRING

Field is defined as VARCHAR

MYSQLI_TYPE_STRING

Field is defined as CHAR or BINARY

MYSQLI_TYPE_CHAR

Field is defined as TINYINT. For CHAR, see MYSQLI_TYPE_STRING

MYSQLI_TYPE_GEOMETRY

Field is defined as GEOMETRY

MYSQLI_NEED_DATA

More data available for bind variable

MYSQLI_NO_DATA

No more data available for bind variable

MYSQLI_DATA_TRUNCATED

Data truncation occurred. Available since PHP 5.1.0 and MySQL 5.0.5.

MYSQLI_ENUM_FLAG

Field is defined as ENUM. Available since PHP 5.3.0.

MYSQLI_CURSOR_TYPE_FOR_UPDATE

MYSQLI_CURSOR_TYPE_NO_CURSOR

MYSQLI_CURSOR_TYPE_READ_ONLY

MYSQLI_CURSOR_TYPE_SCROLLABLE

MYSQLI_STMT_ATTR_CURSOR_TYPE

 

MYSQLI_STMT_ATTR_PREFETCH_ROWS

 

MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH

 

MYSQLI_SET_CHARSET_NAME

 

MYSQLI_REPORT_INDEX

Report if no index or bad index was used in a query.

MYSQLI_REPORT_ERROR

Report errors from mysqli function calls.

MYSQLI_REPORT_STRICT

Throw a mysqli_sql_exception for errors instead of warnings.

MYSQLI_REPORT_ALL

Set all options on (report all).

MYSQLI_REPORT_OFF

Turns reporting off.

MYSQLI_DEBUG_TRACE_ENABLED

Is set to 1 if mysqli_debug() functionality is enabled.

MYSQLI_SERVER_QUERY_NO_GOOD_INDEX_USED

 

MYSQLI_SERVER_QUERY_NO_INDEX_USED

 

MYSQLI_REFRESH_GRANT

Refreshes the grant tables.

MYSQLI_REFRESH_LOG

Flushes the logs, like executing the FLUSH LOGS SQL statement.

MYSQLI_REFRESH_TABLES

Flushes the table cache, like executing the FLUSH TABLES SQL statement.

MYSQLI_REFRESH_HOSTS

Flushes the host cache, like executing the FLUSH HOSTS SQL statement.

MYSQLI_REFRESH_STATUS

Reset the status variables, like executing the FLUSH STATUS SQL statement.

MYSQLI_REFRESH_THREADS

Flushes the thread cache.

MYSQLI_REFRESH_SLAVE

On a slave replication server: resets the master server information, and restarts the slave. Like executing the RESET SLAVE SQL statement.

MYSQLI_REFRESH_MASTER

On a master replication server: removes the binary log files listed in the binary log index, and truncates the index file. Like executing the RESET MASTER SQL statement.

Share This:

Leave a Reply

Your email address will not be published. Required fields are marked *