PHPXRef 0.7.1 : Unnamed Project : Detail view of mysqli.php

(no description)

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

Defines 1 class

dbal_mysqli:: (19 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()
  get_estimated_row_count()
  get_row_count()
  get_table_status()
  _sql_like_expression()
  _sql_custom_build()
  _sql_error()
  _sql_close()
  _sql_report()

Class: dbal_mysqli - X-Ref

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

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 $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) X-Ref

Fetch current row

sql_rowseek($rownum, &$query_id) 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

get_estimated_row_count($table_name) X-Ref

Gets the estimated number of rows in a specified table.

param: string $table_name Table name
return: string Number of rows in $table_name.

get_row_count($table_name) X-Ref

Gets the exact number of rows in a specified table.

param: string $table_name Table name
return: string Exact number of rows in $table_name.

get_table_status($table_name) X-Ref

Gets some information about the specified table.

param: string $table_name Table name
return: array

_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

PHP Cross Reference of Unnamed Project

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

Defines 1 class