name CHAR(20),
birth DATE);');
//create phone numbers table
$mysqli->query('CREATE TABLE IF NOT EXISTS phones_tbl(
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
country_code SMALLINT UNSIGNED NOT NULL,
operator_code SMALLINT UNSIGNED NOT NULL,
phone_number INT UNSIGNED NOT NULL,
balance INT NOT NULL DEFAULT 0,
UNIQUE KEY phone_number(country_code, operator_code, phone_number),
FOREIGN KEY (user_id)
REFERENCES users_tbl(id)
ON DELETE CASCADE);');
for ($i = 1; $i <= 2000; $i++) {
generate_user($i);
}
//generate user using the cycle index as user id
function generate_user($n)
{
global $mysqli;
$name = 'user_' . $n;
$birth = random_birth_date();
//generate 1-3 phones for current user
$number_of_phones = rand(1, 3);
$phones = generate_phones($number_of_phones);
//insert generated data to database
$mysqli->query('INSERT INTO users_tbl
(name, birth)
VALUES
("' . $name . '", "' . $birth . '");');
break;
case 2:
$user['group_name'] = 'intermediate';
break;
case 3:
$user['group_name'] = 'upperintermediate';
break;
case 4:
$user['group_name'] = 'advanced';
break;
}
$user['city'] = $cities[rand(0, count($cities) - 1)];
$user['phone'] = rand(0, 9) . rand(0, 9) . rand(0, 9) . '-' . rand(0, 9) . rand(0, 9) . '-' . rand(0, 9) . rand(0, 9);
$user['sex'] = rand(0, 1);
$user['sex'] = $user['sex'] == 0 ? 'female' : 'male';
$user['driver_license'] = rand(0, 1);
return $user;
}
if (!($db = sqlite_open('db', 0777, $sqliteerror))) {
die($sqliteerror);
}
sqlite_query("DROP TABLE users", $db);
sqlite_query("CREATE TABLE users (id INTEGER PRIMARY KEY, name varchar(100), age int, group_name varchar(25), city varchar(50), phone varchar(20), sex varchar(6), driver_license bool)", $db);
echo "<pre>";
for ($i = 0; $i < 20; $i++) {
$user = generate_user();
$query = "INSERT INTO 'users' VALUES(null, '{$user['name']}','{$user['age']}','{$user['group_name']}','{$user['city']}','{$user['phone']}','{$user['sex']}','{$user['driver_license']}')";
$sql = "INSERT INTO touch_users(id, name, age, group_name, city, phone, sex, driver_license) VALUES(0, '{$user['name']}','{$user['age']}','{$user['group_name']}','{$user['city']}','{$user['phone']}','{$user['sex']}','{$user['driver_license']}')";
echo $sql . ";\n";
sqlite_query($query, $db);
}
