Predefined Constants
The constants below are defined by this extension, and will only be available when the extension has either been compiled into PHP or dynamically loaded at runtime.
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_READ_TIMEOUT-
Command execution result timeout in seconds. Available as of PHP 7.2.0.
MYSQLI_OPT_LOCAL_INFILE-
Enables command
LOAD LOCAL INFILE MYSQLI_OPT_INT_AND_FLOAT_NATIVE-
Convert integer and float columns back to PHP numbers. Only valid for mysqlnd.
MYSQLI_OPT_NET_CMD_BUFFER_SIZE-
The size of the internal command/network buffer. Only valid for mysqlnd.
MYSQLI_OPT_NET_READ_BUFFER_SIZE-
Maximum read chunk size in bytes when reading the body of a MySQL command packet. Only valid for mysqlnd.
MYSQLI_OPT_SSL_VERIFY_SERVER_CERT-
Requires MySQL 5.1.10 and up
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_timeoutseconds (instead ofwait_timeoutseconds) of inactivity before closing the connection. The client's sessionwait_timeoutvariable will be set to the value of the sessioninteractive_timeoutvariable. 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_namesyntax. MYSQLI_CLIENT_MULTI_QUERIES-
Allows multiple semicolon-delimited queries in a single mysqli_query() call.
MYSQLI_STORE_RESULT-
For using buffered result sets. It has a value of
0. MYSQLI_USE_RESULT-
For using unbuffered result sets. It has a value of
1. 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
DECIMALorNUMERICfield (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
CHARorBINARY MYSQLI_TYPE_CHAR-
Field is defined as
TINYINT. ForCHAR, seeMYSQLI_TYPE_STRING MYSQLI_TYPE_GEOMETRY-
Field is defined as
GEOMETRY MYSQLI_TYPE_JSON-
Field is defined as
JSON. Only valid for mysqlnd and MySQL 5.7.8 and up. 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 MySQL 5.0.5.
MYSQLI_ENUM_FLAG-
Field is defined as
ENUM. MYSQLI_BINARY_FLAG-
Field is defined as
BINARY. 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_exceptionfor 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_SERVER_PUBLIC_KEY-
MYSQLI_REFRESH_GRANT-
Refreshes the grant tables.
MYSQLI_REFRESH_LOG-
Flushes the logs, like executing the
FLUSH LOGSSQL statement. MYSQLI_REFRESH_TABLES-
Flushes the table cache, like executing the
FLUSH TABLESSQL statement. MYSQLI_REFRESH_HOSTS-
Flushes the host cache, like executing the
FLUSH HOSTSSQL statement. MYSQLI_REFRESH_REPLICA-
Alias of
MYSQLI_REFRESH_SLAVEconstant. Available as of PHP 8.1.0. MYSQLI_REFRESH_STATUS-
Reset the status variables, like executing the
FLUSH STATUSSQL 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 SLAVESQL 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 MASTERSQL statement. MYSQLI_TRANS_COR_AND_CHAIN-
Appends "AND CHAIN" to mysqli_commit() or mysqli_rollback().
MYSQLI_TRANS_COR_AND_NO_CHAIN-
Appends "AND NO CHAIN" to mysqli_commit() or mysqli_rollback().
MYSQLI_TRANS_COR_RELEASE-
Appends "RELEASE" to mysqli_commit() or mysqli_rollback().
MYSQLI_TRANS_COR_NO_RELEASE-
Appends "NO RELEASE" to mysqli_commit() or mysqli_rollback().
MYSQLI_TRANS_START_READ_ONLY-
Start the transaction as "START TRANSACTION READ ONLY" with mysqli_begin_transaction().
MYSQLI_TRANS_START_READ_WRITE-
Start the transaction as "START TRANSACTION READ WRITE" with mysqli_begin_transaction().
MYSQLI_TRANS_START_CONSISTENT_SNAPSHOT-
Start the transaction as "START TRANSACTION WITH CONSISTENT SNAPSHOT" with mysqli_begin_transaction().
MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT-
Requires MySQL 5.6.5 and up.
MYSQLI_IS_MARIADB-
Whether the mysqli extension has been built against a MariaDB client library. Available as of PHP 8.1.2.
