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); }