[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

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

(no description)

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

Defines 2 classes

result_mssqlnative:: (10 methods):
  result_mssqlnative()
  array_to_obj()
  fetch()
  get()
  num_rows()
  seek()
  num_fields()
  field_name()
  field_type()
  free()

dbal_mssqlnative:: (19 methods):
  sql_connect()
  sql_server_info()
  sql_buffer_nested_transactions()
  _sql_transaction()
  sql_query()
  _sql_query_limit()
  sql_affectedrows()
  sql_fetchrow()
  sql_nextid()
  sql_freeresult()
  sql_escape()
  sql_lower_text()
  _sql_like_expression()
  _sql_error()
  _sql_custom_build()
  _sql_close()
  _sql_report()
  mssqlnative_num_rows()
  mssqlnative_set_query_options()


Class: result_mssqlnative  - X-Ref

Prior to version 1.1 the SQL Server Native PHP driver didn't support sqlsrv_num_rows, or cursor based seeking so we recall all rows into an array
and maintain our own cursor index into that array.

result_mssqlnative($queryresult = false)   X-Ref
No description

array_to_obj($array, &$obj)   X-Ref
No description

fetch($mode = SQLSRV_FETCH_BOTH, $object_class = 'stdClass')   X-Ref
No description

get($pos, $fld)   X-Ref
No description

num_rows()   X-Ref
No description

seek($iRow)   X-Ref
No description

num_fields()   X-Ref
No description

field_name($nr)   X-Ref
No description

field_type($nr)   X-Ref
No description

free()   X-Ref
No description

Class: dbal_mssqlnative  - X-Ref


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_buffer_nested_transactions()   X-Ref
{@inheritDoc}


_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_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_error()   X-Ref
return sql error array


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


_sql_close()   X-Ref
Close sql connection


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


mssqlnative_num_rows($res)   X-Ref
Utility method used to retrieve number of rows
Emulates mysql_num_rows
Used in acp_database.php -> write_data_mssqlnative()
Requires a static or keyset cursor to be definde via
mssqlnative_set_query_options()


mssqlnative_set_query_options($options)   X-Ref
Allows setting mssqlnative specific query options passed to sqlsrv_query as 4th parameter.




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