<?

$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!";
}