/
home
/
efamember
/
domains
/
efa-member.com
/
public_html
/
backoffice
/
ajax
/
setting_slide
/
up file
home
<?php session_start(); include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); $sql_slide = "SELECT * FROM tbl_setting_slide ORDER BY create_datetime DESC;"; $rs_slide = mysqli_query($connection, $sql_slide) or die($connection->error); $list_slide = []; while ($row_slide = mysqli_fetch_assoc($rs_slide)) { $temp_array = array( "slide_image" => $row_slide['slide_image'], "create_datetime" => $row_slide['create_datetime'], "slide_link" => $row_slide['slide_link'], "active_status" => $row_slide['active_status'], "slide_member_level" => $row_slide['slide_member_level'], "slide_id" => $row_slide['slide_id'], ); array_push($list_slide, $temp_array); } ?> <!-- <div class="row"> <div class="col-md-12 col-sm-12 mt-1"> <button type="button" class="btn btn-info btn-sm m-t-n-xs mr-1" id="ShowButton" onclick="ShowButtonSet();"><i class="fa fa-cogs"></i> ตั้งค่าจัดลำดับ</button> <button type="button" class="btn btn-info btn-sm m-t-n-xs mr-1" id="HideButton" onclick="HideButtonSet();" style="display: none;"><i class="fa fa-reply"></i> ยกเลิกจัดลำดับ</button> <button type="button" class="btn btn-warning btn-sm m-t-n-xs mr-1" id="SortButton" onclick="SortData();" style="display: none;"><i class="fa fa-retweet"></i> จัดลำดับ</button> </div> <div class="col-md-12 col-sm-12"> <div class="hr-line-dashed mt-3 pt-1"></div> </div> </div> --> <div class="table-responsive"> <table class="table table-striped dataTables-example table-bordered"> <thead> <tr> <th width="1%">#</th> <th style="width: 10%;">วันที่</th> <th class="text-center">รูปภาพ Slide </th> <th>ลิงค์</th> <th class="text-center">ระดับการมองเห็น </th> <th class="text-center">สถานะ</th> </tr> </thead> <tbody> <?php $i = 0; foreach ($list_slide as $row_slide) { $i++; switch ($row_slide['slide_member_level']) { case 1: $level = "เห็นทั้งหมด"; break; case 2: $level = "สมาชิกเท่านั้น"; break; case 3: $level = "สมาชิกสามัญ ขึ้นไป"; break; case 4: $level = "สมาชิกวิสามัญ ขึ้นไป"; break; case 5: $level = "สมาชิกกิตติมศักดิ์"; break; } ?> <tr id="tr_<?php echo $row_slide['slide_id']; ?>" class="tr_move"> <input type="hidden" name="slide_id[]" value="<?php echo $row['slide_id']; ?>"> <td><?php echo $i; ?></td> <td style="width: 10%;"><?php echo date('d/m/Y H:i', strtotime($row_slide['create_datetime'])); ?></td> <td class="text-center" style="width: 10%;"><a href="../../../files/slide_files/<?php echo $row_slide['slide_image']; ?>" target="_blank"><img src="../../../files/slide_files/<?php echo $row_slide['slide_image']; ?>" alt="" style="width: 150px;"></a></td> <td><a href="<?php echo $row_slide['slide_link']; ?>"></a></td> <td class="text-center"><?php echo $level; ?></td> <td style="text-align: center;"> <button class="btn btn-sm btn-<?php echo ($row_slide['active_status'] == '1') ? 'success' : 'warning' ?> mb-3" type="button" onclick="Changestatus('<?php echo $row_slide['slide_id']; ?>');"><?php echo ($row_slide['active_status'] == '1') ? 'ใช้งาน' : '' ?></button> <button class="btn btn-sm btn-danger mb-3" type="button" onclick="Delete('<?php echo $row_slide['slide_id']; ?>');">ลบ</button> </td> </tr> <?php } ?> </tbody> </table> </div> <script> </script>