Property | Type | Description | |
---|---|---|---|
$attributes | array | PDO connection flags | |
$connect | array | PDO connection settings | |
$handler | PDO instance |
Method | Description | |
---|---|---|
connect ( ) : |
Connect to Db | |
delete ( string $table ) : Bluz\Db\Query\Delete | Create new query update builder | |
disconnect ( ) : void | Disconnect PDO and clean default adapter | |
fetchAll ( string $sql, array $params = [] ) : array[] | Returns an array containing all of the result set rows | |
fetchColumn ( string $sql, array $params = [] ) : array | Returns an array containing one column from the result set rows | |
fetchColumnGroup ( string $sql, array $params = [] ) : array | Returns an array containing all of the result set rows | |
fetchGroup ( string $sql, array $params = [], mixed $object = null ) : array | Returns an array containing all of the result set rows | |
fetchObject ( string $sql, array $params = [], mixed $object = 'stdClass' ) : array | Returns an object containing first row from the result set | |
fetchObjects ( string $sql, array $params = [], mixed $object = null ) : array | Returns an array of objects containing the result set | |
fetchOne ( string $sql, array $params = [] ) : string | Return first field from first element from the result set | |
fetchPairs ( string $sql, array $params = [] ) : array | Returns a key-value array | |
fetchRelations ( string $sql, array $params = [] ) : array | Returns an array of linked objects containing the result set | |
fetchRow ( string $sql, array $params = [] ) : array | Returns an array containing first row from the result set | |
handler ( ) : PDO | Return PDO handler | |
insert ( string $table ) : |
Create new query insert builder | |
query ( string $sql, array $params = [], array $types = [] ) : integer | Execute SQL query | |
quote ( string $value ) : string | Quotes a string for use in a query | |
quoteIdentifier ( string $identifier ) : string | Quote a string so it can be safely used as a table or column name | |
select ( $select ) : |
Create new query select builder | |
setAttributes ( array $attributes ) : |
Setup attributes for PDO connect | |
setConnect ( array $connect ) : |
Setup connection | |
transaction ( callable $process ) : boolean | Transaction wrapper | |
update ( string $table ) : Bluz\Db\Query\Update | Create new query update builder |
Method | Description | |
---|---|---|
log ( string $sql, array $context = [] ) : void | Log queries by Application | |
ok ( ) : void | Setup timer | |
prepare ( string $sql, array $params ) : PDOStatement | Prepare SQL query and return PDO Statement |
Method | Description | |
---|---|---|
checkConnect ( ) : void | Check connection options |
public disconnect ( ) : void | ||
return | void |
$db->fetchAll("SELECT * FROM users WHERE ip = ?", ['192.168.1.1']);
$db->fetchGroup("SELECT ip, COUNT(id) FROM users GROUP BY ip", []);
Fetch object to stdClass
$stdClass = $db->fetchObject('SELECT * FROM some_table WHERE id = ?', [$id]);
Fetch object to new Some object
$someClass = $db->fetchObject('SELECT * FROM some_table WHERE id = ?', [$id], 'Some');
Fetch object to exists instance of Some object
$someClass = $db->fetchObject('SELECT * FROM some_table WHERE id = ?', [$id], $someClass);
public fetchObject ( string $sql, array $params = [], mixed $object = 'stdClass' ) : array | ||
$sql | string | SQL query with placeholders "SELECT * FROM users WHERE name = :name AND pass = :pass" |
$params | array | params for query placeholders (optional) array (':name' => 'John', ':pass' => '123456') |
$object | mixed | |
return | array |
public fetchObjects ( string $sql, array $params = [], mixed $object = null ) : array | ||
$sql | string | SQL query with placeholders "SELECT * FROM users WHERE name = :name AND pass = :pass" |
$params | array | params for query placeholders (optional) array (':name' => 'John', ':pass' => '123456') |
$object | mixed | Class name or instance |
return | array |
$db->fetchOne("SELECT COUNT(*) FROM users");
public fetchRelations ( string $sql, array $params = [] ) : array | ||
$sql | string | SQL query with placeholders "SELECT '__users', u.*, '__users_profile', up.* FROM users u LEFT JOIN users_profile up ON up.userId = u.id WHERE u.name = :name" |
$params | array | params for query placeholders (optional) array (':name' => 'John') |
return | array |
$db->fetchRow("SELECT name, email FROM users WHERE id = ". $db->quote($id));
$db->fetchRow("SELECT name, email FROM users WHERE id = ?", [$id]);
$db->fetchRow("SELECT name, email FROM users WHERE id = :id", [':id'=>$id]);
public fetchRow ( string $sql, array $params = [] ) : array | ||
$sql | string | SQL query with placeholders "SELECT * FROM users WHERE name = :name AND pass = :pass" |
$params | array | params for query placeholders (optional) array (':name' => 'John', ':pass' => '123456') |
return | array | array ('name' => 'John', 'email' => '[email protected]') |
$db->query("SET NAMES 'utf8'");
public query ( string $sql, array $params = [], array $types = [] ) : integer | ||
$sql | string | SQL query with placeholders "UPDATE users SET name = :name WHERE id = :id" |
$params | array | params for query placeholders (optional) array (':name' => 'John', ':id' => '123') |
$types | array | Types of params (optional) array (':name' => \PDO::PARAM_STR, ':id' => \PDO::PARAM_INT) |
return | integer | the number of rows |
$db->quote($_GET['id'])
public quoteIdentifier ( string $identifier ) : string | ||
$identifier | string | |
return | string |
public select ( $select ) : |
||
$select | The selection expressions | |
return |
public setAttributes ( array $attributes ) : |
||
$attributes | array | |
return |
$db->setConnect([
'type' => 'mysql',
'host' => 'localhost',
'name' => 'db name',
'user' => 'root',
'pass' => ''
]);
public setConnect ( array $connect ) : |
||
$connect | array | options |
return |
$db->transaction(function() use ($db) {
$db->query("INSERT INTO table ...");
$db->query("UPDATE table ...");
$db->query("DELETE FROM table ...");
})
public transaction ( callable $process ) : boolean | ||
$process | callable | callable structure - closure function or class with __invoke() method |
return | boolean |