Home >PHP Framework >Swoole >How to connect swoole to the database
Connect to the MySQL server asynchronously.
function swoole_mysql->connect(array $serverConfig, callable $callback);
$serverConfig is the configuration of the MySQL server and must be an associated index array
$callback Calls back this function after the connection is completed
swoole connects to the database instance:
<?php
//实例化资源
$db = new swoole_mysql();
$config = [
'host'=>'localhost',
'user'=>'root',
'password'=>'root',
'database'=>'amsdata',
'charset'=>'utf8'
];
//连接数据库
$db->connect($config,function($db,$r){
//mysql操作
if($r === false){
var_dump($db->connect_errno,$db->connect_error);
die("连接数据库失败");
}
$sql = 'show tables';
$db->query($sql,function(swoole_mysql $db,$r){
if($r === false){
var_dump($db->error);
die("操作失败");
}
var_dump($r[0]); //若有操作成功打印取出数据的第一个数组元素
$db->close();
});
});
Recommended learning: swoole tutorial
The above is the detailed content of How to connect swoole to the database. For more information, please follow other related articles on the PHP Chinese website!