<?php

date_default_timezone_set('UTC');
$num=2000;

$canRegion3id[10]='Alberta';
$canRegion3id[11]='British Columbia';
$canRegion3id[12]='Manitoba';
$canRegion3id[13]='New Brunswick';
$canRegion3id[14]='Newfoundland and Lab';
$canRegion3id[15]='Northwest Territorie';
$canRegion3id[16]='Nova Scotia';
$canRegion3id[17]='Nunavut';
$canRegion3id[18]='Ontario';
$canRegion3id[19]='Prince Edward Island';
$canRegion3id[20]='Quebec';
$canRegion3id[21]='Saskatchewan';
$canRegion3id[22]='Yukon';

$usaRegion3id[10]='Alaska';
$usaRegion3id[11]='American Samoa';
$usaRegion3id[12]='Arizona';
$usaRegion3id[13]='Arkansas';
$usaRegion3id[14]='California';
$usaRegion3id[15]='Colorado';
$usaRegion3id[16]='Connecticut';
$usaRegion3id[17]='Delaware';
$usaRegion3id[18]='District of Columbia';
$usaRegion3id[10]='Florida';
$usaRegion3id[20]='Georgia';
$usaRegion3id[21]='Guam';
$usaRegion3id[22]='Hawaii';
$usaRegion3id[23]='Idaho';
$usaRegion3id[24]='Illinois';
$usaRegion3id[25]='Indiana';
$usaRegion3id[26]='Iowa';
$usaRegion3id[27]='Kansas';
$usaRegion3id[28]='Alaska';
$usaRegion3id[29]='Kentucky';
$usaRegion3id[30]='Louisiana';
$usaRegion3id[31]='Maine';
$usaRegion3id[32]='Maryland';
$usaRegion3id[33]='Massachusetts';
$usaRegion3id[34]='Michigan';
$usaRegion3id[35]='Minnesota';
$usaRegion3id[36]='Mississippi';
$usaRegion3id[37]='Missouri';
$usaRegion3id[38]='Montana';
$usaRegion3id[39]='Nebraska';
$usaRegion3id[40]='Nevada';
$usaRegion3id[41]='New Hampshire';
$usaRegion3id[42]='New Jersey';
$usaRegion3id[43]='New Mexico';
$usaRegion3id[44]='New York';
$usaRegion3id[45]='North Carolina';
$usaRegion3id[46]='North Dakota';
$usaRegion3id[47]='Northern Mariana Islands';
$usaRegion3id[48]='Ohio';
$usaRegion3id[49]='Oklahoma';
$usaRegion3id[50]='Oregon';
$usaRegion3id[51]='Pennsylvania';
$usaRegion3id[52]='Puerto Rico';
$usaRegion3id[53]='Rhode Island';
$usaRegion3id[54]='South Carolina';
$usaRegion3id[55]='Tennessee';
$usaRegion3id[56]='Texas';
$usaRegion3id[57]='Virgin Islands';
$usaRegion3id[58]='South Dakota';
$usaRegion3id[59]='Utah';
$usaRegion3id[60]='Vermont';
$usaRegion3id[61]='Virginia';
$usaRegion3id[62]='Washington';
$usaRegion3id[63]='West Virginia';
$usaRegion3id[64]='Wisconsin';
$usaRegion3id[65]='Wyoming';

