<?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;
<?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;