1<?php
2use Swoole\Coroutine as co;
3
4co::create(function() {
5
6    $db = new co\MySQL();
7    $server = array(
8        'host' => '127.0.0.1',
9        'user' => 'root',
10        'password' => 'root',
11        'database' => 'test',
12    );
13
14    echo "connect\n";
15    $ret1 = $db->connect($server);
16    var_dump($ret1);
17
18    echo "prepare [1]\n";
19    $stmt1 = $db->prepare('SELECT * FROM userinfo WHERE id=?');
20    var_dump($stmt1);
21    if ($stmt1 == false)
22    {
23        var_dump($db->errno, $db->error);
24    }
25
26    echo "execute\n";
27    $ret3 = $stmt1->execute(array(10));
28    var_dump(count($ret3));
29
30    echo "prepare [2]\n";
31    $stmt2 = $db->prepare('SELECT * FROM userinfo WHERE id > ? and level > ?');
32    var_dump($stmt2);
33    if ($stmt2 == false)
34    {
35        var_dump($db->errno, $db->error);
36    }
37
38    echo "execute\n";
39    $ret4 = $stmt2->execute(array(10, 99));
40    var_dump($ret4);
41});
42