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_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
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.
Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection to create a string that can be use to create a legal SQL string that you can use in an SQL statement. The given string is encoded to an escaped SQL string. Returns an escaped string. Characters encoded are NULL (ASCII 0), \n, \r, \, ', ", and Control-Z.
