com.caucho.quercus.lib.db
Class MysqliModule

java.lang.Object
  extended by com.caucho.quercus.module.AbstractQuercusModule
      extended by com.caucho.quercus.lib.db.MysqliModule
All Implemented Interfaces:
QuercusModule

public class MysqliModule
extends AbstractQuercusModule

Quercus mysql routines.


Field Summary
static int AUTO_INCREMENT_FLAG
           
static int BINARY_FLAG
           
static int BINCMP_FLAG
           
static int BLOB_FLAG
           
static int ENUM_FLAG
           
static int GROUP_FLAG
           
static int MULTIPLE_KEY_FLAG
           
static int MYSQL_CLIENT_COMPRESS
           
static int MYSQL_CLIENT_IGNORE_SPACE
           
static int MYSQL_CLIENT_INTERACTIVE
           
static int MYSQL_CLIENT_SSL
           
static int MYSQLI_ASSOC
           
static int MYSQLI_BOTH
           
static int MYSQLI_INIT_COMMAND
           
static int MYSQLI_NUM
           
static int MYSQLI_OPT_CONNECT_TIMEOUT
           
static int MYSQLI_OPT_LOCAL_INFILE
           
static int MYSQLI_READ_DEFAULT_FILE
           
static int MYSQLI_READ_DEFAULT_GROUP
           
static int MYSQLI_STORE_RESULT
           
static int MYSQLI_TYPE_BIT
           
static int MYSQLI_TYPE_BLOB
           
static int MYSQLI_TYPE_CHAR
           
static int MYSQLI_TYPE_DATE
           
static int MYSQLI_TYPE_DATETIME
           
static int MYSQLI_TYPE_DECIMAL
           
static int MYSQLI_TYPE_DOUBLE
           
static int MYSQLI_TYPE_ENUM
           
static int MYSQLI_TYPE_FLOAT
           
static int MYSQLI_TYPE_GEOMETRY
           
static int MYSQLI_TYPE_INT24
           
static int MYSQLI_TYPE_INTERVAL
           
static int MYSQLI_TYPE_LONG
           
static int MYSQLI_TYPE_LONG_BLOB
           
static int MYSQLI_TYPE_LONGLONG
           
static int MYSQLI_TYPE_MEDIUM_BLOB
           
static int MYSQLI_TYPE_NEWDATE
           
static int MYSQLI_TYPE_NEWDECIMAL
           
static int MYSQLI_TYPE_NULL
           
static int MYSQLI_TYPE_SET
           
static int MYSQLI_TYPE_SHORT
           
static int MYSQLI_TYPE_STRING
           
static int MYSQLI_TYPE_TIME
           
static int MYSQLI_TYPE_TIMESTAMP
           
static int MYSQLI_TYPE_TINY
           
static int MYSQLI_TYPE_TINY_BLOB
           
static int MYSQLI_TYPE_VAR_STRING
           
static int MYSQLI_TYPE_YEAR
           
static int MYSQLI_USE_RESULT
           
static int NOT_NULL_FLAG
           
static int NUM_FLAG
           
static int PART_KEY_FLAG
           
static int PRI_KEY_FLAG
           
static int SET_FLAG
           
static int TIMESTAMP_FLAG
           
static int UNIQUE_FLAG
           
static int UNIQUE_KEY_FLAG
           
static int UNSIGNED_FLAG
           
static int ZEROFILL_FLAG
           
 
Fields inherited from class com.caucho.quercus.module.AbstractQuercusModule
PHP_INI_ALL, PHP_INI_PERDIR, PHP_INI_SYSTEM, PHP_INI_USER
 
Constructor Summary
MysqliModule()
           
 
Method Summary
 java.lang.String[] getLoadedExtensions()
          Returns true for the mysql extension.
 boolean mysql_stmt_close(MysqliStatement stmt)
          Closes the statement.
 int mysql_stmt_errno(Env env, MysqliStatement stmt)
          Returns the error number.
 StringValue mysql_stmt_error(Env env, MysqliStatement stmt)
          Returns a descrption of the error or an empty strng for no error.
static int mysqli_affected_rows(Mysqli conn)
          Returns the number of affected rows.
static boolean mysqli_autocommit(Mysqli conn, boolean mode)
          Turns auto-commit on or off.
static boolean mysqli_bind_param(Env env, MysqliStatement stmt, StringValue types, Value[] params)
          Deprecated alias for mysqli_stmt_bind_param(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement, com.caucho.quercus.env.StringValue, com.caucho.quercus.env.Value[]).
