Coroutine\MySQL\Statement->execute

MySQL服务器发送SQL预处理数据参数。execute必须与prepare配合使用,调用execute之前必须先调用prepare发起预处理请求。

execute方法可以重复调用。

function Coroutine\MySQL\Statement->execute(array $params, float $timeout = -1) : bool

需要2.0.11或更高版本

参数

返回值

示例

use Swoole\Coroutine as co;
co::create(function() {
    $db = new co\MySQL();
    $server = array(
        'host' => '127.0.0.1',
        'user' => 'root',
        'password' => 'root',
        'database' => 'test',
    );

    $ret1 = $db->connect($server);
    $stmt = $db->prepare('SELECT * FROM userinfo WHERE id=? and name=?');
    if ($stmt == false)
    {
		var_dump($db->errno, $db->error);
    }
	else
	{
		$ret2 = $stmt->execute(array(10, 'rango'));
    	var_dump($ret2);
		
		$ret3 = $stmt->execute(array(13, 'alvin'));
    	var_dump($ret3);
	}
});