alonity/database

Alonity database builder

dev-main 2022-08-09 00:41 UTC

Requires

• php: ^7.2

MIT

• Qexy

• database
• mysql
• sqlite
• postgresql
• builder
• CUBRID
• alonity

README

Alonity database query builder

Install

composer require alonity/database

Examples

use alonity\database\DB;

require('vendor/autoload.php');

// Add mysql connection settings
DB::connection('127.0.0.1', 'root', '', 'database');

// Add postgresql connection settings
DB::connection('127.0.0.1', 'postgres', 'postgres', 'database', 5432, 'utf8', 'PostgreSQL', 'pgskey'); // pgskey - connection name (key)

$select = DB::select("SELECT * FROM `mytable`");

if(!$select->execute()){
    echo $select->getError(); exit;
}

var_dump($select->assoc());

Supported drivers

• MySQL
• Cubrid
• PostgreSQL
• SQLite