static boolean mysqli_bind_result(Env env, MysqliStatement stmt, Value[] outParams)
          Deprecated alias for mysqli_stmt_bind_result(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement, com.caucho.quercus.env.Value[]).
static boolean mysqli_change_user(Mysqli mysqli, java.lang.String user, java.lang.String password, java.lang.String db)
          Changes the user and database.
static Value mysqli_character_set_name(Env env, Mysqli conn)
          Returns the client encoding.
static Value mysqli_client_encoding(Env env, Mysqli conn)
          Alias for mysqli_character_set_name(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli).
static boolean mysqli_close(Env env, Mysqli conn)
          Closes a connection.
static boolean mysqli_commit(Mysqli conn)
          Commits the current transaction for the supplied connection.
static int mysqli_connect_errno(Env env)
          Returns an error code value for the last call to mysqli_connect(), 0 for no previous error.
static StringValue mysqli_connect_error(Env env)
          Returns an error description for the last call to mysqli_connect(), "" for no previous error.
static Mysqli mysqli_connect(Env env, StringValue host, StringValue userName, StringValue password, java.lang.String dbname, int port, StringValue socket)
          Returns a new connection.
static Value mysqli_data_seek(Env env, MysqliResult result, int rowNumber)
          Seeks the specified row.
static Value mysqli_errno(Mysqli conn)
          Returns the error code for the most recent function call, 0 for no error.
static Value mysqli_error(Env env, Mysqli conn)
          Returns the most recent error.
static Value mysqli_escape_string(Env env, Mysqli conn, StringValue unescapedString)
          Alias for mysqli_real_escape_string(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli, com.caucho.quercus.env.StringValue)
static boolean mysqli_execute(Env env, MysqliStatement stmt)
          Deprecated alias for mysqli_stmt_execute(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement).
static ArrayValue mysqli_fetch_array(Env env, MysqliResult result, int type)
          Returns a row for the result.
static ArrayValue mysqli_fetch_assoc(Env env, MysqliResult result)
          Returns an associative array from the result.
static Value mysqli_fetch_field_direct(Env env, MysqliResult result, int fieldOffset)
          Returns the field metadata.
static Value mysqli_fetch_field(Env env, MysqliResult result)
          Returns the field metadata.
static Value mysqli_fetch_fields(Env env, MysqliResult result)
          Returns an array of field metadata.
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.
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.
static ArrayValue mysqli_fetch_row(Env env, MysqliResult result)
          Returns a row for the result.
static Value mysqli_fetch(Env env, MysqliStatement stmt)
          Deprecated alias for mysqli_stmt_fetch(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement).
static int mysqli_field_count(Mysqli conn)
          Returns the number of columns for the most recent query.
static boolean mysqli_field_seek(Env env, MysqliResult result, int fieldOffset)
          Seeks to the specified field offset.
static int mysqli_field_tell(Env env, MysqliResult result)
          Returns the position of the field cursor used for the last mysqli_fetch_field() call.
static boolean mysqli_free_result(MysqliResult result)
          Frees a mysqli result
static StringValue mysqli_get_client_info(Env env)
          Returns the MySQL client version.
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.
static Value mysqli_get_host_info(Env env, Mysqli conn)
          Returns a string describing the type of MySQL connection in use.
static JdbcResultResource mysqli_get_metadata(Env env, MysqliStatement stmt)
          Deprecated alias for mysqli_stmt_result_metadata(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement).
static Value mysqli_get_proto_info(Mysqli conn)
          Return protocol number, for example 10.
static Value mysqli_get_server_info(Env env, Mysqli conn)
          Returns the MySQL server version.
static Value mysqli_get_server_version(Mysqli conn)
          Returns a number that represents the MySQL server version.
static Value mysqli_info(Env env, Mysqli conn)
          Get information about the most recent query.
static Mysqli mysqli_init(Env env)
          Creates a new mysqli object.
static Value mysqli_insert_id(Env env, Mysqli conn)
          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
static boolean mysqli_kill(Env env, Mysqli conn, int threadId)
          Terminate a Mysql connection with the given thread id.
static boolean mysqli_more_results(Mysqli conn)
          Indicates if one or more result sets are available from a previous call to mysqli_multi_query.
static boolean mysqli_multi_query(Env env, Mysqli conn, StringValue query)
          Executes one or multiple queires which are concatenated by a semicolon.
