"日",1=>"月",2=>"火",3=>"水",4=>"木",5=>"金",6=>"土");
try {
$dbh = new PDO('mysql:host=localhost;dbname=jimu', DB_USER, DB_PASSWORD, $options);
//---------------------------------------------------------------------------------------------------//
//日付関連
//---------------------------------------------------------------------------------------------------//
$select_day = date("Y/m/d");
$select_day2 = date("n月j日");
$youbi = date("w");
$chk_time = date("Y/m/d H:i"); //現在時刻の取得
//---------------------------------------------------------------------------------------------------//
//生徒が開始ボタンを押せる時間設定(授業開始10分前に設定)
//---------------------------------------------------------------------------------------------------//
$lesson_start[1] = $lesson_date." 08:45";
$lesson_start[2] = $lesson_date." 09:45";
$lesson_start[3] = $lesson_date." 10:45";
$lesson_start[4] = $lesson_date." 11:45";
$lesson_start[5] = $lesson_date." 13:20";
//---------------------------------------------------------------------------------------------------//
//生徒情報の取得
//---------------------------------------------------------------------------------------------------//
$sql = "SELECT A.name,A.grade,A.class,A.name_num,A.school_type,A.course ";
$sql.= " ,B.lesson1,B.lesson2,B.lesson3,B.lesson4,B.lesson5 ";
$sql.= "FROM rl_student_tbl A ";
$sql.= "LEFT OUTER JOIN rl_student_lesson_log B ON A.user_id = B.user_id AND B.lesson_date = '".$lesson_date."' ";
$sql.= "WHERE 1=1 AND A.user_id = '".$user_id."'";
$stmt = $dbh->query($sql);
while($row = $stmt -> fetch(PDO::FETCH_ASSOC)) {
$name = $row["name"];
$grade = $row["grade"];
$course = $row["course"];
$class = $row["class"];
$name_num = $row["name_num"];
$school_type = $row["school_type"];
$lesson[1] = $row["lesson1"];
$lesson[2] = $row["lesson2"];
$lesson[3] = $row["lesson3"];
$lesson[4] = $row["lesson4"];
$lesson[5] = $row["lesson5"];
}
if($school_type == "junior"){ $tmp_grade = "中学".$grade."年生";}else if($school_type == "senior"){$tmp_grade = "高校".$grade."年生";}
$grade_course = $tmp_grade." ".$course;
//---------------------------------------------------------------------------------------------------//
//時間割情報の取得
//---------------------------------------------------------------------------------------------------//
$sql = "SELECT * ";
$sql.= "FROM rl_lesson_tbl ";
$sql.= "WHERE 1=1 AND lesson_date = '".$lesson_date."' AND school_type='".$school_type."' AND grade='".$grade."' ";
if($school_type == "senior"){
$sql.= "AND course='".$course."' ";
}
$stmt = $dbh->query($sql);
while($row = $stmt -> fetch(PDO::FETCH_ASSOC)) {
$teacher_zoom = $row["teacher_zoom"];
$hr_zoom = $row["hr_zoom"];
$hr2_zoom = $row["hr2_zoom"];
$l_subject[1] = $row["l1_subject"];
$l_memo[1] = $row["l1_memo"];
$l_movie_title[1] = $row["l1_movie_title"];
$l_movie_url[1] = $row["l1_movie_url"];
$l_movie_title2[1] = $row["l1_movie_title2"];
$l_movie_url2[1] = $row["l1_movie_url2"];
$l_movie_title3[1] = $row["l1_movie_title3"];
$l_movie_url3[1] = $row["l1_movie_url3"];
$l_subject[2] = $row["l2_subject"];
$l_memo[2] = $row["l2_memo"];
$l_movie_title[2] = $row["l2_movie_title"];
$l_movie_url[2] = $row["l2_movie_url"];
$l_movie_title2[2] = $row["l2_movie_title2"];
$l_movie_url2[2] = $row["l2_movie_url2"];
$l_movie_title3[2] = $row["l2_movie_title3"];
$l_movie_url3[2] = $row["l2_movie_url3"];
$l_subject[3] = $row["l3_subject"];
$l_memo[3] = $row["l3_memo"];
$l_movie_title[3] = $row["l3_movie_title"];
$l_movie_url[3] = $row["l3_movie_url"];
$l_movie_title2[3] = $row["l3_movie_title2"];
$l_movie_url2[3] = $row["l3_movie_url2"];
$l_movie_title3[3] = $row["l3_movie_title3"];
$l_movie_url3[3] = $row["l3_movie_url3"];
$l_subject[4] = $row["l4_subject"];
$l_memo[4] = $row["l4_memo"];
$l_movie_title[4] = $row["l4_movie_title"];
$l_movie_url[4] = $row["l4_movie_url"];
$l_movie_title2[4] = $row["l4_movie_title2"];
$l_movie_url2[4] = $row["l4_movie_url2"];
$l_movie_title3[4] = $row["l4_movie_title3"];
$l_movie_url3[4] = $row["l4_movie_url3"];
$l_subject[5] = $row["l5_subject"];
$l_memo[5] = $row["l5_memo"];
$l_movie_title[5] = $row["l5_movie_title"];
$l_movie_url[5] = $row["l5_movie_url"];
$l_movie_title2[5] = $row["l5_movie_title2"];
$l_movie_url2[5] = $row["l5_movie_url2"];
$l_movie_title3[5] = $row["l5_movie_title3"];
$l_movie_url3[5] = $row["l5_movie_url3"];
$other_memo = $row["other_memo"];
$other_movie_title = $row["other_movie_title"];
$other_movie_url = $row["other_movie_url"];
$other_movie_title2 = $row["other_movie_title2"];
$other_movie_url2 = $row["other_movie_url2"];
$other_movie_title3 = $row["other_movie_title3"];
$other_movie_url3 = $row["other_movie_url3"];
$other_movie_title4 = $row["other_movie_title4"];
$other_movie_url4 = $row["other_movie_url4"];
$other_movie_title5 = $row["other_movie_title5"];
$other_movie_url5 = $row["other_movie_url5"];
$other_movie_title6 = $row["other_movie_title6"];
$other_movie_url6 = $row["other_movie_url6"];
}
}
catch(PDOException $e){
print('ERROR:'.$e->getMessage());
exit;
}
?>
家庭動画学習時間割