[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/includes/db/ -> mssql_odbc.php (summary)

(no description)

Copyright: (c) 2005 phpBB Group
License: http://opensource.org/licenses/gpl-license.php GNU Public License
Version: $Id$
File Size: 422 lines (9 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

dbal_mssql_odbc:: (16 methods):
  sql_connect()
  sql_server_info()
  _sql_transaction()
  sql_query()
  _sql_query_limit()
  sql_affectedrows()
  sql_fetchrow()
  sql_nextid()
  sql_freeresult()
  sql_escape()
  sql_lower_text()
  _sql_like_expression()
  _sql_custom_build()
  _sql_error()
  _sql_close()
  _sql_report()


Class: dbal_mssql_odbc  - X-Ref

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

sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)   X-Ref
Connect to server


sql_server_info($raw = false, $use_cache = true)   X-Ref
Version information about used database

param: bool $raw if true, only return the fetched sql_server_version
param: bool $use_cache If true, it is safe to retrieve the value from the cache
return: string sql server version

_sql_transaction($status = 'begin')   X-Ref
SQL Transaction


sql_query($query = '', $cache_ttl = 0)   X-Ref
Base query method

param: string    $query        Contains the SQL query which shall be executed
param: int        $cache_ttl    Either 0 to avoid caching or the time in seconds which the result shall be kept in cache
return: mixed                When casted to bool the returned value returns true on success and false on failure

_sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)   X-Ref
Build LIMIT query


sql_affectedrows()   X-Ref
Return number of affected rows


sql_fetchrow($query_id = false, $debug = false)   X-Ref
Fetch current row


sql_nextid()   X-Ref
Get last inserted id after insert statement


sql_freeresult($query_id = false)   X-Ref
Free sql result


sql_escape($msg)   X-Ref
Escape string used in sql query


sql_lower_text($column_name)   X-Ref
{@inheritDoc}


_sql_like_expression($expression)   X-Ref
Build LIKE expression


_sql_custom_build($stage, $data)   X-Ref
Build db-specific query data


_sql_error()   X-Ref
return sql error array


_sql_close()   X-Ref
Close sql connection


_sql_report($mode, $query = '')   X-Ref
Build db-specific report




Generated: Wed Oct 2 15:03:47 2013 Cross-referenced by PHPXref 0.7.1