|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.caucho.quercus.lib.db.JdbcStatementResource
com.caucho.quercus.lib.db.JdbcPreparedStatementResource
com.caucho.quercus.lib.db.MysqliStatement
public class MysqliStatement
mysqli object oriented API facade
Method Summary | |
---|---|
int |
affected_rows(Env env)
Returns the total number of rows changed, deleted, or inserted by the last executed statement. |
boolean |
bind_param(Env env,
StringValue typeStr,
Value[] params)
Binds variables to a prepared statement as parameters. |
boolean |
bind_result(Env env,
Value[] outParams)
Binds variables to a prepared statement for result storage. |
boolean |
close()
Closes a prepared statement. |
protected JdbcResultResource |
createResultSet(java.sql.ResultSet rs)
|
Value |
data_seek(Env env,
int offset)
Seeks to an arbitrary row in statement result set. |
int |
errno()
Returns the error code for the most recent statement call. |
StringValue |
error(Env env)
Returns a string description for last statement error |
boolean |
execute(Env env)
|
Value |
fetch(Env env)
Fetch results from a prepared statement into the bound variables. |
int |
field_count(Env env)
Returns the number of columns in the last query. |
void |
free_result(Env env)
Frees the associated result. |
JdbcResultResource |
get_result(Env env)
Returns the MysqliResult |
int |
getaffected_rows(Env env)
Quercus function to get the field 'affected_rows'. |
int |
geterrno()
Quercus function to get the field 'errno'. |
StringValue |
geterror(Env env)
Quercus function to get the field 'error'. |
int |
getfield_count(Env env)
Quercus function to get the field 'field_count'. |
Value |
getinsert_id(Env env)
Quercus function to get the field 'insert_id'. |
Value |
getnum_rows(Env env)
Quercus function to get the field 'num_rows'. |
int |
getparam_count(Env env)
Quercus function to get the field 'param_count'. |
StringValue |
getsqlstate(Env env)
Quercus function to get the field 'sqlstate'. |
Value |
insert_id(Env env)
|
Value |
num_rows(Env env)
Returns the number of rows in the result. |
int |
param_count(Env env)
Returns the number of parameter markers for this statement. |
boolean |
prepare(Env env,
java.lang.String query)
Prepare a SQL statement for execution. |
boolean |
reset(Env env)
Resets the statement. |
MysqliResult |
result_metadata(Env env)
mysqli_stmt_result_metadata seems to be some initial step towards getting metadata from a resultset created by a SELECT run by a prepared statement. |
boolean |
send_long_data(Env env,
int paramNumber,
java.lang.String data)
Send data in blocks. |
StringValue |
sqlstate(Env env)
Returns SQLSTATE error from previous statement operation. |
boolean |
store_result(Env env)
Saves the result as buffered. |
Methods inherited from class com.caucho.quercus.lib.db.JdbcPreparedStatementResource |
---|
bindParams, executeImpl, getParam, getParamLength, getPreparedStatement, isPreparable, paramCount, prepareForExecute, setObject, setPreparedStatement |
Methods inherited from class com.caucho.quercus.lib.db.JdbcStatementResource |
---|
bindResults, dataSeek, execute, freeResult, getColumnCount, getConnection, getErrorCode, getErrorMessage, getFieldCount, getJavaConnection, getMetaData, getNumRows, getQuery, getResultSet, getStatementType, isFetchFieldIndexBeforeFieldName, lastInsertId, setError, setErrorCode, setErrorMessage, setQuery, setResultSet, setStatement, toString |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Method Detail |
---|
public boolean execute(Env env)
execute
in class JdbcStatementResource
public int getaffected_rows(Env env)
public int affected_rows(Env env)
env
- the PHP executing environment
public boolean bind_param(Env env, StringValue typeStr, Value[] params)
env
- the PHP executing environmenttypes
- string of i,d,s,b (ie: "idds")params
- array of values (probably Vars)
public boolean bind_result(Env env, Value[] outParams)
env
- the PHP executing environmentoutParams
- the output variables
public boolean close()
close
in class JdbcStatementResource
env
- the PHP executing environment
public Value data_seek(Env env, int offset)
env
- the PHP executing environmentoffset
- row offset
public int errno()
env
- the PHP executing environment
public int geterrno()
public StringValue error(Env env)
env
- the PHP executing environment
public StringValue geterror(Env env)
public Value fetch(Env env)
fetch
in class JdbcStatementResource
env
- the PHP executing environment
public void free_result(Env env)
env
- the PHP executing environmentpublic JdbcResultResource get_result(Env env)
protected JdbcResultResource createResultSet(java.sql.ResultSet rs)
createResultSet
in class JdbcStatementResource
public Value getnum_rows(Env env)
public Value num_rows(Env env)
env
- the PHP executing environment
public int getparam_count(Env env)
public int param_count(Env env)
env
- the PHP executing environment
public boolean prepare(Env env, java.lang.String query)
prepare
in class JdbcPreparedStatementResource
env
- the PHP executing environmentquery
- SQL query
public boolean reset(Env env)
env
- the PHP executing environment
public MysqliResult result_metadata(Env env)
env
- the PHP executing environment
public boolean send_long_data(Env env, int paramNumber, java.lang.String data)
env
- the PHP executing environmentparamNumber
- indicates which parameter to associate the data withdata
- the data to be sent
public StringValue getsqlstate(Env env)
public StringValue sqlstate(Env env)
env
- the PHP executing environment
public boolean store_result(Env env)
env
- the PHP executing environment
public int getfield_count(Env env)
public int field_count(Env env)
public Value getinsert_id(Env env)
public Value insert_id(Env env)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |