$_config
$_config : array
Config options.
MySQL Improved Horde_Db_Adapter
$_schema : \Horde_Db_Adapter_Base_Schema
Schema object.
prefetchPrimaryKey( $tableName = null) : boolean
Should primary key values be selected from their corresponding sequence before the insert statement? If true, next_sequence_value is called before each insert to set the record's primary key.
This is false for all adapters but Firebird.
| $tableName |
selectAll(string $sql, mixed $arg1 = null, string $arg2 = null) : array
Returns an array of record hashes with the column names as keys and column values as values.
| string | $sql | SQL statement. |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
selectOne(string $sql, mixed $arg1 = null, string $arg2 = null) : array|boolean
Returns a record hash with the column names as keys and column values as values.
| string | $sql | A query. |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
A record hash or false if no record found.
selectValue(string $sql, mixed $arg1 = null, string $arg2 = null) : string
Returns a single value from a record
| string | $sql | SQL statement. |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
selectValues(string $sql, mixed $arg1 = null, string $arg2 = null) : array
Returns an array of the values of the first column in a select: select_values("SELECT id FROM companies LIMIT 3") => [1,2,3]
| string | $sql | SQL statement. |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
selectAssoc(string $sql, mixed $arg1 = null, string $arg2 = null) : array
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']
| string | $sql | SQL statement. |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
insertBlob(string $table, array $fields, string $pk = null, mixed $idValue = null) : integer
Inserts a row including BLOBs into a table.
| string | $table | The table name. |
| array | $fields | A hash of column names and values. BLOB/CLOB columns must be provided as Horde_Db_Value objects. |
| string | $pk | The primary key column. |
| mixed | $idValue | The primary key value. This parameter is required if the primary key is inserted manually. |
Last inserted ID.
update(string $sql, mixed $arg1 = null, string $arg2 = null) : integer
Executes the update statement and returns the number of rows affected.
| string | $sql | SQL statement. |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
Number of rows affected.
updateBlob(string $table, array $fields, string|array $where = null)
Updates rows including BLOBs into a table.
| string | $table | The table name. |
| array | $fields | A hash of column names and values. BLOB/CLOB columns must be provided as Horde_Db_Value objects. |
| string|array | $where | A WHERE clause. Either a complete clause or an array containing a clause with placeholders and a list of values. |
delete(string $sql, mixed $arg1 = null, string $arg2 = null) : integer
Executes the delete statement and returns the number of rows affected.
| string | $sql | SQL statement. |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
Number of rows affected.
addLock( $sql, array $options = array())
Appends a locking clause to an SQL statement.
This method modifies the +sql+ parameter.
add_lock! 'SELECT FROM suppliers', :lock => true add_lock! 'SELECT FROM suppliers', :lock => ' FOR UPDATE'
| $sql | ||
| array | $options | TODO. |
connect()
Connect to the db
MySQLi can connect using SSL if $config contains an 'ssl' sub-array containing the following keys:
Example of how to connect using SSL:
$config = array(
'username' => 'someuser',
'password' => 'apasswd',
'hostspec' => 'localhost',
'database' => 'thedb',
'ssl' => array(
'key' => 'client-key.pem',
'cert' => 'client-cert.pem',
'ca' => 'cacert.pem',
'capath' => '/path/to/ca/dir',
'cipher' => 'AES',
),
);
$db = new Horde_Db_Adapter_Mysqli($config);
select(string $sql, mixed $arg1 = null, string $arg2 = null) : \Horde_Db_Adapter_Mysqli_Result
Returns an array of records with the column names as keys, and column values as values.
| string | $sql | |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
execute(string $sql, mixed $arg1 = null, string $arg2 = null) : \mysqli_result
Executes the SQL statement in the context of this connection.
| string | $sql | SQL statement. |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
insert(string $sql, mixed $arg1 = null, string $arg2 = null, string $pk = null, integer $idValue = null, string $sequenceName = null)
Returns the last auto-generated ID from the affected table.
| string | $sql | |
| mixed | $arg1 | Either an array of bound parameters or a query name. |
| string | $arg2 | If $arg1 contains bound parameters, the query name. |
| string | $pk | |
| integer | $idValue | |
| string | $sequenceName |
_replaceParameters(string $sql, array $args, boolean $no_binary = false) : string
Replace ? in a SQL statement with quoted values from $args
| string | $sql | SQL statement. |
| array | $args | An array of values to bind. |
| boolean | $no_binary | If true, do not replace any Horde_Db_Value_Binary values. Used for logging purposes. |
Modified SQL statement.