auto fill database

Just made this to test how large amounts of data will be displayed. Someone might find it helpful.


<?php

define( "DB_USERNAME", "root" );
define( "DB_PASSWORD", "" );
define( "DB_SERVER", "localhost" );
define( "DB_NAME", "" );
define( "TABLE", "" );
define( "NUMBER_OF_ENTRIES", "200" );

$CON = mysql_connect( DB_SERVER, DB_USERNAME, DB_PASSWORD ) or die( "_error_ on line: " . __LINE__ . " of " . __FILE__ . mysql_error() );
$DB = mysql_select_db( DB_NAME, $CON );
$array = array('mansfield','sutton','ashfield','derby','luton','nottingham','chesterfield','doncaster');

$master = array(
'col_name' => array(
'DATE',
'START_TIME',
'END_TIME',
'STANDS_AVAILABLE',
'STAND_COST',
'ENTRANTS_FEE',
'CONTACT_EMAIL',
'CONTACT_NUMBER',
'EVENT_DESCRIPTION',
'EVENT_NAME',
'LOCATION',
'TEMP_ADDRESS'),
'base_data' => array(
'strtotime(rand(1, 31) . "-" . rand(1, 12) . "-20" . rand(10, 15));',
'rand(01,23) . ":" . rand(00, 59);',
'rand(01,23) . ":" . rand(00, 59);',
'"no";',
'"00.00";',
'"05.00";',
'"demo$x@demo.com";',
'"077" . rand( 00000000, 99999999 );',
'"Montes, placerat risus et! Ultrices! Sed, magna in urna mattis! Sed ultricies mid placerat. Tempor magna? Nascetur lorem? Et in? Ultrices scelerisque mid sit in cras placerat mus, ultricies phasellus, ut rhoncus egestas amet, magnis nisi! Et magna amet lacus pulvinar rhoncus etiam turpis, amet, tristique sagittis platea, dignissim a.
Mus ultricies lectus scelerisque ac et ridiculus facilisis aliquet cras ultrices arcu, placerat, elementum ultricies etiam phasellus, cum risus, tincidunt est nec eros nec natoque? Egestas vel sed amet, massa porttitor aenean risus dolor, amet cum elit lorem nunc, magna ut aliquam adipiscing aliquam augue aenean dictumst mauris adipiscing.
Tincidunt urna sed magna, rhoncus, arcu dignissim tincidunt pulvinar amet est? Mus, hac pulvinar sociis a lorem elementum aenean hac est eu integer arcu pulvinar et dignissim lectus, aliquet turpis nisi, eros augue nisi sociis sociis integer nec integer? In ac odio lectus! Nunc. Porta cum porta auctor ac.
Pulvinar nisi turpis, lundium dis cursus etiam mattis nisi elit tempor! Pulvinar augue porta dis arcu hac? Pulvinar odio lorem mattis ultricies a montes cras! Cum augue in lorem, eu elementum. Elementum et sociis vel urna mid eros cras sed enim proin amet odio? Eros phasellus? Integer, et lorem.
Elementum placerat rhoncus. Aliquam sociis scelerisque diam sed et! Pellentesque, rhoncus velit habitasse sed a penatibus, vut lundium augue! Augue sit, lundium ac sociis magna quis elementum cras, tortor porta, et ultrices nisi nisi, quis aliquam enim ut lacus. Ridiculus tempor montes elit in pid a penatibus elementum placerat.";',
'"Demo Event $x";',
'$array[rand(0, (count($array)-1))];',
"md5(microtime());"
)

);

for( $x=0; $x < NUMBER_OF_ENTRIES; $x++ ) {
$col_str = '';
$val_str = '';
foreach( $master['col_name'] as $key => $col_name ) {
eval("\$str = " . $master['base_data'][$key]);
$col_str .= "`" . $col_name . "`, ";
$val_str .= "'" . $str . "', ";
}
$insert_query = "INSERT INTO `" . TABLE . "` ( " . substr( $col_str, 0, -2 ) . " ) VALUES ( " . substr( $val_str, 0, -2 ) . " )";
mysql_query( $insert_query, $CON ) or die( "Error: on line " . __LINE__ . " located at " . __FILE__ . " " . mysql_error() );
}

mysql_close( $CON );

echo "complete";

?>