Php/docs/mysqli.constants
From Get docs
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 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. Available since PHP 5.3.0.
MYSQLI_OPT_NET_CMD_BUFFER_SIZE
- The size of the internal command/network buffer. Only valid for mysqlnd. Available since PHP 5.3.0.
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. Available since PHP 5.3.0.
MYSQLI_OPT_SSL_VERIFY_SERVER_CERT
- Available since PHP 5.3.0. (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_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_BINARY_FLAG
- Field is defined as
BINARY
. 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_SERVER_PUBLIC_KEY
- Available since PHP 5.5.0.
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() 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
- Available since PHP 5.6.16. (MySQL 5.6.5 and up)