The LibSQLTransaction class represents a database transaction in the LibSQL PHP extension. It allows for executing SQL statements within a transaction context, handling commits, rollbacks, and managing transactional behavior.

​
Constructor

The libSQL Transaction will construct when you using $db->transaction().

​
Methods

​
changes

Retrieves the number of rows changed by the last SQL statement.

​
Returns

  • (int) : The number of rows changed.

​
Example

$tx = $db->transaction();
$tx->execute("UPDATE users SET name = 'Glauber Costa' WHERE id = 6");
echo $tx->changes() . PHP_EOL;

​
isAutocommit

Checks if the transaction is set to autocommit.

​
Returns

  • (bool) : if autocommit is enabled return true, otherwise false.

​
Example

$tx = $db->transaction();
var_dump($tx->isAutocommit());

​
execute

Executes an SQL statement within the transaction.

​
Parameters

  • string $stmt: The SQL statement to execute.
  • array $parameters: The parameters for the statement (optional).

​
Returns

  • (int) : The number of affected rows.

​
Example

$tx = $db->transaction();
$tx->execute("UPDATE users SET name = 'Glauber Costa' WHERE id = 6");

​
query

Executes a query within the transaction and returns the result set.

​
Parameters

  • string $stmt: The SQL statement to execute.
  • array $parameters: The parameters for the statement (optional).

​
Returns

  • (LibSQLResult): The result set of the query.

​
Example

$tx = $db->transaction();
$tx->query("SELECT name, email FROM users")->fetchArray(LibSQL::LIBSQL_ASSOC);

​
commit

Commits the transaction.

​
Returns

  • (void)

​
Example

$tx = $db->transaction();
$tx->execute("UPDATE users SET name = 'Glauber Costa' WHERE id = 6");
$tx->commit();

​
rollback

Rolls back the transaction.

​
Returns

  • (void)

​
Example

$tx = $db->transaction();
$tx->execute("UPDATE users SET name = 'Glauber Costa' WHERE id = 6");
$tx->rollback();

​
Usage Example

<?php

// Create a new LibSQL instance
$db = new LibSQL("libsql:dbname=database.db");

// Start a new transaction with default behavior
$transaction = $db->transaction();

$transaction->execute("UPDATE users SET name = 'Glauber Costa' WHERE id = 6");

$another_transaction = true;

if ($another_transaction) {
    $transaction->commit();
    echo "Transaction commited!" . PHP_EOL;
} else {
    $transaction->rollback();
    echo "Transaction rollback!" . PHP_EOL;
}

$db->close();