$mexRegion3id[10]='Aguascalientes';
$mexRegion3id[11]='Baja California';
$mexRegion3id[12]='Baja California Sur';
$mexRegion3id[13]='Campeche';
$mexRegion3id[14]='Ciudad de Mexico';
$mexRegion3id[15]='Chiapas';
$mexRegion3id[16]='Chihuahua';
$mexRegion3id[17]='Coahuila de Zaragoza'; $mexRegion3id[18]='Colima';
$mexRegion3id[10]='Durango';
$mexRegion3id[20]='Guanajuato';
$mexRegion3id[21]='Guerrero';
$mexRegion3id[22]='Hidalgo';
$mexRegion3id[23]='Jalisco';
$mexRegion3id[24]='Mexico';
$mexRegion3id[25]='Michoacan de Ocampo';
$mexRegion3id[26]='Morelos';
$mexRegion3id[27]='Nayarit';
$mexRegion3id[28]='Nuevo Leon';
$mexRegion3id[29]='Oaxaca';
$mexRegion3id[30]='Puebla';
$mexRegion3id[31]='Queretaro de Arteaga';
$mexRegion3id[32]='Quintana Roo';
$mexRegion3id[33]='San Luis Potosí';
$mexRegion3id[34]='Sinaloa';
$mexRegion3id[35]='Sonora';
$mexRegion3id[36]='Tabasco';
$mexRegion3id[37]='Tamaulipas';
$mexRegion3id[38]='Tlaxcala';
$mexRegion3id[39]='Veracruz de';
$mexRegion3id[40]='Ignacio de la Llave';
$mexRegion3id[41]='Yucatán';
$mexRegion3id[42]='Zacatecas';


Warning: Undefined variable $count in /home/oerpn/public_html/mysqli-bug.php on line 124

Warning: Undefined variable $count in /home/oerpn/public_html/mysqli-bug.php on line 124

Warning: Undefined variable $num in /home/oerpn/public_html/mysqli-bug.php on line 124

Warning: Undefined variable $count in /home/oerpn/public_html/mysqli-bug.php on line 124
for(=1;<=;++) $countries=mt_rand(0,90);

Warning: Undefined variable $countries in /home/oerpn/public_html/mysqli-bug.php on line 129
if(<=1){
$region2NumDB=102;
$region2NameDB='México';
$region3NumDB=mt_rand(10,42);
$region3NameDB=$mexRegion3id[mt_rand(10,42)];

Warning: Undefined variable $countries in /home/oerpn/public_html/mysqli-bug.php on line 139
}elseif(<=14){
$region2NumDB=100;
$region2NameDB='Canada';
$region3NumDB=mt_rand(10,22);
$region3NameDB=$canRegion3id[mt_rand(10,22)];
}else{
$region2NumDB=101;
$region2NameDB='United States';
$region3NumDB=mt_rand(10,65);
$region3NameDB=$usaRegion3id[mt_rand(10,65)];
}

$username[$count]=bin2hex(random_bytes(mt_rand(10,20)));
$firstName[$count]=bin2hex(random_bytes(mt_rand(3,15)));
$lastName[$count]=bin2hex(random_bytes(mt_rand(6,15)));
$year[$count]=mt_rand(1900,2008);
$month[$count]=mt_rand(1,12);
$day[$count]=mt_rand(1,31);
$email[$count]=bin2hex(random_bytes(mt_rand(15,20)));
$password[$count]=bin2hex(random_bytes(mt_rand(8,20)));
$region2id[$count]=$region2NumDB;
$region2Name[$count]=$region2NameDB;
$region3id[$count]=$region3NumDB;
$region3Name[$count]=$region3NameDB;
$color1[$count]=1;
}

require_once ('../require-once/DBinfo.php');
$con=mysqli_connect(db_host,db_user,db_pass,db_membersData);
mysqli_set_charset($con,"utf8");

$query="INSERT INTO `members`(`username`,`firstName`,`lastName`,`year`,`month`,`day`,`email`,`password`,`region2id`,`region2Name`,`region3id`,`region3Name`,`color1`)VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)";

$stmt=mysqli_stmt_init($con);
mysqli_stmt_prepare($stmt,$query);

foreach($username as $index => $value){
mysqli_stmt_bind_param($stmt,'sssiiissisisi',$username[$index],$firstName[$index],$lastName[$index],$year[$index],$month[$index],$day[$index],$email[$index],$password[$index],$region2id[$index],$region2Name[$index],$region3id[$index],$region3Name[$index],$color1[$index]);
mysqli_stmt_execute($stmt);
}

$stmt->close($stmt)

?>