<?php
	$File = fopen("OffensiveWords.txt", "r");
	$Words;
	$i = 0;
	if ($File) {
		while (($line = fgets($File)) !== false) {
			$Words[$i] = $line;
			$i++;
		}
		fclose($File);
		AddToDb($Words);
	}
	else {
		echo ("Error getting file");
	}
	
	function AddToDb($Words) {
		$ServerName = "localhost";
		$ServerUserName = "root";
		$ServerPassword = "root";
		$dbName = "brentswelding";
		
		$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword, $dbName);
		if ($conDataBase->connect_error) {
			die("Connection Failed: " . $conDataBase->connect_error);
		}
		
		foreach ($Words as $value) {
			$sql = "INSERT INTO words (word) VALUES('".$value."');";
			if ($conDataBase->query($sql) != TRUE) {
				echo ("Failed at word " . $value);
			}
		}
		
		$conDataBase->close();
	}
?>