static boolean mysqli_next_result(Mysqli conn)
          Prepares next result set from a previous call to mysqli_multi_query.
static Value mysqli_num_fields(MysqliResult result)
          Returns the number of fields from specified result set.
static Value mysqli_num_rows(Env env, MysqliResult result)
          Returns the number of rows in the result set.
static boolean mysqli_options(Mysqli mysqli, int option, Value value)
          Sets the options for a connection.
static int mysqli_param_count(Env env, MysqliStatement stmt)
          Alias of mysqli_stmt_param_count(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement).
static boolean mysqli_ping(Env env, Mysqli conn)
          Checks if the connection is still valid
static MysqliStatement mysqli_prepare(Env env, Mysqli conn, StringValue query)
          Prepares a statement.
static Value mysqli_query(Env env, Mysqli conn, StringValue sql, int resultMode)
          Executes a query and returns the result.
static boolean mysqli_real_connect(Env env, Mysqli mysqli, StringValue host, StringValue userName, StringValue password, StringValue dbname, int port, StringValue socket, int flags)
          Connects to the database.
static Value mysqli_real_escape_string(Env env, Mysqli conn, StringValue unescapedString)
          Escapes the following special character in unescapedString.
static boolean mysqli_real_query(Env env, Mysqli conn, StringValue query)
          Execute an single query against the database whose result can then be retrieved or stored using the mysqli_store_result() or mysqli_use_result() functions.
static boolean mysqli_rollback(Mysqli conn)
          Rolls back the current transaction for the * connection.
static boolean mysqli_select_db(Mysqli conn, java.lang.String dbName)
          Select the database for a connection.
static boolean mysqli_set_charset(Mysqli mysqli, java.lang.String charset)
          Sets the character set for a conneciton.
static boolean mysqli_set_opt(Mysqli mysqli, int option, Value value)
          Alias of mysqli_options(com.caucho.quercus.lib.db.Mysqli, int, com.caucho.quercus.env.Value).
static Value mysqli_sqlstate(Env env, Mysqli conn)
          Returns an error string.
static Value mysqli_stat(Env env, Mysqli conn)
          Returns a string with the status of the connection or FALSE if error.
static int mysqli_stmt_affected_rows(Env env, MysqliStatement stmt)
          Return the number of rows affected by an INSERT, UPDATE, or DELETE query.
static boolean mysqli_stmt_bind_param(Env env, MysqliStatement stmt, StringValue types, Value[] params)
          Binds variables for the parameter markers in SQL statement that was passed to mysqli_prepare(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli, com.caucho.quercus.env.StringValue).
static boolean mysqli_stmt_bind_result(Env env, MysqliStatement stmt, Value[] outParams)
          Binds outparams to result set.
static boolean mysqli_stmt_close(Env env, MysqliStatement stmt)
          Closes a statement.
 Value mysqli_stmt_data_seek(Env env, MysqliStatement stmt, int offset)
          Seeks to a given result.
static int mysqli_stmt_errno(Env env, MysqliStatement stmt)
          Returns the error code for the prepared statement.
static StringValue mysqli_stmt_error(Env env, MysqliStatement stmt)
          Returns the error message for the prepared statement.
static boolean mysqli_stmt_execute(Env env, MysqliStatement stmt)
          Executes a statement that has been prepared using mysqli_prepare(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli, com.caucho.quercus.env.StringValue).
static Value mysqli_stmt_fetch(Env env, MysqliStatement stmt)
          Fetch results from a prepared statement.
static int mysqli_stmt_field_count(Env env, MysqliStatement stmt)
          Undocumented
static boolean mysqli_stmt_free_result(Env env, MysqliStatement stmt)
          Frees the result.
static MysqliStatement mysqli_stmt_init(Env env, Mysqli conn)
          Returns a statement for use with mysqli_stmt_prepare(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement, com.caucho.quercus.env.StringValue)
static Value mysqli_stmt_num_rows(Env env, MysqliStatement stmt)
          Returns the number of rows.
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.
static boolean mysqli_stmt_prepare(Env env, MysqliStatement stmt, StringValue query)
          Prepares a statment with a query.
static boolean mysqli_stmt_reset(Env env, MysqliStatement stmt)
          Resets a statment.
static JdbcResultResource mysqli_stmt_result_metadata(Env env, MysqliStatement stmt)
          Returns result information for metadata
static Value mysqli_stmt_sqlstate(Env env, MysqliStatement stmt)
          Returns an error string.
