1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| set_time_limit(0);
define('NUM', 500 * 1000);
function generate_random_string ($maxlength = 10, $chars = "abcdefghijklmnopqrstuvwxyz0123456789") {
$str = "";
$c = strlen($chars) -1;
do {
$str .= $chars[mt_rand(0, $c)];
} while (strlen($str) < $maxlength);
return $str;
}
$pdo = new PDO('mysql:dbname=xxxxxxx;host=xxxxxxx', 'xxxxxxx', 'xxxxxxx');
$stmt = $pdo->prepare('REPLACE INTO `xxxxxxx` (`xxxxxxx`,`xxxxxxx`,`xxxxxxx`) VALUES (:xxxxxxx,:xxxxxxx,:xxxxxxx)');
$l = strlen((string)NUM);
for ($i = 0; $i < NUM; $i++) {
$p = array(
'xxxxxxx' => generate_random_string(15, '123456789'),
'xxxxxxx' => '+33' . generate_random_string(9, '0123456789'),
'xxxxxxx' => generate_random_string(16, '0123456789')
);
$r = $stmt->execute($p);
echo '[' . str_pad($i +1, $l, '0', STR_PAD_LEFT) . '/' . NUM . '] > Insert ' . $p['xxxxxxx'] . ':' . $p['xxxxxxx'] . ':' . $p['xxxxxxx'] . ' ' . ($r ? 'OK' : 'NOK') . "\n";
}
echo "Done."; |
Partager