<?php

$hostname = "localhost";
$username = "rogier_woorden";
$password = "";
$database = "rogier_woorden";

mysql_connect($hostname,$username,$password) or die(mysql_error());
mysql_select_db($database);

$file = strtolower(file_get_contents('woorden.txt'));

$words = explode("\n", $file);

foreach($words as $word) {
    $lettergrepen = count(explode('·', $word));

    $letters_array = str_split($word);
    $alleletters = array();
    foreach($letters_array as $letter) {
        if(!in_array($letter, $alleletters)) {
            $alleletters[] = $letter;
        }
    }
    foreach($alleletters as $var) {
        $letters .= $var;
    }

    $tekens = strlen($word) - $lettergrepen + 1;
    $result = mysql_query("INSERT INTO woorden (woord, tekens, lettergrepen, letters) VALUES ('".$word."', '".$tekens."', '".$lettergrepen."', '".$letters."')");
}


?>