static boolean mysqli_stmt_store_result(Env env, MysqliStatement stmt)
          Saves the result.
static JdbcResultResource mysqli_store_result(Env env, Mysqli conn)
          Transfers the result set from the last query on the database connection represented by conn.
static Value mysqli_thread_id(Env env, Mysqli conn)
          Query an identifier that corresponds to this specific connection.
static JdbcResultResource mysqli_use_result(Env env, Mysqli conn)
          Initiate a result set retrieval.
static int mysqli_warning_count(Env env, Mysqli conn)
          Returns the number of warnings from the last query in the connection object.
 
Methods inherited from class com.caucho.quercus.module.AbstractQuercusModule
addConstant, addConstant, addConstant, getConstMap, getIniDefinitions
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

MYSQLI_ASSOC

public static final int MYSQLI_ASSOC
See Also:
Constant Field Values

MYSQLI_NUM

public static final int MYSQLI_NUM
See Also:
Constant Field Values

MYSQLI_BOTH

public static final int MYSQLI_BOTH
See Also:
Constant Field Values

MYSQLI_USE_RESULT

public static final int MYSQLI_USE_RESULT
See Also:
Constant Field Values

MYSQLI_STORE_RESULT

public static final int MYSQLI_STORE_RESULT
See Also:
Constant Field Values

NOT_NULL_FLAG

public static final int NOT_NULL_FLAG
See Also:
Constant Field Values

PRI_KEY_FLAG

public static final int PRI_KEY_FLAG
See Also:
Constant Field Values

UNIQUE_KEY_FLAG

public static final int UNIQUE_KEY_FLAG
See Also:
Constant Field Values

MULTIPLE_KEY_FLAG

public static final int MULTIPLE_KEY_FLAG
See Also:
Constant Field Values

BLOB_FLAG

public static final int BLOB_FLAG
See Also:
Constant Field Values

UNSIGNED_FLAG

public static final int UNSIGNED_FLAG
See Also:
Constant Field Values

ZEROFILL_FLAG

public static final int ZEROFILL_FLAG
See Also:
Constant Field Values

BINARY_FLAG

public static final int BINARY_FLAG
See Also:
Constant Field Values

ENUM_FLAG

public static final int ENUM_FLAG
See Also:
Constant Field Values

AUTO_INCREMENT_FLAG

public static final int AUTO_INCREMENT_FLAG
See Also:
Constant Field Values

TIMESTAMP_FLAG

public static final int TIMESTAMP_FLAG
See Also:
Constant Field Values

SET_FLAG

public static final int SET_FLAG
See Also:
Constant Field Values

NUM_FLAG

public static final int NUM_FLAG
See Also:
Constant Field Values

PART_KEY_FLAG

public static final int PART_KEY_FLAG
See Also:
Constant Field Values

GROUP_FLAG

public static final int GROUP_FLAG
See Also:
Constant Field Values

UNIQUE_FLAG

public static final int UNIQUE_FLAG
See Also:
Constant Field Values

BINCMP_FLAG

public static final int BINCMP_FLAG
See Also:
Constant Field Values

MYSQLI_TYPE_DECIMAL

public static final int MYSQLI_TYPE_DECIMAL
See Also:
Constant Field Values

MYSQLI_TYPE_TINY

public static final int MYSQLI_TYPE_TINY
See Also:
Constant Field Values

MYSQLI_TYPE_SHORT

public static final int MYSQLI_TYPE_SHORT
See Also:
Constant Field Values

MYSQLI_TYPE_LONG

public static final int MYSQLI_TYPE_LONG
See Also:
Constant Field Values

MYSQLI_TYPE_FLOAT

public static final int MYSQLI_TYPE_FLOAT
See Also:
Constant Field Values

MYSQLI_TYPE_DOUBLE

public static final int MYSQLI_TYPE_DOUBLE
See Also:
Constant Field Values

MYSQLI_TYPE_NULL

public static final int MYSQLI_TYPE_NULL
See Also:
Constant Field Values

MYSQLI_TYPE_TIMESTAMP

public static final int MYSQLI_TYPE_TIMESTAMP
See Also:
Constant Field Values

MYSQLI_TYPE_LONGLONG

public static final int MYSQLI_TYPE_LONGLONG
See Also:
Constant Field Values

MYSQLI_TYPE_INT24

public static final int MYSQLI_TYPE_INT24
See Also:
Constant Field Values

MYSQLI_TYPE_DATE

public static final int MYSQLI_TYPE_DATE
See Also:
Constant Field Values

