Join 4,000+ others and never miss out on new tips, tutorials, and more.
4.x is outdated, please check the latest version 22.x
Latest version:
pecl install openswoole-22.1.2
<?php Swoole\Coroutine\PostgreSQL->fetchRow(resource $queryResult, int $row, $resultType = SW_PGSQL_NUM): array|false
The result of a executed SQL query which will be a PHP resource variable type.
The number of the row you want to extract.
How you want the array to be returned, check types below.
Returns an array of a single row from the data results.
Extract a single row as a enumerated array, one row at a time.
The array index starts from 0. If there is no more results false is returned.
Return Types
<?php
use Swoole\Coroutine\PostgreSQL;
Co\run(function()
{
$pg = new PostgreSQL();
$conn = $pg->connect("host=127.0.0.1;port=5432;dbname=test;user=postgres;password=***");
$result = $pg->query('SELECT * FROM test;');
while($row = $pg->fetchRow($result))
{
echo "name: $row[0] mobile: $row[1]" . PHP_EOL;
}
});