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

dbal\dbal_mssql_odbc

includes/db/mssql_odbc.php at line 32

Class dbal_mssql_odbc

dbal
    └─dbal_mssql_odbc

public class dbal_mssql_odbc
extends dbal

Unified ODBC functions Unified ODBC functions support any database having ODBC driver, for example Adabas D, IBM DB2, iODBC, Solid, Sybase SQL Anywhere... Here we only support MSSQL Server 2000+ because of the provided schema

Note:: number of bytes returned for returning data depends on odbc.defaultlrl php.ini setting. If it is limited to 4K for example only 4K of data is returned max, resulting in incomplete theme data for example.; odbc.defaultbinmode may affect UTF8 characters

Field Summary
mixed	$last_query_text

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, bool debug) 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/mssql_odbc.php at line 34

last_query_text

public mixed $last_query_text = ''

Method Detail

includes/db/mssql_odbc.php at line 232

sql_affectedrows

public void sql_affectedrows()

Return number of affected rows

includes/db/mssql_odbc.php at line 39

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/mssql_odbc.php at line 351

sql_escape

public void sql_escape(mixed msg)

Escape string used in sql query

includes/db/mssql_odbc.php at line 241

sql_fetchrow

public void sql_fetchrow(bool query_id, bool debug)

Fetch current row

Note:: number of bytes returned depends on odbc.defaultlrl php.ini setting. If it is limited to 4K for example only 4K of data is returned max.

includes/db/mssql_odbc.php at line 325

sql_freeresult

public void sql_freeresult(bool query_id)

Free sql result

includes/db/mssql_odbc.php at line 304

sql_nextid

public void sql_nextid()

Get last inserted id after insert statement

includes/db/mssql_odbc.php at line 146

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/mssql_odbc.php at line 262

sql_rowseek

public void sql_rowseek(mixed rownum, mixed query_id)

Seek to given row number rownum is zero-based

includes/db/mssql_odbc.php at line 82

sql_server_info

public string sql_server_info(bool raw, bool use_cache)

Version information about used database

Parameters:: raw - if true, only return the fetched sql_server_version; use_cache - If true, it is safe to retrieve the value from the cache
Returns:: sql server version

Frames No frames