Overview

Packages

  • Db
    • Adapter
    • Migration

Classes

  • Horde_Db_Adapter_Base
  • Horde_Db_Adapter_Base_Column
  • Horde_Db_Adapter_Base_ColumnDefinition
  • Horde_Db_Adapter_Base_Index
  • Horde_Db_Adapter_Base_Schema
  • Horde_Db_Adapter_Base_Table
  • Horde_Db_Adapter_Base_TableDefinition
  • Horde_Db_Adapter_Mysql
  • Horde_Db_Adapter_Mysql_Column
  • Horde_Db_Adapter_Mysql_Result
  • Horde_Db_Adapter_Mysql_Schema
  • Horde_Db_Adapter_Mysqli
  • Horde_Db_Adapter_Mysqli_Result
  • Horde_Db_Adapter_Pdo_Base
  • Horde_Db_Adapter_Pdo_Mysql
  • Horde_Db_Adapter_Pdo_Pgsql
  • Horde_Db_Adapter_Pdo_Sqlite
  • Horde_Db_Adapter_Postgresql_Column
  • Horde_Db_Adapter_Postgresql_Schema
  • Horde_Db_Adapter_SplitRead
  • Horde_Db_Adapter_Sqlite_Column
  • Horde_Db_Adapter_Sqlite_Schema

Interfaces

  • Horde_Db_Adapter
  • Overview
  • Package
  • Class
  • Tree

Class Horde_Db_Adapter_Pdo_Base

Horde_Db_Adapter_Base implements Horde_Db_Adapter
Extended by Horde_Db_Adapter_Pdo_Base

Direct known subclasses

Horde_Db_Adapter_Pdo_Mysql, Horde_Db_Adapter_Pdo_Pgsql, Horde_Db_Adapter_Pdo_Sqlite
Abstract
Package: Db\Adapter
Category: Horde
License: http://www.horde.org/licenses/bsd
Author: Mike Naberezny mike@maintainable.com
Author: Derek DeVries derek@maintainable.com
Author: Chuck Hagenbuch chuck@horde.org
Located at Horde/Db/Adapter/Pdo/Base.php
Methods summary
public
# connect( )

Connect to the db

Connect to the db
public boolean
# isActive( )

Check if the connection is active

Check if the connection is active

Returns

boolean

Overrides

Horde_Db_Adapter_Base::isActive()
public array
# selectAll( string $sql, mixed $arg1 = null, string $arg2 = null )

Returns an array of record hashes with the column names as keys and column values as values.

Returns an array of record hashes with the column names as keys and column values as values.

Parameters

$sql
$arg1
Either an array of bound parameters or a query name.
$arg2
If $arg1 contains bound parameters, the query name.

Returns

array

Throws

Horde_Db_Exception

Overrides

Horde_Db_Adapter_Base::selectAll()
public array|boolean
# selectOne( string $sql, mixed $arg1 = null, string $arg2 = null )

Returns a record hash with the column names as keys and column values as values.

Returns a record hash with the column names as keys and column values as values.

Parameters

$sql
A query.
$arg1
Either an array of bound parameters or a query name.
$arg2
If $arg1 contains bound parameters, the query name.

Returns

array|boolean
A record hash or false if no record found.

Throws

Horde_Db_Exception

Overrides

Horde_Db_Adapter_Base::selectOne()
public string
# selectValue( string $sql, mixed $arg1 = null, string $arg2 = null )

Returns a single value from a record

Returns a single value from a record

Parameters

$sql
$arg1
Either an array of bound parameters or a query name.
$arg2
If $arg1 contains bound parameters, the query name.

Returns

string

Throws

Horde_Db_Exception

Overrides

Horde_Db_Adapter_Base::selectValue()
public array
# selectValues( string $sql, mixed $arg1 = null, string $arg2 = null )

Returns an array of the values of the first column in a select: selectValues("SELECT id FROM companies LIMIT 3") => [1,2,3]

Returns an array of the values of the first column in a select: selectValues("SELECT id FROM companies LIMIT 3") => [1,2,3]

Parameters

$sql
$arg1
Either an array of bound parameters or a query name.
$arg2
If $arg1 contains bound parameters, the query name.

Returns

array

Throws

Horde_Db_Exception

Overrides

Horde_Db_Adapter_Base::selectValues()
public array
# selectAssoc( string $sql, mixed $arg1 = null, string $arg2 = null )

Returns an array where the keys are the first column of a select, and the values are the second column:

Returns an array where the keys are the first column of a select, and the values are the second column:

selectAssoc("SELECT id, name FROM companies LIMIT 3") => [1 => 'Ford', 2 => 'GM', 3 => 'Chrysler']

Parameters

$sql
$arg1
Either an array of bound parameters or a query name.
$arg2
If $arg1 contains bound parameters, the query name.

Returns

array

Throws

Horde_Db_Exception

Overrides

Horde_Db_Adapter_Base::selectAssoc()
public string
# quoteString( string $string )

Quotes a string, escaping any ' (single quote) and \ (backslash) characters..

Quotes a string, escaping any ' (single quote) and \ (backslash) characters..

Parameters

$string

Returns

string
Methods inherited from Horde_Db_Adapter_Base
__call(), __construct(), __destruct(), __sleep(), __wakeup(), adapterName(), addLimitOffset(), addLock(), beginDbTransaction(), commitDbTransaction(), delete(), disconnect(), emptyInsertStatement(), execute(), getCache(), getLastQuery(), getLogger(), getOption(), insert(), insertFixture(), prefetchPrimaryKey(), rawConnection(), reconnect(), resetRuntime(), rollbackDbTransaction(), sanitizeLimit(), select(), setCache(), setLogger(), supportsCountDistinct(), supportsMigrations(), transactionStarted(), update()
API documentation generated by ApiGen