R E D

NAME	SIZE	PERMISSION
index.js	24.82 KB	-rwxr-xr-x
index.php	11.18 KB	-rwxr-xr-x
index_bak.js	24.23 KB	-rwxr-xr-x
index_bak.php	3.79 KB	-rwxr-xr-x

Code Editor : index.php

<?php require_once("page/nav.php") ?>
<?php require_once("page/sidebar.php") ?>
<?php
// get couse data
$couse_id = $_GET['id'];
$sql = "SELECT * FROM `couse` WHERE `ID` = '$couse_id'";
$result = $db->query($sql);
$row = $result->fetch(PDO::FETCH_ASSOC);
$lesson = "SELECT * FROM `lesson` WHERE `couseID` = '$couse_id'";
$result_lesson = $db->query($lesson);

?>
<link rel="stylesheet" href="page/Addcouse/index.css">
<div class="container-fluid p-0 m-0">
    <div class="body-content">
        <div class="header-text">
            <h3 class="text-muted">เเก้ไขข้อมูล - <?php echo $row['Unitname'] ?></h3>
        </div>
        <input type="hidden" id="UnitID" value="<?php echo $couse_id ?>">
        <input type="hidden" id="UnitImgTitleOri" value="<?php echo $row['filetitle'] ?>">
        <input type="hidden" id="UnitValueOri" value="<?php echo $row['value'] ?>">
        <div class="form">
            
            
            <div class="header-title">
                <input type="text" class="inp-tran form-control" id="Unitname" placeholder="ชื่อคอร์สเรียน" value="<?php echo $row['Unitname'] ?>">
                <p class="mb-0  mt-3 text-muted">รายละเอียด :</p>
                <textarea oninput="auto_grow(this)" class="form-control" id="Unitdetail"><?php echo $row['detail'] ?></textarea>
            </div>

