| java.lang.Object
 com.caucho.quercus.module.AbstractQuercusModule
com.caucho.quercus.lib.db.MysqliModule
| Method Summary | |
| static void | escapeString(StringBuilder buf, String unescapedString)
| | public String[] | getLoadedExtensions()
Returns true for the mysql extension. | | public int | mysql_stmt_affected_rows(Mysqli mysqli)
Returns the number of affected rows. | | public boolean | mysql_stmt_close(MysqliStatement stmt)
Closes the statement. | | public int | mysql_stmt_errno(Env env, MysqliStatement stmt)
Returns the error number. | | public String | mysql_stmt_error(Env env, MysqliStatement stmt)
Returns a descrption of the error or an empty strng for no error. | | public static int | mysqli_affected_rows(Mysqli conn)
Returns the number of affected rows. | | public static boolean | mysqli_autocommit(Mysqli conn, boolean mode)
Turns auto-commit on or off. | | public static boolean | mysqli_bind_param(Env env, MysqliStatement stmt, String types, Value[] params)
Alias for
MysqliModule.mysqli_stmt_bind_param . | | public static boolean | mysqli_bind_result(Env env, MysqliStatement stmt, Value[] outParams)
| | public static boolean | mysqli_change_user(Mysqli mysqli, String user, String password, String db)
Changes the user and database. | | public static Value | mysqli_character_set_name(Mysqli conn)
Returns the client encoding. | | public static Value | mysqli_client_encoding(Mysqli conn)
Alias for
MysqliModule.mysqli_character_set_name . | | public static boolean | mysqli_close(Env env, Mysqli conn)
Closes a connection. | | public static boolean | mysqli_commit(Mysqli conn)
Commits the current transaction for the supplied connection. | | public static Mysqli | mysqli_connect(Env env, String host, String userName, String password, String dbname, int port, String socket)
Returns a new connection. | | public static int | mysqli_connect_errno(Env env)
Returns an error code value for the last call to mysqli_connect(),
0 for no previous error. | | public static String | mysqli_connect_error(Env env)
Returns an error description for the last call to mysqli_connect(),
"" for no previous error. | | public static Value | mysqli_data_seek(Env env, MysqliResult result, int rowNumber)
Seeks the specified row.
Parameters:
env - the PHP executing environment
Parameters:
result - the mysqli_result
Parameters:
rowNumber - the row offset true on success or false if the row numberdoes not exist. | | public static int | mysqli_errno(Mysqli conn)
Returns the error code for the most recent function call,
0 for no error. | | public static String | mysqli_error(Env env, Mysqli conn)
Returns the most recent error. | | public static Value | mysqli_escape_string(Mysqli conn, StringValue unescapedString)
| | public static boolean | mysqli_execute(Env env, MysqliStatement stmt)
| | public static Value | mysqli_fetch(Env env, MysqliStatement stmt)
| | public static ArrayValue | mysqli_fetch_array(Env env, MysqliResult result, int type)
Returns a row for the result. | | public static ArrayValue | mysqli_fetch_assoc(Env env, MysqliResult result)
Returns an associative array from the result. | | public static Value | mysqli_fetch_field(Env env, MysqliResult result)
Returns the field metadata. | | public static Value | mysqli_fetch_field_direct(Env env, MysqliResult result, int fieldOffset)
Returns the field metadata. | | public static Value | mysqli_fetch_fields(Env env, MysqliResult result)
Returns an array of field metadata. | | public static Value | mysqli_fetch_lengths(Env env, MysqliResult result)
Returns an array of integers respresenting the size of each column
FALSE if an error occurred. | | public static Value | mysqli_fetch_object(Env env, MysqliResult result)
Returns an object with properties that correspond
to the fetched row and moves the data pointer ahead. | | public static ArrayValue | mysqli_fetch_row(Env env, MysqliResult result)
Returns a row for the result. | | public static int | mysqli_field_count(Mysqli conn)
Returns a boolean to determine if the last query
to the connection returned a resultset. | | public static boolean | mysqli_field_seek(Env env, MysqliResult result, int fieldOffset)
Seeks to the specified field offset. | | public static int | mysqli_field_tell(Env env, MysqliResult result)
Returns the position of the field cursor used for the last
mysqli_fetch_field() call. | | public static boolean | mysqli_free_result(MysqliResult result)
| | public static StringValue | mysqli_get_client_info(Env env)
Returns the MySQL client version. | | public static int | mysqli_get_client_version(Env env)
Returns a number that represents the MySQL client library
version in format:
main_version*10000 + minor_version*100 + sub_version. | | public static String | mysqli_get_host_info(Mysqli conn)
Returns a string describing the type of MySQL
connection in use. | | public static JdbcResultResource | mysqli_get_metadata(Env env, MysqliStatement stmt)
| | public static Value | mysqli_get_proto_info(Mysqli conn)
Return protocol number, for example 10. | | public static String | mysqli_get_server_info(Mysqli conn)
Returns the MySQL server version. | | public static int | mysqli_get_server_version(Mysqli conn)
Returns a number that represents the MySQL server version. | | public static Mysqli | mysqli_init(Env env)
Creates a new mysqli object. | | public static Value | mysqli_insert_id(Mysqli conn)
| | public static boolean | mysqli_more_results(Mysqli conn)
Indicates if one or more result sets are available from
a previous call to mysqli_multi_query. | | public static boolean | mysqli_multi_query(Mysqli conn, String query)
Executes one or multiple queires which are
concatenated by a semicolon. | | public static boolean | mysqli_next_result(Mysqli conn)
Prepares next result set from a previous call to
mysqli_multi_query. | | public static Value | mysqli_num_fields(MysqliResult result)
Returns the number of fields from specified result set. | | public static Value | mysqli_num_rows(Env env, MysqliResult result)
Returns the number of rows in the result set. | | public static boolean | mysqli_options(Mysqli mysqli, int option, Value value)
Sets the options for a connection. | | public static int | mysqli_param_count(Env env, MysqliStatement stmt)
Alias of
MysqliModule.mysqli_stmt_param_count . | | public static boolean | mysqli_ping(Mysqli conn)
| | public static MysqliStatement | mysqli_prepare(Env env, Mysqli conn, String query)
Prepares a statement. | | public static Value | mysqli_query(Env env, Mysqli conn, String sql, int resultMode)
Executes a query and returns the result. | | static Value | mysqli_query(Env env, Mysqli conn, String query, Object... args)
Execute a query with arguments and return a result. | | public static boolean | mysqli_real_connect(Env env, Mysqli mysqli, String host, String userName, String password, String dbname, int port, String socket, int flags)
Connects to the database. | | public static String | mysqli_real_escape_string(Mysqli conn, String unescapedString)
Escapes the following special character in unescapedString. | | public static Value | mysqli_real_query(Env env, Mysqli conn, String query)
Alias for
MysqliModule.mysqli_query . | | public static boolean | mysqli_rollback(Mysqli conn)
Rolls back the current transaction for the * connection. | | public static boolean | mysqli_select_db(Mysqli conn, String dbName)
Select the database for a connection. | | public static boolean | mysqli_set_charset(Mysqli mysqli, String charset)
Sets the character set for a conneciton. | | public static boolean | mysqli_set_opt(Mysqli mysqli, int option, Value value)
Sets the options for a connection. | | public static Value | mysqli_stat(Env env, Mysqli conn)
Returns a string with the status of the connection
or FALSE if error. | | public static boolean | mysqli_stmt_bind_param(Env env, MysqliStatement stmt, String types, Value[] params)
Binds variables for the parameter markers
in SQL statement that was passed to
MysqliModule.mysqli_prepare . | | public static boolean | mysqli_stmt_bind_result(Env env, MysqliStatement stmt, Value[] outParams)
Binds outparams to result set. | | public static boolean | mysqli_stmt_close(MysqliStatement stmt)
Closes a statement. | | public Value | mysqli_stmt_data_seek(Env env, MysqliStatement stmt, int offset)
Seeks to a given result. | | public static int | mysqli_stmt_errno(Env env, MysqliStatement stmt)
Returns the error code for the prepared statement. | | public static String | mysqli_stmt_error(Env env, MysqliStatement stmt)
Returns the error message for the prepared statement. | | public static boolean | mysqli_stmt_execute(Env env, MysqliStatement stmt)
Executes a statement that has been prepared using
MysqliModule.mysqli_prepare . | | public static Value | mysqli_stmt_fetch(Env env, MysqliStatement stmt)
Fetch results from a prepared statement. | | public static boolean | mysqli_stmt_free_result(Env env, MysqliStatement stmt)
Frees the result. | | public static MysqliStatement | mysqli_stmt_init(Env env, Mysqli conn)
| | public static Value | mysqli_stmt_num_rows(Env env, MysqliStatement stmt)
Returns the number of rows. | | public static int | mysqli_stmt_param_count(Env env, MysqliStatement stmt)
Returns an integer representing the number of parameters
or -1 if no query has been prepared. | | public static boolean | mysqli_stmt_prepare(MysqliStatement stmt, String query)
Prepares a statment with a query. | | public static boolean | mysqli_stmt_reset(Env env, MysqliStatement stmt)
Resets a statment. | | public static JdbcResultResource | mysqli_stmt_result_metadata(Env env, MysqliStatement stmt)
| | public static String | mysqli_stmt_sqlstate(Env env, MysqliStatement stmt)
Returns an error string. | | public static boolean | mysqli_stmt_store_result(Env env, MysqliStatement stmt)
Saves the result. | | public static JdbcResultResource | mysqli_store_result(Env env, Mysqli conn)
Transfers the result set from the last query on the
database connection represented by conn. | | public static JdbcResultResource | mysqli_use_result(Env env, Mysqli conn)
| | public static int | mysqli_warning_count(Mysqli conn)
Returns the number of warnings from the last query
in the connection object. |
| AUTO_INCREMENT_FLAG | | final public static int AUTO_INCREMENT_FLAG(Code) | | |
| BINARY_FLAG | | final public static int BINARY_FLAG(Code) | | |
| BINCMP_FLAG | | final public static int BINCMP_FLAG(Code) | | |
| BLOB_FLAG | | final public static int BLOB_FLAG(Code) | | |
| ENUM_FLAG | | final public static int ENUM_FLAG(Code) | | |
| GROUP_FLAG | | final public static int GROUP_FLAG(Code) | | |
| MULTIPLE_KEY_FLAG | | final public static int MULTIPLE_KEY_FLAG(Code) | | |
| MYSQLI_ASSOC | | final public static int MYSQLI_ASSOC(Code) | | |
| MYSQLI_BOTH | | final public static int MYSQLI_BOTH(Code) | | |
| MYSQLI_NUM | | final public static int MYSQLI_NUM(Code) | | |
| MYSQLI_STORE_RESULT | | final public static int MYSQLI_STORE_RESULT(Code) | | |
| MYSQLI_USE_RESULT | | final public static int MYSQLI_USE_RESULT(Code) | | |
| MYSQL_CLIENT_COMPRESS | | final public static int MYSQL_CLIENT_COMPRESS(Code) | | |
| MYSQL_CLIENT_IGNORE_SPACE | | final public static int MYSQL_CLIENT_IGNORE_SPACE(Code) | | |
| MYSQL_CLIENT_INTERACTIVE | | final public static int MYSQL_CLIENT_INTERACTIVE(Code) | | |
| MYSQL_CLIENT_SSL | | final public static int MYSQL_CLIENT_SSL(Code) | | |
| MYSQL_TYPE_BLOB | | final public static int MYSQL_TYPE_BLOB(Code) | | |
| MYSQL_TYPE_DATE | | final public static int MYSQL_TYPE_DATE(Code) | | |
| MYSQL_TYPE_DATETIME | | final public static int MYSQL_TYPE_DATETIME(Code) | | |
| MYSQL_TYPE_DECIMAL | | final public static int MYSQL_TYPE_DECIMAL(Code) | | |
| MYSQL_TYPE_DOUBLE | | final public static int MYSQL_TYPE_DOUBLE(Code) | | |
| MYSQL_TYPE_ENUM | | final public static int MYSQL_TYPE_ENUM(Code) | | |
| MYSQL_TYPE_FLOAT | | final public static int MYSQL_TYPE_FLOAT(Code) | | |
| MYSQL_TYPE_GEOMETRY | | final public static int MYSQL_TYPE_GEOMETRY(Code) | | |
| MYSQL_TYPE_INT24 | | final public static int MYSQL_TYPE_INT24(Code) | | |
| MYSQL_TYPE_LONG | | final public static int MYSQL_TYPE_LONG(Code) | | |
| MYSQL_TYPE_LONGLONG | | final public static int MYSQL_TYPE_LONGLONG(Code) | | |
| MYSQL_TYPE_LONG_BLOB | | final public static int MYSQL_TYPE_LONG_BLOB(Code) | | |
| MYSQL_TYPE_MEDIUM_BLOB | | final public static int MYSQL_TYPE_MEDIUM_BLOB(Code) | | |
| MYSQL_TYPE_NEWDATE | | final public static int MYSQL_TYPE_NEWDATE(Code) | | |
| MYSQL_TYPE_NULL | | final public static int MYSQL_TYPE_NULL(Code) | | |
| MYSQL_TYPE_SET | | final public static int MYSQL_TYPE_SET(Code) | | |
| MYSQL_TYPE_SHORT | | final public static int MYSQL_TYPE_SHORT(Code) | | |
| MYSQL_TYPE_STRING | | final public static int MYSQL_TYPE_STRING(Code) | | |
| MYSQL_TYPE_TIME | | final public static int MYSQL_TYPE_TIME(Code) | | |
| MYSQL_TYPE_TIMESTAMP | | final public static int MYSQL_TYPE_TIMESTAMP(Code) | | |
| MYSQL_TYPE_TINY | | final public static int MYSQL_TYPE_TINY(Code) | | |
| MYSQL_TYPE_TINY_BLOB | | final public static int MYSQL_TYPE_TINY_BLOB(Code) | | |
| MYSQL_TYPE_VAR_STRING | | final public static int MYSQL_TYPE_VAR_STRING(Code) | | |
| MYSQL_TYPE_YEAR | | final public static int MYSQL_TYPE_YEAR(Code) | | |
| NOT_NULL_FLAG | | final public static int NOT_NULL_FLAG(Code) | | |
| NUM_FLAG | | final public static int NUM_FLAG(Code) | | |
| PART_KEY_FLAG | | final public static int PART_KEY_FLAG(Code) | | |
| PRI_KEY_FLAG | | final public static int PRI_KEY_FLAG(Code) | | |
| SET_FLAG | | final public static int SET_FLAG(Code) | | |
| TIMESTAMP_FLAG | | final public static int TIMESTAMP_FLAG(Code) | | |
| UNIQUE_FLAG | | final public static int UNIQUE_FLAG(Code) | | |
| UNIQUE_KEY_FLAG | | final public static int UNIQUE_KEY_FLAG(Code) | | |
| UNSIGNED_FLAG | | final public static int UNSIGNED_FLAG(Code) | | |
| ZEROFILL_FLAG | | final public static int ZEROFILL_FLAG(Code) | | |
| MysqliModule | | public MysqliModule()(Code) | | |
| getLoadedExtensions | | public String[] getLoadedExtensions()(Code) | | Returns true for the mysql extension.
|
| mysql_stmt_affected_rows | | public int mysql_stmt_affected_rows(Mysqli mysqli)(Code) | | Returns the number of affected rows.
|
| mysqli_affected_rows | | public static int mysqli_affected_rows(Mysqli conn)(Code) | | Returns the number of affected rows.
|
| mysqli_autocommit | | public static boolean mysqli_autocommit(Mysqli conn, boolean mode)(Code) | | Turns auto-commit on or off.
|
| mysqli_change_user | | public static boolean mysqli_change_user(Mysqli mysqli, String user, String password, String db)(Code) | | Changes the user and database.
|
| mysqli_character_set_name | | public static Value mysqli_character_set_name(Mysqli conn)(Code) | | Returns the client encoding.
|
| mysqli_close | | public static boolean mysqli_close(Env env, Mysqli conn)(Code) | | Closes a connection.
|
| mysqli_commit | | public static boolean mysqli_commit(Mysqli conn)(Code) | | Commits the current transaction for the supplied connection.
returns true on success or false on failure
|
| mysqli_connect_errno | | public static int mysqli_connect_errno(Env env)(Code) | | Returns an error code value for the last call to mysqli_connect(),
0 for no previous error.
|
| mysqli_connect_error | | public static String mysqli_connect_error(Env env)(Code) | | Returns an error description for the last call to mysqli_connect(),
"" for no previous error.
|
| mysqli_data_seek | | public static Value mysqli_data_seek(Env env, MysqliResult result, int rowNumber)(Code) | | Seeks the specified row.
Parameters:
env - the PHP executing environment
Parameters:
result - the mysqli_result
Parameters:
rowNumber - the row offset true on success or false if the row numberdoes not exist. NULL is returned if an error occurred. |
| mysqli_errno | | public static int mysqli_errno(Mysqli conn)(Code) | | Returns the error code for the most recent function call,
0 for no error.
|
| mysqli_fetch_field_direct | | public static Value mysqli_fetch_field_direct(Env env, MysqliResult result, int fieldOffset)(Code) | | Returns the field metadata.
|
| mysqli_fetch_fields | | public static Value mysqli_fetch_fields(Env env, MysqliResult result)(Code) | | Returns an array of field metadata.
|
| mysqli_fetch_lengths | | public static Value mysqli_fetch_lengths(Env env, MysqliResult result)(Code) | | Returns an array of integers respresenting the size of each column
FALSE if an error occurred.
Parameters:
env - the PHP executing environment
Parameters:
result - the mysqli_result true on success or false if an error occurred.NULL is returned if result is null. |
| mysqli_fetch_object | | public static Value mysqli_fetch_object(Env env, MysqliResult result)(Code) | | Returns an object with properties that correspond
to the fetched row and moves the data pointer ahead.
Parameters:
env - the PHP executing environment
Parameters:
result - the mysqli_result an object that corresponds to the fetchedrow or NULL if there are no more rows in resultset |
| mysqli_field_count | | public static int mysqli_field_count(Mysqli conn)(Code) | | Returns a boolean to determine if the last query
to the connection returned a resultset.
false if no result set, true otherwise |
| mysqli_field_seek | | public static boolean mysqli_field_seek(Env env, MysqliResult result, int fieldOffset)(Code) | | Seeks to the specified field offset.
If the next call to mysql_fetch_field() doesn't include
a field offset, the field offset specified in
mysqli_field_seek() will be returned.
|
| mysqli_field_tell | | public static int mysqli_field_tell(Env env, MysqliResult result)(Code) | | Returns the position of the field cursor used for the last
mysqli_fetch_field() call. This value can be used as an
argument to mysqli_field_seek()
|
| mysqli_free_result | | public static boolean mysqli_free_result(MysqliResult result)(Code) | | Frees a mysqli result
|
| mysqli_get_client_info | | public static StringValue mysqli_get_client_info(Env env)(Code) | | Returns the MySQL client version.
|
| mysqli_get_client_version | | public static int mysqli_get_client_version(Env env)(Code) | | Returns a number that represents the MySQL client library
version in format:
main_version*10000 + minor_version*100 + sub_version.
For example 4.1.0 is returned as 40100.
|
| mysqli_get_host_info | | public static String mysqli_get_host_info(Mysqli conn)(Code) | | Returns a string describing the type of MySQL
connection in use.
|
| mysqli_get_proto_info | | public static Value mysqli_get_proto_info(Mysqli conn)(Code) | | Return protocol number, for example 10.
|
| mysqli_get_server_info | | public static String mysqli_get_server_info(Mysqli conn)(Code) | | Returns the MySQL server version.
|
| mysqli_get_server_version | | public static int mysqli_get_server_version(Mysqli conn)(Code) | | Returns a number that represents the MySQL server version.
|
| mysqli_init | | public static Mysqli mysqli_init(Env env)(Code) | | Creates a new mysqli object.
|
| mysqli_insert_id | | public static Value mysqli_insert_id(Mysqli conn)(Code) | | Returns ID generated for an AUTO_INCREMENT column by the previous
INSERT query on success, 0 if the previous query does not generate
an AUTO_INCREMENT value, or FALSE if no MySQL connection was established
|
| mysqli_more_results | | public static boolean mysqli_more_results(Mysqli conn)(Code) | | Indicates if one or more result sets are available from
a previous call to mysqli_multi_query.
|
| mysqli_multi_query | | public static boolean mysqli_multi_query(Mysqli conn, String query)(Code) | | Executes one or multiple queires which are
concatenated by a semicolon.
|
| mysqli_next_result | | public static boolean mysqli_next_result(Mysqli conn)(Code) | | Prepares next result set from a previous call to
mysqli_multi_query.
|
| mysqli_num_fields | | public static Value mysqli_num_fields(MysqliResult result)(Code) | | Returns the number of fields from specified result set.
|
| mysqli_num_rows | | public static Value mysqli_num_rows(Env env, MysqliResult result)(Code) | | Returns the number of rows in the result set.
Parameters:
env - the PHP executing environment
Parameters:
result - the mysqli_result the number of rows in the result setor NULL, if an error occurred |
| mysqli_options | | public static boolean mysqli_options(Mysqli mysqli, int option, Value value)(Code) | | Sets the options for a connection.
|
| mysqli_ping | | public static boolean mysqli_ping(Mysqli conn)(Code) | | Checks if the connection is still valid
|
| mysqli_query | | public static Value mysqli_query(Env env, Mysqli conn, String sql, int resultMode)(Code) | | Executes a query and returns the result.
|
| mysqli_real_escape_string | | public static String mysqli_real_escape_string(Mysqli conn, String unescapedString)(Code) | | Escapes the following special character in unescapedString.
the escaped string. |
| mysqli_rollback | | public static boolean mysqli_rollback(Mysqli conn)(Code) | | Rolls back the current transaction for the * connection.
true on success or false on failure. |
| mysqli_select_db | | public static boolean mysqli_select_db(Mysqli conn, String dbName)(Code) | | Select the database for a connection.
|
| mysqli_set_charset | | public static boolean mysqli_set_charset(Mysqli mysqli, String charset)(Code) | | Sets the character set for a conneciton.
|
| mysqli_set_opt | | public static boolean mysqli_set_opt(Mysqli mysqli, int option, Value value)(Code) | | Sets the options for a connection.
|
| mysqli_stat | | public static Value mysqli_stat(Env env, Mysqli conn)(Code) | | Returns a string with the status of the connection
or FALSE if error.
|
| mysqli_stmt_bind_param | | public static boolean mysqli_stmt_bind_param(Env env, MysqliStatement stmt, String types, Value[] params)(Code) | | Binds variables for the parameter markers
in SQL statement that was passed to
MysqliModule.mysqli_prepare .
Type specification chars:
- i
- corresponding variable has type integer;
- d
- corresponding variable has type double;
- b
- corresponding variable is a blob and will be sent in packages
- s
- corresponding variable has type string (which really means all other types);
|
| mysqli_stmt_bind_result | | public static boolean mysqli_stmt_bind_result(Env env, MysqliStatement stmt, Value[] outParams)(Code) | | Binds outparams to result set.
|
| mysqli_stmt_errno | | public static int mysqli_stmt_errno(Env env, MysqliStatement stmt)(Code) | | Returns the error code for the prepared statement.
|
| mysqli_stmt_fetch | | public static Value mysqli_stmt_fetch(Env env, MysqliStatement stmt)(Code) | | Fetch results from a prepared statement.
true on success, false on error, null if no more rows. |
| mysqli_stmt_free_result | | public static boolean mysqli_stmt_free_result(Env env, MysqliStatement stmt)(Code) | | Frees the result.
|
| mysqli_stmt_param_count | | public static int mysqli_stmt_param_count(Env env, MysqliStatement stmt)(Code) | | Returns an integer representing the number of parameters
or -1 if no query has been prepared.
|
| mysqli_stmt_prepare | | public static boolean mysqli_stmt_prepare(MysqliStatement stmt, String query)(Code) | | Prepares a statment with a query.
|
| mysqli_stmt_store_result | | public static boolean mysqli_stmt_store_result(Env env, MysqliStatement stmt)(Code) | | Saves the result.
|
| mysqli_warning_count | | public static int mysqli_warning_count(Mysqli conn)(Code) | | Returns the number of warnings from the last query
in the connection object.
number of warnings |
|
|