MYSQLI_TYPE_TIME

public static final int MYSQLI_TYPE_TIME
See Also:
Constant Field Values

MYSQLI_TYPE_DATETIME

public static final int MYSQLI_TYPE_DATETIME
See Also:
Constant Field Values

MYSQLI_TYPE_YEAR

public static final int MYSQLI_TYPE_YEAR
See Also:
Constant Field Values

MYSQLI_TYPE_NEWDATE

public static final int MYSQLI_TYPE_NEWDATE
See Also:
Constant Field Values

MYSQLI_TYPE_BIT

public static final int MYSQLI_TYPE_BIT
See Also:
Constant Field Values

MYSQLI_TYPE_NEWDECIMAL

public static final int MYSQLI_TYPE_NEWDECIMAL
See Also:
Constant Field Values

MYSQLI_TYPE_ENUM

public static final int MYSQLI_TYPE_ENUM
See Also:
Constant Field Values

MYSQLI_TYPE_SET

public static final int MYSQLI_TYPE_SET
See Also:
Constant Field Values

MYSQLI_TYPE_TINY_BLOB

public static final int MYSQLI_TYPE_TINY_BLOB
See Also:
Constant Field Values

MYSQLI_TYPE_MEDIUM_BLOB

public static final int MYSQLI_TYPE_MEDIUM_BLOB
See Also:
Constant Field Values

MYSQLI_TYPE_LONG_BLOB

public static final int MYSQLI_TYPE_LONG_BLOB
See Also:
Constant Field Values

MYSQLI_TYPE_BLOB

public static final int MYSQLI_TYPE_BLOB
See Also:
Constant Field Values

MYSQLI_TYPE_VAR_STRING

public static final int MYSQLI_TYPE_VAR_STRING
See Also:
Constant Field Values

MYSQLI_TYPE_STRING

public static final int MYSQLI_TYPE_STRING
See Also:
Constant Field Values

MYSQLI_TYPE_GEOMETRY

public static final int MYSQLI_TYPE_GEOMETRY
See Also:
Constant Field Values

MYSQLI_TYPE_CHAR

public static final int MYSQLI_TYPE_CHAR
See Also:
Constant Field Values

MYSQLI_TYPE_INTERVAL

public static final int MYSQLI_TYPE_INTERVAL
See Also:
Constant Field Values

MYSQL_CLIENT_COMPRESS

public static final int MYSQL_CLIENT_COMPRESS
See Also:
Constant Field Values

MYSQL_CLIENT_IGNORE_SPACE

public static final int MYSQL_CLIENT_IGNORE_SPACE
See Also:
Constant Field Values

MYSQL_CLIENT_INTERACTIVE

public static final int MYSQL_CLIENT_INTERACTIVE
See Also:
Constant Field Values

MYSQL_CLIENT_SSL

public static final int MYSQL_CLIENT_SSL
See Also:
Constant Field Values

MYSQLI_READ_DEFAULT_GROUP

public static final int MYSQLI_READ_DEFAULT_GROUP
See Also:
Constant Field Values

MYSQLI_READ_DEFAULT_FILE

public static final int MYSQLI_READ_DEFAULT_FILE
See Also:
Constant Field Values

MYSQLI_OPT_CONNECT_TIMEOUT

public static final int MYSQLI_OPT_CONNECT_TIMEOUT
See Also:
Constant Field Values

MYSQLI_OPT_LOCAL_INFILE

public static final int MYSQLI_OPT_LOCAL_INFILE
See Also:
Constant Field Values

MYSQLI_INIT_COMMAND

public static final int MYSQLI_INIT_COMMAND
See Also:
Constant Field Values
Constructor Detail

MysqliModule

public MysqliModule()
Method Detail

getLoadedExtensions

public java.lang.String[] getLoadedExtensions()
Returns true for the mysql extension.

Specified by:
getLoadedExtensions in interface QuercusModule
Overrides:
getLoadedExtensions in class AbstractQuercusModule

mysqli_affected_rows

public static int mysqli_affected_rows(Mysqli conn)
Returns the number of affected rows.


mysqli_autocommit

public static boolean mysqli_autocommit(Mysqli conn,
                                        boolean mode)
Turns auto-commit on or off.


mysqli_bind_param

public static boolean mysqli_bind_param(Env env,
                                        MysqliStatement stmt,
                                        StringValue types,
                                        Value[] params)
Deprecated alias for mysqli_stmt_bind_param(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement, com.caucho.quercus.env.StringValue, com.caucho.quercus.env.Value[]).


