limingxinleo/x-phalcon-db

Phalcon DB

1.0.1 2018-03-03 05:06 UTC

Requires

• php: >=5.6
• ext-phalcon: ^3.0

Requires (Dev)

• phalcon/dd: ^1.1
• phpunit/phpunit: >=5.6

Suggests

• php: >=7.0

MIT

• 李铭昕

README

安装

composer require limingxinleo/x-phalcon-db

使用

<?php
use Phalcon\DI\FactoryDefault;
use Phalcon\Db\Adapter\Pdo\Mysql;
use PDO;
use Xin\DB;

// Your Method To Get DI;
$di = new FactoryDefault();
$di->setShared('db', function () {
    return new Mysql(
        [
            'host' => '127.0.0.1',
            'username' => 'root',
            'password' => '910123',
            'dbname' => 'phalcon',
            'charset' => 'utf8',
            'options' => [
                PDO::ATTR_CASE => PDO::CASE_NATURAL,
                PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                PDO::ATTR_ORACLE_NULLS => PDO::NULL_NATURAL,
                PDO::ATTR_STRINGIFY_FETCHES => false,
                PDO::ATTR_EMULATE_PREPARES => false,
            ],
        ]
    );
});

$sql = "SELECT * FROM `test` WHERE `name` = ? LIMIT 1;";
$res = DB::query($sql, ['limx']);