</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');
//３．データ登録SQL作成
$stmt_user = $pdo->prepare("SELECT * FROM user WHERE id={$userid}");
//４．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'];