mysqli_commit

public static boolean mysqli_commit(Mysqli conn)
Commits the current transaction for the supplied connection. returns true on success or false on failure


mysqli_character_set_name

public static Value mysqli_character_set_name(Env env,
                                              Mysqli conn)
Returns the client encoding.


mysqli_client_encoding

public static Value mysqli_client_encoding(Env env,
                                           Mysqli conn)
Alias for mysqli_character_set_name(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli).


mysqli_close

public static boolean mysqli_close(Env env,
                                   Mysqli conn)
Closes a connection.


mysqli_connect

public static Mysqli mysqli_connect(Env env,
                                    StringValue host,
                                    StringValue userName,
                                    StringValue password,
                                    java.lang.String dbname,
                                    int port,
                                    StringValue socket)
                             throws java.lang.IllegalStateException
Returns a new connection.

Throws:
java.lang.IllegalStateException

mysqli_connect_errno

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.


mysqli_connect_error

public static StringValue mysqli_connect_error(Env env)
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)
Seeks the specified row.

Parameters:
env - the PHP executing environment
result - the mysqli_result
rowNumber - the row offset
Returns:
true on success or false if the row number does not exist. NULL is returned if an error occurred.

mysqli_errno

public static Value mysqli_errno(Mysqli conn)
Returns the error code for the most recent function call, 0 for no error.


mysqli_escape_string

public static Value mysqli_escape_string(Env env,
                                         Mysqli conn,
                                         StringValue unescapedString)
Alias for mysqli_real_escape_string(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli, com.caucho.quercus.env.StringValue)


mysqli_fetch

public static Value mysqli_fetch(Env env,
                                 MysqliStatement stmt)
Deprecated alias for mysqli_stmt_fetch(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement).


mysqli_fetch_field_direct

public static Value mysqli_fetch_field_direct(Env env,
                                              MysqliResult result,
                                              int fieldOffset)
Returns the field metadata.


mysqli_fetch_field

public static Value mysqli_fetch_field(Env env,
                                       MysqliResult result)
Returns the field metadata.


mysqli_fetch_fields

public static Value mysqli_fetch_fields(Env env,
                                        MysqliResult result)
Returns an array of field metadata.


mysqli_fetch_lengths

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.

Parameters:
env - the PHP executing environment
result - the mysqli_result
Returns:
true on success or false if an error occurred. NULL is returned if result is null.

mysqli_field_seek

public static boolean mysqli_field_seek(Env env,
                                        MysqliResult result,
                                        int fieldOffset)
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)
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)
Frees a mysqli result


mysqli_insert_id

public static Value mysqli_insert_id(Env env,
                                     Mysqli conn)
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_num_fields

public static Value mysqli_num_fields(MysqliResult result)
Returns the number of fields from specified result set.


mysqli_multi_query

public static boolean mysqli_multi_query(Env env,
                                         Mysqli conn,
                                         StringValue query)
Executes one or multiple queires which are concatenated by a semicolon.


mysqli_more_results

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.


mysqli_next_result

public static boolean mysqli_next_result(Mysqli conn)
Prepares next result set from a previous call to mysqli_multi_query.


mysqli_stmt_errno

public static int mysqli_stmt_errno(Env env,
                                    MysqliStatement stmt)
Returns the error code for the prepared statement.


mysqli_stmt_error

public static StringValue mysqli_stmt_error(Env env,
                                            MysqliStatement stmt)
Returns the error message for the prepared statement.


mysqli_error

public static Value mysqli_error(Env env,
                                 Mysqli conn)
Returns the most recent error.


mysqli_field_count

public static int mysqli_field_count(Mysqli conn)
Returns the number of columns for the most recent query.


mysqli_fetch_array

public static ArrayValue mysqli_fetch_array(Env env,
                                            MysqliResult result,
                                            int type)
Returns a row for the result.


mysqli_fetch_assoc

public static ArrayValue mysqli_fetch_assoc(Env env,
                                            MysqliResult result)
Returns an associative array from the result.


mysqli_fetch_row

public static ArrayValue mysqli_fetch_row(Env env,
                                          MysqliResult result)
Returns a row for the result. Return NULL if there are no more rows.


mysqli_fetch_object

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.

Parameters:
env - the PHP executing environment
result - the mysqli_result
Returns:
an object that corresponds to the fetched row or NULL if there are no more rows in resultset

mysqli_get_client_info

