function append_string($file_name = 'append_string.out', $data) { $handle = fopen($file_name, "a+"); fwrite($handle, "\n"); fwrite($handle, $data); fclose($handle); } function format_string($str) { return mysql_escape_string(mb_ucasefirst($str)); } function replace_newline($string) { return (string) str_replace(array("\r", "\r\n", "\n"), ' ', $string); } function mb_ucasefirst($str) { $str[0] = mb_strtoupper($str[0]); return $str; } $file_name = 'most_common_words'; $fhandle = fopen($file_name, "r"); $fcontents = fread($fhandle, filesize($file_name)); $fcontents = replace_newline($fcontents); $word_array = explode(" ", $fcontents); $word_count = count($word_array); for ($i = 0; $i < 100; $i++) { $query = "INSERT INTO {$table} VALUES ();"; append_string('many_.....', $query); } fclose($fhandle);
$email = format_string($word_array[$rand]); $rand = rand(0, $word_count - 1); $email .= "@" . format_string($word_array[$rand]); switch (rand(1, 5)) { case 1: $email .= ".com"; break; case 2: $email .= ".net"; break; case 3: $email .= ".se"; break; case 4: $email .= ".no"; break; case 5: $email .= ".dk"; } $rand = rand(1, 10); if ($rand == 10) { $type = "foreign"; $ssn = NULL; $query = "INSERT INTO student VALUES (null, null, '{$fname}', '{$lname}', '{$address}', '{$phone_nbr}', '{$email}', '{$type}');"; } else { $type = "domestic"; $query = "INSERT INTO student VALUES (null, '{$ssn}', '{$fname}', '{$lname}', '{$address}', '{$phone_nbr}', '{$email}', '{$type}');"; } append_string('many_students.sql', $query); } fclose($fhandle);
$file_name = 'most_common_words'; $fhandle = fopen($file_name, "r"); $fcontents = fread($fhandle, filesize($file_name)); $fcontents = replace_newline($fcontents); $word_array = explode(" ", $fcontents); $word_count = count($word_array); for ($i = 0; $i < 100; $i++) { switch (rand(1, 5)) { case 1: $code = "INF"; break; case 2: $code = "EKO"; break; case 3: $code = "MAT"; break; case 4: $code = "FIL"; break; case 5: $code = "LIT"; } $code .= rand(100, 999); $rand = rand(0, $word_count - 1); $name = format_string($word_array[$rand]); $points = rand(1, 30) . "." . rand(0, 9); $query = "INSERT INTO course VALUES (null, '{$code}', '{$name}', '{$points}');"; append_string('many_courses.sql', $query); } fclose($fhandle);