I have modified the program to store frequency onto a local SQLite3 format DB.
parse_str(implode('&', array_slice($argv, 1)), $_GET);
function str_split_unicode($str, $l = 0) {
$len = mb_strlen($str, "UTF-8");
for ($i = 0; $i < $len; $i += $l) {
$ret[] = mb_substr($str, $i, $l, "UTF-8");
return preg_split("//u", $str, -1, PREG_SPLIT_NO_EMPTY);
$charSet = 'AaĀāÁáǍǎÀàÄäǞǟÄ́ä́Ä̌ä̌Ä̀ä̀BbCcÇçČčĈĉDdĐđEeĒēÉéĚěÈèFfGgĜĝ' .
'HhĤĥIiĪīÍíǏǐÌìJjKkLlMmM̄m̄ḾḿM̌m̌M̀m̀NnN̄n̄ŃńŇňǸǹŊŋŊ̄ŋ̄' .
'Ŋ́ŋ́Ŋ̌ŋ̌Ŋ̀ŋ̀OoŌōÓóǑǒÒòÖöȪȫÖ́ö́Ö̌ö̌Ö̀ö̀PpQqRrŘřSsŠšŜŝTtŦŧ' .
'UuŪūÚúǓǔÙùÜüǕǖǗǘǙǚǛǜVvWwXxYyZzŽžẐẑ0123456789';
$hFile = @fopen("./input/".$_GET['id'].".txt", "r") or exit("\nUnable to open input file.\n");
//$dbFile = "MideDikcionari.db";
//$db = new SQLite3($dbFile, 0666, $sqliteerror);
$dbFile = 'sqlite:./MideDikcionari.db';
$db = new PDO($dbFile); //success
$statement = $db->prepare("CREATE TABLE IF NOT EXISTS dikcionari (word TEXT, freq LONG);");
$result = $statement->execute();
print_r('<P>Create Table. Result: ' . $result . '</P>');
// microtime(true) returns the unix timestamp plus milliseconds as a float
$starttime = microtime(true);
$lines = 0; $words = 0; $chars = 0;
// Reference of mb_strtolower: http://php.net/manual/en/function.mb-strtolower.php
$Line = mb_strtolower(fgets($hFile), 'UTF-8');
$Words = str_word_count($Line, 1, $charSet);
foreach ($Words as $Word) {
// rekommenden metods: http://php.net/manual/en/sqlite3.query.php
$statement = $db->prepare("SELECT freq FROM dikcionari WHERE word=:word;");
$statement->bindValue(':word', $Word, PDO::PARAM_STR);
$result = $statement->execute();
$numRows = $statement->fetch(PDO::FETCH_ASSOC);
print_r('<P>' . $Word . ' --> ' . $numRows['freq']);
$freq = 1 + $numRows['freq'];
// rekommenden metods: http://php.net/manual/en/sqlite3.query.php
$statement = $db->prepare("UPDATE dikcionari SET freq=:freq WHERE word=:word;");
print_r('<P>Creating: ');
// rekommenden metods: http://php.net/manual/en/sqlite3.query.php
$statement = $db->prepare("INSERT INTO dikcionari VALUES (:word, :freq);");
$statement->bindValue(':word', $Word, PDO::PARAM_STR);
$statement->bindValue(':freq', $freq, PDO::PARAM_INT);
$result = $statement->execute();
print_r(' ==> ' . $Word . ' --> ' . $freq . ' Result: ' . $result . '</P>');
$endtime = microtime(true);
$timediff = $endtime - $starttime;
// http://php.net/manual/en/pdo.connections.php
// and now we're done; close it
print("<P>Eläpsen taim: " . print_r($timediff) . " sekonds.</P>");
discoholicmusic
jbbartram-illu
origamiaround
germansingergirl
janainaart
kaledo-art
