Slide 30
Slide 30 text
30/39
Ref: https://wiki.swoole.com/wiki/page/517.html
Async MySQL Client
$db = new swoole_mysql;
$server = array(
'host' => '192.168.1.1',
'port' => 3306,
'user' => 'test',
'password' => 'test',
'database' => 'test',
'charset' => 'utf8',
);
$db->connect($server, function ($db, $r) {
if ($r === false) {
var_dump($db->connect_errno, $db->connect_error);
die;
}
$db->query('show tables', function(swoole_mysql $db, $r) {
if ($r === false)
{
var_dump($db->error, $db->errno);
}
elseif ($r === true )
{
var_dump($db->affected_rows, $db->insert_id);
}
var_dump($r);
$db->close();
});
});