Copyright 1997-2021 the PHP Documentation Group.
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 withMYSQLI_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_timeout
seconds (instead ofwait_timeout
seconds) of inactivity before closing the connection. The client's sessionwait_timeout
variable will be set to the value of the sessioninteractive_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
orNUMERIC
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
orBINARY
-
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_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_SERVER_PUBLIC_KEY
-
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.-
MYSQLI_TRANS_COR_AND_CHAIN
Appends "AND CHAIN" to
mysqli_commit
ormysqli_rollback
.-
MYSQLI_TRANS_COR_AND_NO_CHAIN
Appends "AND NO CHAIN" to
mysqli_commit
ormysqli_rollback
.-
MYSQLI_TRANS_COR_RELEASE
Appends "RELEASE" to
mysqli_commit
ormysqli_rollback
.-
MYSQLI_TRANS_COR_NO_RELEASE
Appends "NO RELEASE" to
mysqli_commit
ormysqli_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.