[ Index ]

PHP Cross Reference of phpBB 3.0 Beta 3

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: mssql_odbc.php,v 1.24 2006/10/14 14:56:44 acydburn Exp $
File Size: 416 lines (9 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

dbal_mssql_odbc:: (15 methods):
  sql_connect()
  sql_server_info()
  _sql_transaction()
  sql_query()
  sql_query_limit()
  sql_affectedrows()
  sql_fetchrow()
  sql_rowseek()
  sql_nextid()
  sql_freeresult()
  sql_escape()
  _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)   X-Ref
Connect to server


sql_server_info()   X-Ref
Version information about used database


_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)   X-Ref
Fetch current row


sql_rowseek($rownum, $query_id = false)   X-Ref
Seek to given row number
rownum is zero-based


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_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 Nov 22 00:35:05 2006 Cross-referenced by PHPXref 0.6