Database
修改 apps/configs/db.php ,加入配置。
~~~
$db['master'] = array(
'type' => Swoole\Database::TYPE_MYSQLi,
'host' => "127.0.0.1",
'port' => 3306,
'dbms' => 'mysql',
'engine' => 'MyISAM',
'user' => "root",
'passwd' => "root",
'name' => "db_live",
'charset' => "utf8",
'setname' => true,
'persistent' => true,
);
return $db;
~~~
使用方式
單數據庫,默認讀取master配置
$this->db->query("select * from test");
多數據庫,讀取制定的數據庫配置
~~~
$db['master'] = array(
'type' => Swoole\Database::TYPE_MYSQLi,
'host' => "127.0.0.1",
'port' => 3306,
'dbms' => 'mysql',
'engine' => 'MyISAM',
'user' => "root",
'passwd' => "root",
'name' => "swoole",
'charset' => "utf8",
'setname' => true,
'persistent' => false, //MySQL長連接
'use_proxy' => false, //啟動讀寫分離Proxy
'slaves' => array(
array('host' => '127.0.0.1', 'port' => '3307', 'weight' => 100,),
array('host' => '127.0.0.1', 'port' => '3308', 'weight' => 99,),
array('host' => '127.0.0.1', 'port' => '3309', 'weight' => 98,),
),
);
$db['slave'] = array(
'type' => Swoole\Database::TYPE_MYSQLi,
'host' => "127.0.0.1",
'port' => 3306,
'dbms' => 'mysql',
'engine' => 'MyISAM',
'user' => "root",
'passwd' => "root",
'name' => "swoole",
'charset' => "utf8",
'setname' => true,
'persistent' => false, //MySQL長連接
);
$this->db('other_db_config')->query("select * from test");
~~~
驅動類型
swoole框架支持3種驅動類型:
Swoole\Database::TYPE_MYSQL,使用mysql擴展
Swoole\Database::TYPE_MYSQLi,使用mysqli擴展
Swoole\Database::TYPE_PDO,使用PDO擴展
配置選項
charset 制定數據庫字符集
setname 在連接服務器成功后發送set names $charset
persistent 啟用MySQL數據庫長連接