$fieldseparator = ";";
$lineseparator = "\n";

$db = new mysqli ($databasehost, $databaseusername, $databasepassword, $databasename);
$db->query("truncate table $databasetable"); // clear existing table
			
$lines = 0; // number of a strings
$linearray = array(); 

foreach (explode($lineseparator, $csvcontent) as $line) {
	$lines++;
	$line = trim ($line, " \t");
	$line = str_replace("\r", "", $line);
				
	$line = str_replace("'","\'",$line);
				
	$linearray = explode($fieldseparator, $line);
	$linemysql = implode("','", $linearray);
			    			   
	if($lines == 1) {continue;} // pass the title string
			    
    $query = "insert into $databasetable values('$linemysql');";
	$result = $db->query ($query);
}