Turso Quickstart (PHP)

In this PHP quickstart we will learn how to:

Retrieve database credentials
Install the libSQL package
Connect to a Turso database
Execute a query using SQL

Retrieve database credentials

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=

You will want to store these as environment variables.

Install

First begin by adding libSQL to your project:

composer require darkterminal/libsql-client-php

Connect

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

<?php

use Darkterminal\LibSQL\LibSQL;

require_once 'vendor/autoload.php';

$config = [
  "url" => getenv('TURSO_DATABASE_URL'),
  "flags" => LIBSQLPHP_OPEN_READWRITE | LIBSQLPHP_OPEN_CREATE,
  "encryptionKey" => ""
];

$db = new LibSQL($config);

<?php

use Darkterminal\LibSQL\LibSQL;
use Darkterminal\LibSQL\Types\HttpStatement;
use Darkterminal\LibSQL\Types\LibSQLResult;

require_once 'vendor/autoload.php';

$config = [
  'url' => getenv('TURSO_DATABASE_URL'),
  'authToken' => getenv('TURSO_AUTH_TOKEN'),
  'tls' => false
];

$db = new LibSQL($config);

Execute

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

Client SDKs

TypeScript / JS

Rust

Go

Python

PHP

HTTP

Turso Quickstart (PHP)