<?php

// Pfadangabe evtl. anpassen
$vornamen_m = file_get_contents('maennervornamen.txt');
$vornamen_w = file_get_contents('frauenvornamen.txt');
$nachnamen = file_get_contents('nachnamen.txt');

$vornamen_m = explode("\n", $vornamen_m);
$vornamen_w = explode("\n", $vornamen_w);
$nachnamen = explode("\n", $nachnamen);

$insert = '';
$counter = 0;
$first = TRUE;
$new_step = 100; // Nach wie vielen erstellen Einträgen soll in die Datenbank eingetragen werden?

foreach($nachnamen AS $nachname)
{
	foreach($vornamen_m AS $vorname_m)
	{
		if (!$first){
			$insert .= ',';
		} else {
			$first = FALSE;
		}
		
		$insert .= "($vorname_m.' '.$nachname)\n";

		$counter++;
		
		if ($counter >= $new_step)
		{
			$first = TRUE;
			$counter = 0;
			db_query('INSERT INTO table_name ("name") VALUES '.$insert);
			$insert = '';
		}
	}
	
	foreach($vornamen_w AS $vorname_w)
	{
		if (!$first){
			$insert .= ',';
		} else {
			$first = FALSE;
		}
		
		$insert .= ",($vorname_w.' '.$nachname)\n";
		
		$counter++;
		
		if ($counter >= $new_step)
		{
			$first = TRUE;
			$counter = 0;
			db_query('INSERT INTO table_name ("name") VALUES '.$insert);
			$insert = '';
		}
	}
}

db_query('INSERT INTO table_name ("name") VALUES '.$insert);

?>

<?php
defined ('main') or die ( 'no direct access' );

$title = $allgAr['title'].'';
$hmenu = '';
$design = new design ( $title , $hmenu );
$design->header();

// Pfadangabe evtl. anpassen
$vornamen = file_get_contents('include/contents/name.txt');

$vornamen = explode("\n", $vornamen);

$insert = '';
$first = TRUE;

foreach($vornamen AS $vorname)
{
    if (!$first){
        $insert .= ',';
    } else {
        $first = FALSE;
    }

    $insert .= "($vorname)";
}

db_query('INSERT INTO ic1_generator ("name") VALUES '.$insert);

$design->footer(0);

?>

db_query('INSERT INTO ic1_generator ("name") VALUES "'.$insert.'");

MySQL Error:
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"name") VALUES ("Vilirlil I"),("yly"),("iss Shalee Jhulomar Beraxle Pe"),("ar Sa' at line 1
in Query:
INSERT INTO ic1_generator ("name") VALUES ("Vilirlil I"),("yly"),("iss Shalee Jhulomar Beraxle Pe"),("ar Salica Ilithra Mou"),("tar Niira Rali"),("driira Ir"),("ee Tapry"),("tle Gaussra Wae"),("driia Shy"),("uli"),(" Salavdra Shardorl Elvirlirae Lylmrara Rasoj Daldsza Selvry"),("a Nathrae Aliluth Ze"),("daerly")

MySQL Error:
1054 : Unknown column 'Slad' in 'field list'
in Query:
INSERT INTO ic1_generator (`name`) VALUES (Slad),(Horvir),(Aslogmund),(Algi),

$insert .= "('$vorname')";
}

db_query('INSERT INTO ic1_generator_wikinger (`name`) VALUES '.$insert);