text.skip-to-content

Database

The pyncer/database package provides a standard interface for working with databases.

Installation

Install via Composer:

$ composer require pyncer/database

Example

use Pyncer\Database\Driver;

// Configure the database driver and get a connection.
$connection = (new Driver(
    'MySql',
    'localhost'
    'database'
    'username'
    'password'
    'prefix_' // Optional table prefix
))->getConnection();

// Select all admins from the users table
// except for admin@example.com.
$result = $connection->select('users')
    ->columns('id', 'name', 'email')
    ->where([
        'group' => 'admin',
        '!email' => 'admin@example.com'
    ])
    ->result();

foreach ($result as $row) {
    echo $row['id'] . "\n";
    echo $row['name'] . "\n";
    echo $row['email'] . "\n";
}