MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]

Class: MDB2_Driver_querysim

Source Location: /MDB2-2.0.0beta2/MDB2/Driver/querysim.php

Class Overview

PEAR
   |
   --MDB2_Driver_Common
      |
      --MDB2_Driver_querysim

MDB2 QuerySim driver


Author(s):

Variables

Methods


Inherited Variables

Inherited Methods

Class: MDB2_Driver_Common

MDB2_Driver_Common::MDB2_Driver_Common()
Constructor
MDB2_Driver_Common::affectedRows()
returns the affected rows of a query
MDB2_Driver_Common::autoCommit()
Define whether database changes done on the database be automatically committed. This function may also implicitly start or end a transaction.
MDB2_Driver_Common::commit()
Commit the database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.
MDB2_Driver_Common::currID()
returns the current id of a sequence
MDB2_Driver_Common::debug()
set a debug message
MDB2_Driver_Common::debugOutput()
output debug info
MDB2_Driver_Common::disconnect()
Log out and disconnect from the database.
MDB2_Driver_Common::errorInfo()
This method is used to collect information about an error
MDB2_Driver_Common::errorNative()
returns an errormessage, provides by the database
MDB2_Driver_Common::escape()
Quotes a string so it can be safely used in a query. It will quote the text so it can safely be used within a query.
MDB2_Driver_Common::execute()
Execute a prepared query statement.
MDB2_Driver_Common::executeMultiple()
This function does several executeParams() calls on the same statement handle.
MDB2_Driver_Common::executeParams()
Executes a prepared SQL query
MDB2_Driver_Common::freePrepared()
Release resources allocated for the specified prepared query.
MDB2_Driver_Common::getDeclaration()
Obtain DBMS specific SQL code portion needed to declare of the given type
MDB2_Driver_Common::getDSN()
return the DSN as a string
MDB2_Driver_Common::getOption()
returns the value of an option
MDB2_Driver_Common::getSequenceName()
adds sequence name formating to a sequence name
MDB2_Driver_Common::getWarnings()
get all warnings in reverse order.
MDB2_Driver_Common::loadModule()
loads a module
MDB2_Driver_Common::nextID()
returns the next free id of a sequence
MDB2_Driver_Common::prepare()
Prepares a query for multiple execution with execute().
MDB2_Driver_Common::query()
Send a query to the database and return any results
MDB2_Driver_Common::queryAll()
Execute the specified query, fetch all the rows of the result set into a two dimensional array and then frees the result set.
MDB2_Driver_Common::queryCol()
Execute the specified query, fetch the value from the first column of each row of the result set into an array and then frees the result set.
MDB2_Driver_Common::queryOne()
Execute the specified query, fetch the value from the first column of the first row of the result set and then frees the result set.
MDB2_Driver_Common::queryRow()
Execute the specified query, fetch the values from the first row of the result set into an array and then frees the result set.
MDB2_Driver_Common::quote()
Convert a text value into a DBMS specific format that is suitable to compose query statements.
MDB2_Driver_Common::quoteIdentifier()
Quote a string so it can be safely used as a table or column name
MDB2_Driver_Common::raiseError()
This method is used to communicate an error and invoke error callbacks etc. Basically a wrapper for PEAR::raiseError without the message string.
MDB2_Driver_Common::replace()
Execute a SQL REPLACE query. A REPLACE query is identical to a INSERT query, except that if there is already a row in the table with the same key field values, the REPLACE query just updates its values instead of inserting a new row.
MDB2_Driver_Common::resetWarnings()
reset the warning array
MDB2_Driver_Common::rollback()
Cancel any database changes done during a transaction that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.
MDB2_Driver_Common::setDatabase()
Select a different database
MDB2_Driver_Common::setDSN()
set the DSN
MDB2_Driver_Common::setFetchMode()
Sets which fetch mode should be used by default on queries on this connection.
MDB2_Driver_Common::setLimit()
set the range of the next query
MDB2_Driver_Common::setOption()
set the option for the db class
MDB2_Driver_Common::setParam()
Set the value of a parameter of a prepared query.
MDB2_Driver_Common::setParamArray()
Set the values of multiple a parameter of a prepared query in bulk.
MDB2_Driver_Common::standaloneQuery()
execute a query as database administrator
MDB2_Driver_Common::subSelect()
simple subselect emulation: leaves the query untouched for all RDBMS that support subselects
MDB2_Driver_Common::supports()
Tell whether a DB implementation or its backend extension supports a given feature.
MDB2_Driver_Common::__toString()
String conversation

Class Details

[line 216]
MDB2 QuerySim driver


[ Top ]


Class Variables

$escape_quotes =  "\\"

[line 219]


Type:   mixed


[ Top ]



Method Detail

MDB2_Driver_querysim (Constructor)   [line 227]

MDB2_Driver_querysim MDB2_Driver_querysim( )

Constructor

[ Top ]

connect   [line 261]

mixed connect( )

Open a file or simulate a successful database connect
  • Return: MDB2_OK string on success, a MDB2 error object on failure
  • Access: public

[ Top ]

query   [line 347]

mixed &query( string $query, [mixed $types = null], [mixed $result_class = false], [mixed $result_wrap_class = false])

Get QuerySim text from appropriate source and return the parsed text.
  • Return: Simulated result set as a multidimentional array if valid QuerySim text was passed in. A MDB2 error is returned on failure.
  • Access: public

Overrides MDB2_Driver_Common::query() (Send a query to the database and return any results)

Parameters:

mixed   $types   —  array that contains the types of the columns in the result set
mixed   $result_class   —  string which specifies which result class to use
mixed   $result_wrap_class   —  string which specifies which class to wrap results in
string   $query   —  The QuerySim text

[ Top ]

_close   [line 311]

bool _close( )

Close a file or simulate a successful database disconnect
  • Return: true on success, false if file closed. Always true if simulated.
  • Access: public

[ Top ]


Documentation generated on Mon, 11 Mar 2019 10:15:54 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.