test.php

<?php

if (!class_exists('LibSQL')) {
    echo "LibSQL Not Found!" . PHP_EOL;
    exit(1);
}

$db = new LibSQL(":memory:");

$db->cdc_url = "https://webhook.site/0a862816-1883-4dde-a776-46037747c304";

if (!$db) {
    throw new Exception("Database Not Connected!");
}

$version = $db->version();
echo $version . PHP_EOL;
$db->captureIt("event.type", "No Query", $version);

// $createUsers = <<<STMT
// CREATE TABLE IF NOT EXISTS users (
//     id INTEGER PRIMARY KEY AUTOINCREMENT,
//     name TEXT,
//     age INTEGER
// );
// INSERT INTO users (name, age) VALUES ('Bilal Ali Maftullah', 21);
// INSERT INTO users (name, age) VALUES ('Lisa Nur Amelia', 22);
// STMT;

// $db->executeBatch($createUsers);

// echo $db->totalChanges() . PHP_EOL;
// echo $db->lastInsertedId() . PHP_EOL;

// $users = $db->query("SELECT * FROM users")->fetchArray(LibSQL::LIBSQL_LAZY);

// do {

//     $user = $users->current();

//     echo "Age: {$user['age']}, Name: {$user['name']}\n";

//     $users->next();

// } while ($users->valid());

// $stmt = $db->prepare("SELECT * FROM users WHERE age = ?1");
// $stmt->bindPositional([21]);

// var_dump($stmt->query()->fetchArray(LibSQL::LIBSQL_ASSOC));

// $stmt = $db->prepare("DELETE FROM users WHERE age = :age");
// $stmt->bindNamed([':age' => 22]);

// var_dump($stmt->execute());

// $stmt = $db->prepare("SELECT * FROM users");
// $users = $stmt->query()->fetchArray(LibSQL::LIBSQL_LAZY);

// do {

//     $user = $users->current();

//     echo "Age: {$user['age']}, Name: {$user['name']}\n";

//     $users->next();

// } while ($users->valid());

// $db->close();