$id_array = array(); if ($result->num_rows > 0) { $i = 0; while ($row = $result->fetch_assoc()) { $id_array[$i++] = $row['id']; } } return $id_array; } function attends_event($event_id, $facebook_id, $connection) { $sql = "INSERT INTO IsAttending (event_id, facebook_id)\n\t\tVALUES ({$event_id}, '{$facebook_id}')"; $result = $connection->query($sql); } $conn = new mysqli($servername, $username, $password, $dbname); if (mysqli_connect_error()) { die("Databse failed: " . mysqli_connect_error()); } $events_array = get_events($conn); $length = count($events_array); $user_ids_1 = get_user_ids($conn); $user_ids_2 = get_user_ids($conn); for ($i = 0; $i < 30; $i++) { shuffle($events_array); shuffle($user_ids_1); shuffle($user_ids_2); for ($j = 0; $j < 100; $j++) { attends_event($events_array[$j], $user_ids_1[$i], $conn); attends_event($events_array[$j], $user_ids_2[$i], $conn); } }
$result = $connection->query($sql); $id_array = array(); if ($result->num_rows > 0) { $i = 0; while ($row = $result->fetch_assoc()) { $id_array[$i++] = $row['id']; } } return $id_array; } function attends_event($event_id, $facebook_id, $connection) { $sql = "INSERT INTO IsAttending (event_id, facebook_id)\n\t\tVALUES ({$event_id}, '{$facebook_id}')"; $result = $connection->query($sql); } $conn = new mysqli($servername, $username, $password, $dbname); if (mysqli_connect_error()) { die("Databse failed: " . mysqli_connect_error()); } $events_array = get_events($conn); $length = count($events_array); echo $length, "<br>"; $user_ids = get_user_ids($conn); for ($i = 0; $i < 10; $i++) { shuffle($events_array); $j = 0; foreach ($user_ids as $user) { attends_event($events_array[rand(0, 100000) % $length], $user, $conn); $j++; } }