<div class="image-content">
                <p class="mb-0  mt-3 text-muted">รูปภาพหน้าปก : <input class="" type="file" id="img-title"></p>
                <div class="img-pre">
                    <img src="<?php echo $row['filetitle'] ?>" width="600">
                </div>
                <p class="mb-0  mt-3 text-muted">สื่อประกอบ :</p>
                <div class="list">
                    <div class="radio">
                        <div class="form-check">
                            <input class="form-check-input" type="radio" name="flexRadioDefault" id="radio-type" value="video"
                                onclick="change('video',this)" <?php echo ($row['detailType'] == 'video') ? 'checked' : null?>>
                            <label class="form-check-label" for="flexRadioDefault1">
                                VDO
                            </label>
                        </div>
                        <div class="form-check">
                            <input class="form-check-input" type="radio" name="flexRadioDefault" id="radio-type" value="img"
                                onclick="change('img')" <?php echo ($row['detailType'] == 'img') ? 'checked' : null?>>
                            <label class="form-check-label" for="flexRadioDefault2">
                                รูปภาพ
                            </label>
                        </div>
                        <div class="form-check">
                            <input class="form-check-input" type="radio" name="flexRadioDefault" id="radio-type" value="docs"
                                onclick="change('docs')" <?php echo ($row['detailType'] == 'docs') ? 'checked' : null?>>
                            <label class="form-check-label" for="flexRadioDefault3">
                                Link เอกสาร
                            </label>
                        </div>
                    </div>
                </div>
                <div class="inp-frame" id="frame-inp">
                    
                </div>
                <div class="preview" id="preview">
                    <?php if($row['detailType'] == 'img'){?>
                        <img src="<?php echo $row['value'] ?>" width="500">
                    <?php } if($row['detailType'] == 'video'){?>
                        <input type="text" placeholder="ระบุ ID video youtube" class="form-control" id="img-detail" value="<?php echo $row['value']?>">
                    <?php } if($row['detailType'] == 'docs'){?>
                        <input type="url" placeholder="ระบุ url ของ เอกสาร" class="form-control" id="img-detail" value="<?php echo $row['value']?>">
                    <?php } ?>
                </div>
            </div>
            <div class="Unit-form-edit">
                <?php 
                    if($result_lesson->execute()){
                    while ($row2 = $result_lesson->fetch(PDO::FETCH_ASSOC)) {
                ?>
                    <div class="card mb-3" data-id="<?php echo $row2['ID'];?>" id="Unit">
                        <div class="card-header">
                            <input type="text" id="BigUnit-name" data-id="<?php echo $row2['ID'];?>" class="form-control inp-couse"
                                placeholder="บทเรียนไม่มีชื่อ" value="<?php echo $row2['name'];?>">
                        </div>
                        <div class="card-body">
                            <?php 
                            $unit = "SELECT * FROM `unit`INNER JOIN dataunit ON dataunit.ID = unit.unitID WHERE unit.lsnid = '".$row2['ID']."'";
                            $result_unit = $db->query($unit);
                            if($result_unit->execute()){
                            $i = 0;
                            while ($row3 = $result_unit->fetch(PDO::FETCH_ASSOC)) {
                            ?>
                                <div class="accord-list2" data-id="<?php echo $i;?>">
                                    <div class="accordion-item" data-id="<?php echo $i;?>" data-unit="<?php echo $row3['ID'];?>" id="accord">
                                        <h2 class="accordion-header" id="heading-<?php echo $row3['ID'];?>-<?php echo $i;?>">
                                            <input type="text" id="title-unit" data-id="<?php echo $i;?>" data-unit="<?php echo $row3['ID'];?>" class="form-control inp-couse" placeholder="เนื้อหาไม่มีชื่อ" value="<?php echo $row3['name'];?>">
                                            <button class="btn-tran btn-red" data-id="<?php echo $i;?>" data-unit="<?php echo $row3['ID'];?>" id="sub-del"><i class="fa-solid fa-circle-minus"></i></button>
                                            <button class="accordion-button " type="button"  data-bs-toggle="collapse"data-bs-target="#collapse-<?php echo $row3['ID'];?>-<?php echo $i;?>" aria-expanded="true" aria-controls="collapse-<?php echo $row3['ID'];?>-<?php echo $i;?>"></button>
                                        </h2>
                                        <div id="collapse-<?php echo $row3['ID'];?>-<?php echo $i;?>" class="accordion-collapse collapse show" aria-labelledby="heading-<?php echo $row3['ID'];?>-<?php echo $i;?>"
                                            data-bs-parent="#accordionExample">
                                            <div class="accordion-body">
                                                <div class="inp">
                                                <input type="text"  id="video-unit" data-id="<?php echo $i;?>" data-unit="<?php echo $row3['ID'];?>" class="form-control" placeholder="URL iframe youtube" value="<?php echo $row3['video'];?>">
                                                <div class="preview" data-id="<?php echo $i;?>" id="iframe-preview"></div>
                                            </div>
                                            <div class="role">
                                                
                                                
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <?php } }?>
                        </div>
                    </div>
                <?php } }?>
            </div>

<div class="tool-menu">
                <ul>
                    <li><button id="Add-unit" class="btn-tran" type="button">
                            <i class="fa-solid fa-plus"></i>
                            เพิ่มบทเรียน
                        </button>
                    </li>
                </ul>
            </div>
            <div class="role">
                <?php if($row['status'] == 200){
                    $status = 'checked';
                } else {
                    $status = null;
                }?>
                <div class="switch">
                    <p>แสดงคอร์สเรียน :</p>
                    <div class="form-check form-switch">
                        <input class="form-check-input" type="checkbox" id="status-couse" <?php echo $status;?>>
                    </div>
                </div>
            </div>
            <div class="d-grid gap-2 col-6 mx-auto">
                <button class="btn btn-primary" id="UpdateUnit" type="button">แก้ไขคอร์สเรียน</button>
            </div>
            
        </div>
    </div>
</div>

${this.title}

Code Editor : index.php