Turso Quickstart (PHP)

Before your start using libSQL in PHP, you need to install and configure your PHP environment:

Download the latest build extension/driver binary you can see at Release page. It's available for:

• Linux
• Mac/Darwin
• Windows (WSL) / Devcontainer

curl --proto '=https' --tlsv1.2 -sSf "https://darkterminal.github.io/turso-php-installer/dist/turso-php-installer.phar"
./turso-php-installer.phar

sudo mv turso-php-installer.phar /usr/local/bin/turso-php-installer

turso-php-installer install

$ php --m | grep libsql
liblibsql_php

turso-php-installer update

turso-php-installer uninstall

$ php --m | grep libsql
liblibsql_php

Now, LibSQL class is available in your PHP environment! You can use it everywhare in your PHP project 🎉

You will need an existing database to continue. If you don’t have one, create one.

Get the database URL:

turso db show --url <database-name>

Get the database authentication token:

turso db tokens create <database-name>

Assign credentials to the environment variables inside .env.

TURSO_DATABASE_URL=
TURSO_AUTH_TOKEN=

Now connect to your local or remote database using the libSQL connector:

<?php

$config = [
    "url" => "file:database.db",
    "syncUrl" => getenv('TURSO_DATABASE_URL'),
    "authToken" => getenv('TURSO_AUTH_TOKEN')
];

$db = new LibSQL($config);

<?php

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

<?php

$url = getenv('TURSO_DATABASE_URL');
$token = getenv('TURSO_AUTH_TOKEN');

$db = new LibSQL("libsql:dbname=$url;authToken=$token");

You can execute SQL queries against your existing database as follows:

<?php

$createUsers = <<<STMT
CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
    age INTEGER
);
INSERT INTO users (name, age) VALUES ('Prof. Ir. Onno Widodo Purbo, M.Eng., Ph.D', 61);
INSERT INTO users (name, age) VALUES ('Jim Geovedi', 41);
INSERT INTO users (name, age) VALUES ('Nasirun', 59);
STMT;

$db->executeBatch($createUsers);

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

If you need to use placeholders for values, you can do that:

When using embedded replicas you should call sync() on the database type to sync your local database with the primary database:

<?php

$db->sync();