public static StringValue mysqli_get_client_info(Env env)
Returns the MySQL client version.


mysqli_get_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. For example 4.1.0 is returned as 40100.


mysqli_get_host_info

public static Value mysqli_get_host_info(Env env,
                                         Mysqli conn)
Returns a string describing the type of MySQL connection in use.


mysqli_get_proto_info

public static Value mysqli_get_proto_info(Mysqli conn)
Return protocol number, for example 10.


mysqli_get_server_info

public static Value mysqli_get_server_info(Env env,
                                           Mysqli conn)
Returns the MySQL server version.


mysqli_get_server_version

public static Value mysqli_get_server_version(Mysqli conn)
Returns a number that represents the MySQL server version.


mysqli_num_rows

public static Value mysqli_num_rows(Env env,
                                    MysqliResult result)
Returns the number of rows in the result set.

Parameters:
env - the PHP executing environment
result - the mysqli_result
Returns:
the number of rows in the result set or NULL, if an error occurred

mysqli_options

public static boolean mysqli_options(Mysqli mysqli,
                                     int option,
                                     Value value)
Sets the options for a connection.


mysqli_set_opt

public static boolean mysqli_set_opt(Mysqli mysqli,
                                     int option,
                                     Value value)
Alias of mysqli_options(com.caucho.quercus.lib.db.Mysqli, int, com.caucho.quercus.env.Value).


mysqli_param_count

public static int mysqli_param_count(Env env,
                                     MysqliStatement stmt)
Alias of mysqli_stmt_param_count(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement).


mysqli_rollback

public static boolean mysqli_rollback(Mysqli conn)
Rolls back the current transaction for the * connection.

Returns:
true on success or false on failure.

mysqli_set_charset

public static boolean mysqli_set_charset(Mysqli mysqli,
                                         java.lang.String charset)
Sets the character set for a conneciton.


mysqli_stmt_num_rows

public static Value mysqli_stmt_num_rows(Env env,
                                         MysqliStatement stmt)
Returns the number of rows.


mysqli_stmt_param_count

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.


mysqli_stmt_prepare

public static boolean mysqli_stmt_prepare(Env env,
                                          MysqliStatement stmt,
                                          StringValue query)
Prepares a statment with a query.


mysqli_stmt_reset

public static boolean mysqli_stmt_reset(Env env,
                                        MysqliStatement stmt)
Resets a statment.


mysqli_stmt_result_metadata

public static JdbcResultResource mysqli_stmt_result_metadata(Env env,
                                                             MysqliStatement stmt)
Returns result information for metadata


mysqli_sqlstate

public static Value mysqli_sqlstate(Env env,
                                    Mysqli conn)
Returns an error string.


mysqli_stmt_sqlstate

public static Value mysqli_stmt_sqlstate(Env env,
                                         MysqliStatement stmt)
Returns an error string.


mysqli_stmt_store_result

public static boolean mysqli_stmt_store_result(Env env,
                                               MysqliStatement stmt)
Saves the result.


mysqli_store_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. Used in conjunction with mysqli_multi_query(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli, com.caucho.quercus.env.StringValue)


mysqli_use_result

public static JdbcResultResource mysqli_use_result(Env env,
                                                   Mysqli conn)
Initiate a result set retrieval. This method is useful when dealing with multiple results from a multi-query. Currently, unbuffered results are not supported so this method always uses buffered results.


mysqli_warning_count

public static int mysqli_warning_count(Env env,
                                       Mysqli conn)
Returns the number of warnings from the last query in the connection object.

Returns:
number of warnings

mysqli_ping

public static boolean mysqli_ping(Env env,
                                  Mysqli conn)
Checks if the connection is still valid


mysqli_query

public static Value mysqli_query(Env env,
                                 Mysqli conn,
                                 StringValue sql,
                                 int resultMode)
Executes a query and returns the result.


mysqli_real_connect

public static boolean mysqli_real_connect(Env env,
                                          Mysqli mysqli,
                                          StringValue host,
                                          StringValue userName,
                                          StringValue password,
                                          StringValue dbname,
                                          int port,
                                          StringValue socket,
                                          int flags)
Connects to the database.


mysqli_real_escape_string

public static Value mysqli_real_escape_string(Env env,
                                              Mysqli conn,
                                              StringValue unescapedString)
Escapes the following special character in unescapedString.

Returns:
the escaped string.

mysqli_real_query

public static boolean mysqli_real_query(Env env,
                                        Mysqli conn,
                                        StringValue query)
