· 8 years ago · Jul 19, 2018, 01:12 AM
1<?php
2//Create a new SQLite3 Database
3$db = new SQLite3('members.db');
4
5//Create a new table to our database
6$query = "CREATE TABLE IF NOT EXISTS members (firstname STRING, lastname STRING, address STRING, key STRING)";
7$db->exec($query);
8
9?>
10
11$query = "INSERT INTO members (firstname,lastname,address,key) VALUES ('Jane','Doe','New York','key')";
12
13//Create a new SQLite3 Database
14$db = new SQLite3('members.db');
15
16//Create a new table to our database
17$query = "CREATE TABLE IF NOT EXISTS members (firstname STRING, lastname STRING, address STRING, key STRING)";
18
19$query = "INSERT INTO members (firstname,lastname,address,key) VALUES ('Jane','Doe','New York','key')";
20
21$db->exec($query);
22
23$query = "INSERT INTO members (firstname,lastname,address,key) VALUES ('Jane','Doe','New York','key')";
24
25//Create a new SQLite3 Database
26$db = new SQLite3('members.db');
27
28//Create a new table to our database
29$query = "CREATE TABLE IF NOT EXISTS members (firstname STRING, lastname STRING, address STRING, key STRING)";
30
31$query = "INSERT OR IGNORE INTO members (firstname,lastname,address,key) VALUES ('Jane','Doe','New York','key')";
32
33$db->exec($query);