Local databases connection using the LibSQL PHP Extension, there are several straightforward options available. Let’s explore each option in detail:

​
Standard DSN Connection

This option involves using a Data Source Name (DSN) string to connect to the desired local database.

$db = new LibSQL("libsql:dbname=database.db");
  • Usage Explanation:
    • The DSN string format is libsql:dbname=database.db, where "database.db" represents the name of the local database file.
    • This option is suitable for connecting to a database using the LibSQL protocol with the specified database name.

​
Standard SQLite Connection

In this option, you directly specify the filename of the SQLite database without using a DSN string.

$db = new LibSQL("database.db");
  • Usage Explanation:
    • Here, "database.db" is the filename of the SQLite database.
    • This option simplifies the connection process by directly referencing the database file.

​
Standard LibSQL Connection

This option is similar to the first option but uses the file protocol in the DSN string.

$db = new LibSQL("file:database.db");
  • Usage Explanation:
    • The DSN string format is file:database.db, where "database.db" is the name of the local database file.
    • It allows for connecting to a database using the LibSQL protocol with the specified file name.

​
Usage Example

<?php

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

// Create table
$sql = "CREATE TABLE IF NOT EXISTS users (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT, 
  age INTEGER
)";
$db->execute($sql);

// Insert data
$db->execute("INSERT INTO users (name, age) VALUES ('Diana Hooggan', 24)");

// Read data
$results = $db->query("SELECT * FROM users");

// Display data
foreach ($results['rows'] as $row) {
    echo "ID: " . $row['id'] . ", Name: " . $row['name'] . ", Age: " . $row['age'] . "\n";
}

// Close database
$db->close();

​
Error Handling

It’s important to note that incorrect usage of the connection parameters may result in errors. For example:

// Error: PHP Fatal error:  Uncaught Exception: Failed to parse DSN
$db = new LibSQL("libsql:database.db");

// Error: PHP Fatal error:  Uncaught Exception: Failed to parse DSN
$db = new LibSQL("");
  • Error Explanation:
    • Providing an invalid DSN string, such as missing required parameters or an empty string, will result in a parsing error.
    • Ensure that the DSN string is correctly formatted and contains the necessary parameters for establishing a connection.

By following these usage guidelines and ensuring the correct format of the DSN string, you can effectively establish connections with local databases using the LibSQL PHP Extension.