The LibSQLResult class represents the result set of a LibSQL query. It provides methods for retrieving query results and metadata about the result set.

​
Methods

​
fetchArray

Fetches the result set as an array or an iterator.

​
Parameters

  • LibSQL::LIBSQL_BOTH (optional): The fetching mode. Defaults to LibSQL::LIBSQL_BOTH (both associative and numerical arrays).
    • LibSQL::LIBSQL_ASSOC: Return an associative array.
    • LibSQL::LIBSQL_NUM: Return a numerical array.
    • LibSQL::LIBSQL_BOTH: Return both associative and numerical arrays.
    • LibSQL::LIBSQL_ALL: Return all results.
    • LibSQL::LIBSQL_LAZY: Return a generator for lazy-loading results.

​
Returns

  • array|LibSQLIterator - The fetched result set

​
Example

$result = $db->query("SELECT * FROM users");
foreach ($result->fetchArray() as $row) {
    echo "ID: " . $row['id'] . ", Name: " . $row['name'] . "\n";
}

Read more detail about LibSQLIterator Class

​
finalize

Finalizes the result set and frees the associated resources.

​
Returns

  • (void)

​
Example

$result = $db->query("SELECT * FROM users");
$result->finalize();

​
reset

Resets the result set for re-execution. This can be used to iterate over the same results multiple times.

​
Returns

  • void

​
Example

$result = $db->query("SELECT * FROM users");
$result->reset();

​
columnName

Retrieves the name of a column by its index.

​
Parameters

  • int $column: The index of the column (zero-based).

​
Returns

A string containing the name of the specified column.

​
Example

$columnName = $result->columnName(0);
echo "First column name: " . $columnName;

​
columnType

Retrieves the type of a column by its index.

​
Parameters

  • int $column: The index of the column (zero-based).

​
Returns

A string containing the data type of the specified column.

​
Example

$columnType = $result->columnType(0);
echo "First column type: " . $columnType;

​
numColumns

Retrieves the number of columns in the result set.

​
Returns

An int representing the total number of columns in the result set.

​
Example

$numColumns = $result->numColumns();
echo "Number of columns: " . $numColumns;

​
Usage Example

$db = new LibSQL("libsql:dbname=database.db");

// Execute a query
$result = $db->query("SELECT id, name, age FROM users");

// Fetch and iterate through results
foreach ($result->fetchArray() as $row) {
    echo "ID: " . $row['id'] . ", Name: " . $row['name'] . ", Age: " . $row['age'] . "\n";
}

// Get metadata
echo "Number of columns: " . $result->numColumns() . "\n";
echo "First column name: " . $result->columnName(0) . "\n";
echo "First column type: " . $result->columnType(0) . "\n";

// Finalize the result set
$result->finalize();