Skip to content

README.md

Latest commit

 

History

History
137 lines (102 loc) · 2.41 KB

README.md

File metadata and controls

137 lines (102 loc) · 2.41 KB

PDO Drivers Package

Package created to use pdo drivers together.

Supported Drivers

  • MySQL
  • PostgreSQL
  • SQLServer
  • SQLite

Requirements

  • PHP >= 8.0
  • ext-pdo

Bilgisayarınızda Çalıştırın

Projeyi klonlayın

  git clone https://github.com/atakansn/database-drivers.git

Proje dizinine gidin

  cd database-drivers

Gerekli paketleri yükleyin

  composer install

Usage/Examples

DB_CONNECTION=database-driver
DB_HOST=host
DB_PORT=port
DB_USERNAME=username
DB_PASSWORD=password
DB_DATABASE=database
require __DIR__ . '/vendor/autoload.php';

$manager = \DatabaseDrivers\Driver\ConnectionManager::run()

$manager->insert('test_table', [
    'name' => 'Foo'
]);

$manager->update('test_table',
    ['name' => 'Foo Bar'], // new value
    ['id'=> 2] // conditions
);

$manager->delete('test_table', [
    'id' => 3
]);

SQL Outputs

INSERT INTO test_table(name) VALUES('Foo')


UPDATE test_table SET name='Foo Bar' WHERE id=2


DELETE FROM test_table WHERE id=2

PDO Instance

$manager = \DatabaseDrivers\Driver\ConnectionManager::run();
$pdo = $manager->getPdo();
$stmt = $pdo->prepare('SELECT * FROM table_name');
$stmt->execute();

config/database.php Config File

Can configure PDO connection settings, disable.

'mysql' => [
    'driver' => 'mysql',
    'host' => env('DB_HOST'),
    'port' => env('DB_PORT',3306),
    'database' => env('DB_DATABASE'),
    'username' => env('DB_USERNAME'),
    'password' => env('DB_PASSWORD'),
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
],

'pgsql' => [
    'driver' => 'pgsql',
    'host' => env('DB_HOST'),
    'port' => env('DB_PORT',5432),
    'database' => env('DB_DATABASE'),
    'username' => env('DB_USERNAME'),
    'password' => env('DB_PASSWORD'),
    'charset' => 'utf8',
    'search_path' => 'public',
    //'ssl_mode' => 'prefer',
],

'sqlsrv' => [
    'driver' => 'sqlsrv',
    'host' => env('DB_HOST'),
    'port' => env('DB_PORT'),
    'database' => env('DB_DATABASE'),
    'username' => env('DB_USERNAME'),
    'password' => env('DB_PASSWORD'),
    'charset' => 'utf8',
],

'sqlite' => [
    'driver' => 'sqlite',
    'url' => env('DATABASE_URL'),
    'database' => database_path(env('DB_DATABASE')),
    'foreign_key_constraints' => env('DB_FOREIGN_KEYS')
]