Swoole\Coroutine\MySQL::recv()函式—用法及示例

函式名稱：Swoole\Coroutine\MySQL::recv()

函式描述：該函式用於接收MySQL Server的響應結果。

適用版本：Swoole-4.4.0 及以上版本

用法：

1. 建立Swoole\Coroutine\MySQL物件：

$mysql = new Swoole\Coroutine\MySQL();

2. 連線MySQL Server：

$serverInfo = [
    'host' => '127.0.0.1',
    'port' => 3306,
    'user' => 'root',
    'password' => 'password',
    'database' => 'test',
];
$connected = $mysql->connect($serverInfo);
if (!$connected) {
    echo "MySQL連線失敗：" . $mysql->connect_error . PHP_EOL;
    return;
}

3. 執行SQL查詢語句：

$sql = 'SELECT * FROM `users` WHERE `id` = 1';
$queryResult = $mysql->query($sql);
if ($queryResult === false) {
    echo "查詢失敗：" . $mysql->error . PHP_EOL;
    return;
}

4. 接收MySQL Server的響應結果：

$response = $mysql->recv();
if ($response === false) {
    echo "接收響應失敗：" . $mysql->error . PHP_EOL;
    return;
}

示例：

<?php
$mysql = new Swoole\Coroutine\MySQL();

$serverInfo = [
    'host' => '127.0.0.1',
    'port' => 3306,
    'user' => 'root',
    'password' => 'password',
    'database' => 'test',
];
$connected = $mysql->connect($serverInfo);
if (!$connected) {
    echo "MySQL連線失敗：" . $mysql->connect_error . PHP_EOL;
    return;
}

$sql = 'SELECT * FROM `users` WHERE `id` = 1';
$queryResult = $mysql->query($sql);
if ($queryResult === false) {
    echo "查詢失敗：" . $mysql->error . PHP_EOL;
    return;
}

$response = $mysql->recv();
if ($response === false) {
    echo "接收響應失敗：" . $mysql->error . PHP_EOL;
    return;
}

print_r($response);

以上示例展示瞭如何使用Swoole\Coroutine\MySQL::recv()函式來接收MySQL Server的響應結果。首先建立MySQL物件並連線到MySQL Server，然後執行SQL查詢語句，並最後透過recv()函式接收響應結果。如果成功接收到響應，則列印輸出結果。