R E D

NAME	SIZE	PERMISSION
index.css	4.07 KB	-rwxr-xr-x
index.js	0 B	-rwxr-xr-x
index.php	8.06 KB	-rwxr-xr-x
index_bak.php	7.85 KB	-rwxr-xr-x

Code Editor : index_bak.php

<?php require_once("page/nav.php") ?>
<?php require_once("page/sidebar.php") ?>
<?php
// get lesson from couse
$id = $_SESSION['lms-ID'];
$cid = $_GET['id'];
$brr = [];
$book = $db->prepare("SELECT cid FROM bookcouse where student = $id and cid=$cid");
$book->execute();

$select_smtp = $db->prepare("SELECT * FROM couse where ID =$cid");
$select = $db->prepare("SELECT avatar, name FROM user where ID = '$id' AND verify = '200'");
$select_row = $db->prepare("SELECT count(ID) FROM couse  ");

if ($select_row->execute()) {

$lesson = $db->prepare("SELECT * FROM lesson where couseID=$cid");
    $lesson->execute();
    $lsn = array();
    while ($lrow = $lesson->fetch(PDO::FETCH_ASSOC)) {
        extract($lrow);
        $lsn[] = $lrow;
    }
    $sel_unit = $db->prepare("SELECT * FROM unit where type='unit' and  couseID=$cid");
    $sel_unit->execute();
    $urr  = array();
    $dkey = array();
    while ($urow = $sel_unit->fetch(PDO::FETCH_ASSOC)) {
        extract($urow);
        $urr[$urow['lsnid']][] = $urow;
        $dkey[] = $urow['unitID'];
    }
    if (is_array($dkey)) {
        $did = ' and ID in (' . implode(',', $dkey) . ')';
    } else {
        $did = "";
    }

$sel_dataunit = $db->prepare("SELECT * FROM dataunit where 1=1 $did");
    $sel_dataunit->execute();
    $drr = array();
    while ($drow = $sel_dataunit->fetch(PDO::FETCH_ASSOC)) {
        $drr[$drow['ID']] = $drow;
    }

if ($select_smtp->execute() && $select->execute()) {
        $arr = array();
        $user = $select->fetch(PDO::FETCH_ASSOC);
        while ($row = $select_smtp->fetch(PDO::FETCH_ASSOC)) {
            extract($row);
            array_push($arr, array("user" => $user, "couse" => $row, "lesson" => $lsn, "unit" => $urr, "dtunit" => $drr));
        }
    }

$isTest = 0;
    $select_before_test = $db->query("SELECT * FROM `user_answers` WHERE `couse` = '$cid' AND `user_id` = '" . $id . "' and `type_quiz` = 'before' ");
    $isTest = $select_before_test->rowCount();
}
?>
<link rel="stylesheet" href="page/StudyCouse/index.css">
<div class="container-fluid p-0 m-0">
    <div class="body-content">
        <div class="header-text">
            <p class="text-danger"><a href="ViewsCouse"> <- กลับไปหน้าการเรียนรู้</a></p>
        </div>
        <div>
  <h1>บทเรียน - <?php echo $arr[0]['couse']['Unitname']; ?></h1>

<div class="row">
    <div class="col">
      
        <?php if($arr[0]['couse']['detailType'] == 'video'){
          $url = $arr[0]['couse']['value'];
          parse_str( parse_url( $url, PHP_URL_QUERY ), $url_sub );
          ?>
          <button class="btn btn-success" onclick="playVideo('<?php echo $url_sub['v']; ?>')">
            คลิกเพื่อเรียน
          </button>
        <?php } if($arr[0]['couse']['detailType'] == 'docs'){?>
          <a href="<?php echo $arr[0]['couse']['value'];?>" class="btn btn-success" target="_blank">
            คลิกเพื่อเรียน
        </a>
        <?php } ?>
    </div>
    <div class="col-md-auto">

<div class="tab-content" id="myTabContent">
  
    
</div>
    </div>
    
  </div>

<hr>

<?php if ($isTest > 0 ) { ?>
  <a class="btn btn-primary" href="Quiz?id=<?php echo $arr[0]['couse']['ID']; ?>&type=after" role="button">ทดสอบหลังเรียน</a>
<?php } ?>

</div>

<div class="modal fade" id="videoModal" tabindex="-1" role="dialog" aria-labelledby="videoModalLabel" aria-hidden="true">
  <div class="modal-dialog modal-lg" role="document">
    <div class="modal-content">
    <div id="player" class="embed-responsive embed-responsive-16by9"></div>
    </div>
  </div>
</div>
<button class="btn-upper">
    <i class="fa-solid fa-chevron-up"></i>
</button>

<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
<script src="https://www.youtube.com/player_api"></script>

function playVideo(videoId) {

var videoUrl = 'https://www.youtube.com/embed/' + videoId + '?autoplay=1';
  
  var playerHtml = '<iframe width="100%" height="500px" src="' + videoUrl + '" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>';
  
  document.getElementById('player').innerHTML = playerHtml;

$('#videoModal').modal('show');
}

$('#videoModal').on('shown.bs.modal', function () {
  var player = new YT.Player('videoPlayer', {
    events: {
      'onStateChange': function (event) {
        if (event.data == YT.PlayerState.ENDED) {
          $('#videoModal').modal('hide');
        }
      }
    }
  });
});
</script>

.modal-body {
  flex-grow: 1;
}

.modal-header,
.modal-footer {
  margin: 0;
}

.modal-header {
  margin-top: 1rem;
}

</style>

${this.title}

Code Editor : index_bak.php