webiik/database

The Database is PDO connection container.

Maintainers

Details

github.com/webiik/database

Homepage

Source

Installs: 63

Dependents: 1

Suggesters: 0

Security: 0

Stars: 0

Watchers: 2

Forks: 0

1.1 2020-07-08 12:56 UTC

Requires

  • php: >=7.2

MIT 7e4991338853beaa8c2515700fa6c8d16ce6323c

  • Jiri Mihal <jiri.woop@mihal.me>

databasepdoConnection

This package is auto-updated.

Last update: 2024-04-08 20:57:59 UTC

README

68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f6c2f77656269696b2f77656269696b2e737667 68747470733a2f2f696d672e736869656c64732e696f2f62616467652f646570656e64656e636965732d302d627269676874677265656e2e737667

Database

The Database is PDO connection container.

Installation

composer require webiik/database

Example

$db = new \Webiik\Database\Database();
$db->add('main', 'mysql', 'localhost', 'webiik', 'root', 'root');
$pdo = $db->connect();

Settings

add

add(string $name, string $driver, string $host, string $databaseName, string $user, string $password, array $options = [], array $commands = []): void

add() adds database connection credentials.

Parameters

  • name name of current database connection. You will be able to get this connection by this name.
  • driver pdo driver
  • host host name e.g. localhost
  • databaseName database name
  • user database user name
  • password database user password
  • options array of PDO options
  • commands associative array of MySQL commands with parameters to execute after connecting to database. E.g. ['SET CHARACTER SET ?' => 'utf8']
$db->add('main', 'mysql', 'localhost', 'webiik', 'root', 'root');

Connection

connect

connect(string $name = ''): \PDO

connect() connects to database and return PDO object. When name is omitted it connects to first added database.

$pdo = $db->connect();

disconnect

disconnect(string $name = ''): void

disconnect() disconnects from database. When name is omitted it disconnects from first added database.

$db->disconnect();

Resources