Datubāzes generātors

<?PHP

$link = mysql_connect('localhost','root','') or exit('Nevar savienoties ar datu bāžu serveri: '. mysql_error());

$db = mysql_select_db('23janv',$link) or exit('Nevar izvēlēties datu bāzi: '. mysql_error());

mysql_query("SET NAMES 'utf8';",$link);

echo 'izpidīts.' .PHP_EOL;

for ($j=0; $j<250;$j++){

$sql_buffer = "INSERT INTO `test` (`name`, `price`, `sold` ) VALUES".PHP_EOL;

$num = 20000;

for ($i=0; $i<$num; $i++)

{

$name = 'C'.$i; ///rand_str(rand(12,50));

$price = 'A'.rand(0,2000); ///rand_str(rand(1,4),3).'.'.rand_str(2,3);

$sold = 'B5'; ///rand_str(rand(1,4),3);

$sql_buffer .= "('$name', '$price', '$sold' )";

if($i<($num-1)){

$sql_buffer .= ','.PHP_EOL;

}else{

$sql_buffer .= ';';

}

}

mysql_query($sql_buffer);

echo $j.'<br>';

}

?>