PHP air\config示例

示例#1

文件： mysqli.inc.php 项目： 4honor/air

<?php

/**
 *
 * @author wukezhan<*****@*****.**>
 * 2015-10-28 12:30
 *
 */
define('DB_NAME', 'air');
define('TABLE_NAME', 'test');
define('DB_CONF', 'mysql.config.' . DB_NAME);
define('R', AIR_R);
define('W', AIR_W);
air\config::set(['mysql' => ['config' => ['air' => ['auth' => [R => ['username' => 'root', 'password' => ''], W => ['username' => 'root', 'password' => '']], 'pool' => [R => [['host' => 'localhost', 'port' => 3306]], W => [['host' => 'localhost', 'port' => 3306]]]]]]]);
function create_database()
{
    $db = DB_NAME;
    $mysqli = air\mysql\keeper::factory(DB_CONF, W);
    $sql = "DROP DATABASE IF EXISTS `{$db}`";
    $mysqli->query($sql);
    $sql = "CREATE DATABASE `{$db}` DEFAULT CHARACTER SET `utf8`";
    $mysqli->query($sql);
    if ($mysqli->errno) {
        exit("create database {$db} error: " . $mysqli->error . "\n");
    }
    air\mysql\keeper::release($mysqli, DB_CONF, W);
}
function create_table()
{
    $db = DB_NAME;
    $table = TABLE_NAME;

示例#2

文件： mysqli.inc.php 项目： oamzn/air

<?php

/**
 *
 * @author wukezhan<*****@*****.**>
 * 2015-10-28 12:30
 *
 */
define('DB_NAME', 'air');
define('TABLE_NAME', 'test');
define('DB_CONF', 'mysql.config.' . DB_NAME);
define('R', AIR_R);
define('W', AIR_W);
air\config::set(['mysql' => ['config' => ['air' => ['auth' => [R => ['username' => 'core', 'password' => '222222'], W => ['username' => 'core', 'password' => '222222']], 'pool' => [R => [['host' => 'wdb.io', 'port' => 3306]], W => [['host' => 'wdb.io', 'port' => 3306]]]]]]]);
function create_database()
{
    $db = DB_NAME;
    $mysqli = air\mysql\keeper::factory(DB_CONF, W);
    $sql = "DROP DATABASE IF EXISTS `{$db}`";
    $mysqli->query($sql);
    $sql = "CREATE DATABASE `{$db}` DEFAULT CHARACTER SET `utf8`";
    $mysqli->query($sql);
    if ($mysqli->errno) {
        exit("create database {$db} error: " . $mysqli->error . "\n");
    }
    air\mysql\keeper::release($mysqli, DB_CONF, W);
}
function create_table()
{
    $db = DB_NAME;
    $table = TABLE_NAME;