setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $school_data = array(); $sql = "SELECT * FROM academy.school ORDER BY id ASC"; $stmt = $pdo->query($sql); foreach ($stmt as $row) { $school_data[$row['id']]['name'] = htmlspecialchars($row['name']); $school_data[$row['id']]['fc'] = $row['fc']; } $course = array( 1 => "モデル", 2 => "ダンス", ); $date = date('Y-n-j H:i'); // $date = '2015-8-14 00:00'; $date2 = explode(' ', $date); $date2 = explode('-', $date2[0]); $sql = "SELECT * FROM events WHERE type = 1 AND published = 1 AND start_time >= :start_time1 AND start_time < :start_time2 ORDER BY school, course"; $stmt = $pdo->prepare($sql); $stmt->bindValue(':start_time1', $date, PDO::PARAM_STR); $stmt->bindValue(':start_time2', date('Y-m-d', strtotime($date2[0]."-".$date2[1]."-".$date2[2]." +1 day")), PDO::PARAM_STR); $stmt->execute(); $event_data = $stmt->fetchAll(); $i = 0; foreach ($event_data as $row) { $sql = "SELECT * FROM users_events WHERE event_id = :event_id"; $stmt = $pdo->prepare($sql); $stmt->bindValue(':event_id', $row["id"], PDO::PARAM_INT); $stmt->execute(); $users_event_data = $stmt->fetchAll(); $cnt = count($users_event_data); foreach ($users_event_data as $row2) { if ($row2["accompanied"] == 2) $cnt++; } if ($cnt < $row["fixed_number"]) { $i++; ?>