</header> <div class="wrapper clearfix"> <main class="main"> <h2 class="hidden">ARTICLES</h2> <div class="clearfix"> <?php //レッスンリストの一覧の作成 while (true) { $result = $stmt->fetch(PDO::FETCH_ASSOC); if ($result == false) { break; } $title = $result['title']; $start = $result['start_time']; $time = $result['time']; $time_jp = jikan($time); $userid = $result['user_id']; //1. DB接続します $pdo = new PDO('mysql:dbname=language_db;host=localhost', 'root', 'root'); //2. DB文字コードを指定(固定) $stmt_user = $pdo->query('SET NAMES utf8'); //3.データ登録SQL作成 $stmt_user = $pdo->prepare("SELECT * FROM user WHERE id={$userid}"); //4.SQL実行 $flag = $stmt_user->execute(); $result_user = $stmt_user->fetch(PDO::FETCH_ASSOC); $name = $result_user['name']; $main = $result_user['main_language']; $sub = $result_user['sub_language']; $picture = $result_user['picture']; $main_jp = main($main);
<li class="nav-item"><a href="#">イベント検索</a></li> <li class="nav-item"><a href="mypage.php">MYPAGE</a></li> </ul> </nav> </header> <div class="wrapper clearfix"> <main class="main"> <h2>レッスン情報</h2> <?php //レッスン情報 while ($result_lesson = $stmt_lesson->fetch(PDO::FETCH_ASSOC)) { $lesson_id = $result_lesson['id']; $lesson_title = $result_lesson['title']; $lesson_start = $result_lesson['start_time']; $lesson_time = $result_lesson['time']; $lesson_time_jp = jikan($lesson_time); $lesson_location = $result_lesson['location']; $lesson_detail = $result_lesson['detail']; //レッスンリクエスト //DB文字コードを指定(固定) $stmt_lesson_request = $pdo->query('SET NAMES utf8'); //データ登録SQL作成 $stmt_lesson_request = $pdo->prepare("SELECT * FROM lesson_request WHERE lesson_id={$lesson_id}"); //SQL実行 $flag_lesson_request = $stmt_lesson_request->execute(); //自分のレッスンへリクエストしている人 $result_lesson_request = $stmt_lesson_request->fetch(PDO::FETCH_ASSOC); $request_lesson_id = $result_lesson_request['id']; $request_user_id = $result_lesson_request['request_user_id']; //マッチングフラグ $matching = $result_lesson_request['matching'];