AsyncMysqlRowBlock::getRow
Get a certain row in the current row block
public function getRow(
int $row,
): AsyncMysqlRow;
Parameters
int $row
- the row index.
Returns
AsyncMysqlRow
- TheAsyncMysqlRow
representing one specific row in the current row block.
Examples
The following example shows you how to get a row from a row block via AsyncMysqlRowBlock::getRow
. You pass an int
specifying the row of the row block you want.
require __DIR__.'/../../__includes/async_mysql_connect.inc.php';
use \Hack\UserDocumentation\API\Examples\AsyncMysql\ConnectionInfo as CI;
async function connect(
\AsyncMysqlConnectionPool $pool,
): Awaitable<\AsyncMysqlConnection> {
return await $pool->connect(
CI::$host,
CI::$port,
CI::$db,
CI::$user,
CI::$passwd,
);
}
async function simple_query(): Awaitable<string> {
$pool = new \AsyncMysqlConnectionPool(darray[]);
$conn = await connect($pool);
$result = await $conn->query('SELECT * FROM test_table WHERE userID < 50');
$conn->close();
// A call to $result->rowBlocks() actually pops the first element of the
// row block Vector. So the call actually mutates the Vector.
$row_blocks = $result->rowBlocks();
if ($row_blocks->count() > 0) {
// An AsyncMysqlRowBlock
$row_block = $row_blocks[0];
// The next two lines are similar to $row_block->getFieldAsString(0, 'name')
$row = $row_block->getRow(0); // An AsyncMysqlRow
return $row->getFieldAsString('name'); // string
} else {
return "nothing";
}
}
function run(): void {
$r = \HH\Asio\join(simple_query());
\var_dump($r);
}
run();
string(11) "Joel Marcey"