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