blob: 79a7fdd948b71b026b10abadf767c6e37b48ff3b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
<?
$db = new SQLite3("../database/dict.db");
$bool = false;
foreach ($_GET as $name => $value) {
if(preg_match("/drop(ped)?/i",$name)){
$bool=true;
}
}
if($bool){
if($db->exec("
BEGIN TRANSACTION;
PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type = 'table';
PRAGMA writable_schema = 0;
COMMIT;
VACUUM;")
){
echo "dropped everything";
} else {
echo "error with database";
}
} else {
if($db->exec("
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS english (id INTEGER PRIMARY KEY, word TEXT UIQUE);
CREATE TABLE IF NOT EXISTS german (id INTEGER PRIMARY KEY, word TEXT UIQUE);
COMMIT;")
) {
echo "Success!";
} else {
echo "Failure!" ;
}
}
|
