<?

#-----[ Paramètres de Configuration ]----------------------

$host = 'localhost';

$user = 'root';

$base = 'test';

$pass = '';

$db = mysql_connect ($host, $user, $pass);

mysql_select_db ($base,$db);



#-----[ Temps d'Execution ]--------------------------------

function microtime_float()

{

   list($usec, $sec) = explode(" ", microtime());

   return ((float)$usec + (float)$sec);

}

$time_start = microtime_float();



#-----[ Construction du tableau de joueurs ]---------------

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

{

    $array_joueurs[$i] = round(rand(1,2)).substr(round(rand(1000001,1999999)), 1);

}



for( $i=201 ; $i<=210 ; $i++ )

{

    $array_joueurs[$i] = '3'.substr(round(rand(1000001,1999999)), 1);

}



#-----[ Insertion en BDD ]--------------------------------

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

{

    $sql = 'INSERT INTO game_biens SET '

            .'id_users = '.$array_joueurs[round(rand(0,210))].', '

            .'id_units = '.round(rand(0,300)).', '

            .'id_source = '.round(rand(0,300)).', '

            .'stock = '.round(rand(1,3)).', '

            .'resistance = '.round(rand(0,300)).', '

            .'experience = '.round(rand(0,300)) ;

            

    echo $sql.'<br>';

    mysql_query($sql);

    

}



#-----[ Temps d'Execution ]--------------------------------

$time_end = microtime_float();

$time = $time_end - $time_start;

$time = substr($time, 0, strpos($time, ".")).substr(strstr($time, '.'), 0 , 4);

return 'Page générée en '.$time.' secondes';

?>

<?php 

$sql = 'SELECT id_biens FROM game_biens';

$req = mysql_query($sql);

echo '<br>Nb d\'enregistrements : '.mysql_num_rows($req);