|
Senior Coder
Join Date: Aug 2009
Location: Mansfield, Nottinghamshire, UK
Posts: 1,547
Thanks: 57
Thanked 148 Times in 147 Posts
|
auto fill database
Just made this to test how large amounts of data will be displayed. Someone might find it helpful.
PHP Code:
<?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";
?>
__________________
Website Design Mansfield
PHP Code:
function I_LOVE(){function b(&$b='P'){$b.='P';}function a($_){return $_++;}$b='P';define("B",'H');b($b=implode('',array($b=a($b),$b=a(B))));b($b);return $b;}
echo I_LOVE();
Last edited by Phil Jackson; 04-28-2010 at 07:25 AM..
|
|
Before you post, read our: 
