KYu1SLHk

1<?php
2
3$db = new SQLite3('testing.sqlite', SQLITE3_OPEN_CREATE | SQLITE3_OPEN_READWRITE);
4
5// Create a table.
6$db->query(
7'CREATE TABLE IF NOT EXISTS "users" (
8    "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
9    "name" VARCHAR
10  )'
11);
12$db->query("CREATE TABLE `incoming_sms` (`idx` INTEGER PRIMARY KEY , `mno` VARCHAR, `txt` VARCHAR)");
13
14// Insert some sample data.
15$db->query('INSERT INTO "users" ("name") VALUES ("Karl")');
16$db->query('INSERT INTO "users" ("name") VALUES ("Linda")');
17$db->query('INSERT INTO "users" ("name") VALUES ("John")');
18
19// Get a count of the number of users
20$userCount = $db->querySingle('SELECT COUNT(DISTINCT "id") FROM "users"');
21echo("User count: $userCount\n");
22
23// Close the connection
24$db->close();
25
26?>