Class DB_msql

Description

Database independent query interface definition for PHP's Mini-SQL extension.

  • author: Sterling Hughes <sterling@php.net>
  • version: $Id: msql.php,v 1.24 2004/03/05 01:46:53 danielc Exp $

Located in /maintenance/libraries/pear/DB/msql.php (line 33)

PEAR
   |
   --DB_common
      |
      --DB_msql
Variable Summary
Method Summary
 DB_msql DB_msql ()
 number affectedRows ()
 void connect (mixed $dsninfo, [mixed $persistent = false])
 void disconnect ()
 mixed fetchInto (resource $result, array &$arr, int $fetchmode, [int $rownum = null])
 void freeResult (mixed $result)
 true nextResult (a $result)
 void numCols (mixed $result)
 void numRows (mixed $result)
 void simpleQuery (mixed $query)
Variables
mixed $connection (line 37)
mixed $dbsyntax (line 38)
mixed $phptype (line 38)

Redefinition of:
DB_common::$phptype
DB type (mysql, oci8, odbc etc.)
mixed $prepare_tokens = array() (line 39)

Redefinition of:
DB_common::$prepare_tokens
mixed $prepare_types = array() (line 40)

Redefinition of:
DB_common::$prepare_types

Inherited Variables

Inherited from DB_common

DB_common::$dbh
DB_common::$errorcode_map
DB_common::$features
DB_common::$fetchmode
DB_common::$fetchmode_object_class
DB_common::$last_query
DB_common::$options
DB_common::$prepared_queries
DB_common::$prepare_maxstmt
Methods
Constructor DB_msql (line 45)
DB_msql DB_msql ()
affectedRows (line 226)

Gets the number of rows affected by a query.

  • return: of rows affected by the last query
number affectedRows ()

Redefinition of:
DB_common::affectedRows()
Returns the affected rows of a query
connect (line 61)
void connect (mixed $dsninfo, [mixed $persistent = false])
disconnect (line 93)
void disconnect ()
fetchInto (line 155)

Fetch a row and insert the data into an existing array.

Formating of the array and the data therein are configurable. See DB_result::fetchInto() for more information.

  • return: DB_OK on success, null when end of result set is reached or on failure
  • access: private
  • see: DB_result::fetchInto()
mixed fetchInto (resource $result, array &$arr, int $fetchmode, [int $rownum = null])
  • resource $result: query result identifier
  • array $arr: (reference) array where data from the row should be placed
  • int $fetchmode: how the resulting array should be indexed
  • int $rownum: the row number to fetch
freeResult (line 189)
void freeResult (mixed $result)
nextResult (line 129)

Move the internal msql result pointer to the next available result

  • return: if a result is available otherwise return false
  • access: public
true nextResult (a $result)
  • a $result: valid fbsql result resource
numCols (line 197)
void numCols (mixed $result)
numRows (line 209)
void numRows (mixed $result)

Redefinition of:
DB_common::numRows()
Returns the number of rows in a result object
simpleQuery (line 103)
void simpleQuery (mixed $query)

Inherited Methods

Inherited From DB_common

 DB_common::DB_common()
 DB_common::affectedRows()
 DB_common::autoCommit()
 DB_common::autoExecute()
 DB_common::autoPrepare()
 DB_common::buildManipSQL()
 DB_common::commit()
 DB_common::createSequence()
 DB_common::dropSequence()
 DB_common::errorCode()
 DB_common::errorMessage()
 DB_common::errorNative()
 DB_common::escapeSimple()
 DB_common::execute()
 DB_common::executeEmulateQuery()
 DB_common::executeMultiple()
 DB_common::freePrepared()
 DB_common::getAll()
 DB_common::getAssoc()
 DB_common::getCol()
 DB_common::getListOf()
 DB_common::getOne()
 DB_common::getOption()
 DB_common::getRow()
 DB_common::getSequenceName()
 DB_common::getSpecialQuery()
 DB_common::getTables()
 DB_common::limitQuery()
 DB_common::modifyLimitQuery()
 DB_common::modifyQuery()
 DB_common::nextId()
 DB_common::numRows()
 DB_common::prepare()
 DB_common::provides()
 DB_common::query()
 DB_common::quote()
 DB_common::quoteIdentifier()
 DB_common::quoteSmart()
 DB_common::quoteString()
 DB_common::raiseError()
 DB_common::rollback()
 DB_common::setFetchMode()
 DB_common::setOption()
 DB_common::tableInfo()
 DB_common::toString()
 DB_common::_convertNullArrayValuesToEmpty()
 DB_common::_rtrimArrayValues()

Documentation generated on Thu, 20 Jan 2005 17:10:17 +0000 by phpDocumentor 1.3.0RC3