Summary: Field | Method | Constr Detail: Field | Method | Constr

dbal\dbal_mysqli

includes/db/mysqli.php at line 27

Class dbal_mysqli

dbal
    └─dbal_mysqli

public class dbal_mysqli
extends dbal

MySQLi Database Abstraction Layer mysqli-extension has to be compiled with: MySQL 4.1+ or MySQL 5.0+

Field Summary
mixed	$multi_insert

Fields inherited from dbal\dbal
any_char, curtime, db_connect_id, dbname, html_hold, multi_insert, num_queries, one_char, open_queries, persistency, query_hold, query_result, return_on_error, server, sql_error_returned, sql_error_sql, sql_error_triggered, sql_layer, sql_report, sql_server_version, sql_time, transaction, transactions, user

Method Summary
void	sql_affectedrows() Return number of affected rows
void	sql_connect(mixed sqlserver, mixed sqluser, mixed sqlpassword, mixed database, bool port, bool persistency, bool new_link) Connect to server
void	sql_escape(mixed msg) Escape string used in sql query
void	sql_fetchrow(bool query_id) Fetch current row
void	sql_freeresult(bool query_id) Free sql result
void	sql_nextid() Get last inserted id after insert statement
mixed	sql_query(string query, int cache_ttl) Base query method
void	sql_rowseek(mixed rownum, mixed query_id) Seek to given row number rownum is zero-based
string	sql_server_info(bool raw, bool use_cache) Version information about used database

Methods inherited from dbal\dbal
__construct, sql_add_num_queries, sql_bit_and, sql_bit_or, sql_buffer_nested_transactions, sql_build_array, sql_build_query, sql_close, sql_error, sql_fetchfield, sql_fetchrowset, sql_in_set, sql_like_expression, sql_multi_insert, sql_num_queries, sql_query_limit, sql_report, sql_return_on_error

Field Detail

includes/db/mysqli.php at line 29

multi_insert

public mixed $multi_insert = true

Method Detail

includes/db/mysqli.php at line 214

sql_affectedrows

public void sql_affectedrows()

Return number of affected rows

includes/db/mysqli.php at line 34

sql_connect

public  void sql_connect(mixed sqlserver, mixed sqluser, mixed sqlpassword, mixed database, bool port, bool persistency, bool new_link)

Connect to server

includes/db/mysqli.php at line 291

sql_escape

public void sql_escape(mixed msg)

Escape string used in sql query

includes/db/mysqli.php at line 222

sql_fetchrow

public void sql_fetchrow(bool query_id)

Fetch current row

includes/db/mysqli.php at line 271

sql_freeresult

public void sql_freeresult(bool query_id)

Free sql result

includes/db/mysqli.php at line 263

sql_nextid

public void sql_nextid()

Get last inserted id after insert statement

includes/db/mysqli.php at line 147

sql_query

public mixed sql_query(string query, int cache_ttl)

Base query method

Parameters:: query - Contains the SQL query which shall be executed; cache_ttl - Either 0 to avoid caching or the time in seconds which the result shall be kept in cache
Returns:: When casted to bool the returned value returns true on success and false on failure

includes/db/mysqli.php at line 243

sql_rowseek

public void sql_rowseek(mixed rownum, mixed query_id)

Seek to given row number rownum is zero-based

includes/db/mysqli.php at line 89

sql_server_info

public string sql_server_info(bool raw, bool use_cache)

Version information about used database

Parameters:: use_cache - If true, it is safe to retrieve the value from the cache
Returns:: sql server version

Frames No frames