alonity/database

Alonity 数据库构建器

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

This package is auto-updated.

Last update: 2024-09-09 05:25:24 UTC


README

Alonity 数据库查询构建器

安装

composer require alonity/database

示例

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());

支持的驱动程序

  • MySQL
  • Cubrid
  • PostgreSQL
  • SQLite