blob: 5e071303de89c02258dc3a1d00bb65c7b2b6e3d5 (
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
|
<?
$dic = "../blob/en_GB.dic";
$table = "english";
$bool = false;
$db = new SQLite3("../database/dict.db");
if($file = file($dic)){
$rows = count($file);
for($i=0;$i<$rows;$i++){
if(!$db->exec("
BEGIN TRANSACTION;
INSERT INTO " . $table " VALUES (NULL, " . $file[$i] . ");
COMMIT;
")){
echo "Failure writing to the database at row" . $i ."!";
$bool = true;
break;
}
}
if(!$bool){
echo "Successfull transfered the file into the database.";
}
} else {
echo "No file found!";
}
|