Execute an single query against the database whose result can then be retrieved or stored using the mysqli_store_result() or mysqli_use_result() functions.


mysqli_select_db

public static boolean mysqli_select_db(Mysqli conn,
                                       java.lang.String dbName)
Select the database for a connection.


mysqli_stat

public static Value mysqli_stat(Env env,
                                Mysqli conn)
Returns a string with the status of the connection or FALSE if error.


mysqli_stmt_affected_rows

public static int mysqli_stmt_affected_rows(Env env,
                                            MysqliStatement stmt)
Return the number of rows affected by an INSERT, UPDATE, or DELETE query. Unlike mysqli_stmt_num_rows(), this method does not return the number of rows matched by a SELECT query.


mysqli_stmt_bind_param

public static boolean mysqli_stmt_bind_param(Env env,
                                             MysqliStatement stmt,
                                             StringValue types,
                                             Value[] params)
Binds variables for the parameter markers in SQL statement that was passed to mysqli_prepare(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli, com.caucho.quercus.env.StringValue). 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)
Binds outparams to result set.


mysql_stmt_close

public boolean mysql_stmt_close(MysqliStatement stmt)
Closes the statement.


mysqli_stmt_data_seek

public Value mysqli_stmt_data_seek(Env env,
                                   MysqliStatement stmt,
                                   int offset)
Seeks to a given result.

Returns:
NULL on sucess or FALSE on failure

mysql_stmt_errno

public int mysql_stmt_errno(Env env,
                            MysqliStatement stmt)
Returns the error number.


mysql_stmt_error

public StringValue mysql_stmt_error(Env env,
                                    MysqliStatement stmt)
Returns a descrption of the error or an empty strng for no error.


mysqli_stmt_execute

public static boolean mysqli_stmt_execute(Env env,
                                          MysqliStatement stmt)
Executes a statement that has been prepared using mysqli_prepare(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.Mysqli, com.caucho.quercus.env.StringValue).

Returns:
true on success or false on failure

mysqli_stmt_fetch

public static Value mysqli_stmt_fetch(Env env,
                                      MysqliStatement stmt)
Fetch results from a prepared statement.

Returns:
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)
Frees the result.


mysqli_bind_result

public static boolean mysqli_bind_result(Env env,
                                         MysqliStatement stmt,
                                         Value[] outParams)
Deprecated alias for mysqli_stmt_bind_result(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement, com.caucho.quercus.env.Value[]).


mysqli_change_user

public static boolean mysqli_change_user(Mysqli mysqli,
                                         java.lang.String user,
                                         java.lang.String password,
                                         java.lang.String db)
Changes the user and database.


mysqli_execute

public static boolean mysqli_execute(Env env,
                                     MysqliStatement stmt)
Deprecated alias for mysqli_stmt_execute(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement).


mysqli_get_metadata

public static JdbcResultResource mysqli_get_metadata(Env env,
                                                     MysqliStatement stmt)
Deprecated alias for mysqli_stmt_result_metadata(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement).


mysqli_init

public static Mysqli mysqli_init(Env env)
Creates a new mysqli object.


mysqli_prepare

public static MysqliStatement mysqli_prepare(Env env,
                                             Mysqli conn,
                                             StringValue query)
Prepares a statement.


mysqli_stmt_close

public static boolean mysqli_stmt_close(Env env,
                                        MysqliStatement stmt)
Closes a statement.


mysqli_stmt_init

public static MysqliStatement mysqli_stmt_init(Env env,
                                               Mysqli conn)
Returns a statement for use with mysqli_stmt_prepare(com.caucho.quercus.env.Env, com.caucho.quercus.lib.db.MysqliStatement, com.caucho.quercus.env.StringValue)


mysqli_info

public static Value mysqli_info(Env env,
                                Mysqli conn)
Get information about the most recent query.


mysqli_stmt_field_count

public static int mysqli_stmt_field_count(Env env,
                                          MysqliStatement stmt)
Undocumented


mysqli_thread_id

public static Value mysqli_thread_id(Env env,
                                     Mysqli conn)
Query an identifier that corresponds to this specific connection. Mysql calls this integer identifier a thread, but it is really a connection identifier.


mysqli_kill

public static boolean mysqli_kill(Env env,
                                  Mysqli conn,
                                  int threadId)
Terminate a Mysql connection with the given thread id. It should be possible to terminate any connection id via this method. In practice, only the mysqli_thread_id API returns a thread id, so only the id of the current thread can be looked up.