/
home
/
efamember
/
domains
/
efa-member.com
/
public_html
/
backoffice
/
ajax
/
setting_blog
/
up file
home
<?php session_start(); include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); $sql_slide = "SELECT * FROM tbl_setting_blog 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( "blog_image" => $row_slide['blog_image'], "create_datetime" => $row_slide['create_datetime'], "blog_message" => $row_slide['blog_message'], "blog_header" => $row_slide['blog_header'], "active_status" => $row_slide['active_status'], "blog_member_level" => $row_slide['blog_member_level'], "blog_id" => $row_slide['blog_id'], ); array_push($list_slide, $temp_array); } ?> <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">รูปภาพประกอบ </th> <th>หัวข้อบทความ</th> <th class="text-center">ระดับการมองเห็น </th> <th style="width: 10%;" class="text-center">สถานะ</th> </tr> </thead> <tbody> <?php $i = 0; foreach ($list_slide as $row_slide) { $i++; switch ($row_slide['blog_member_level']) { case 1: $level = "เห็นทั้งหมด"; break; case 2: $level = "สมาชิกเท่านั้น"; break; case 3: $level = "สมาชิกสามัญ ขึ้นไป"; break; case 4: $level = "สมาชิกวิสามัญ ขึ้นไป"; break; case 5: $level = "สมาชิกกิตติมศักดิ์"; break; } ?> <tr> <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/blog_files/<?php echo $row_slide['blog_image']; ?>" target="_blank"><img src="../../../files/blog_files/<?php echo $row_slide['blog_image']; ?>" alt="" style="width: 150px;"></a></td> <td><?php echo $row_slide['blog_header']; ?></td> <!-- <td><?php echo $row_slide['blog_message']; ?></td> --> <td class="text-center"><?php echo $level; ?></td> <td style="text-align: center;"> <?php if ($row_slide['active_status'] == '1') { ?> <button class="btn btn-sm btn-primary w-100 mb-2" type="button" onclick="Changestatus('<?php echo $row_slide['blog_id']; ?>');">ใช้งาน</button> <?php } else if ($row_slide['active_status'] == '0') { ?> <button class="btn btn-sm btn-danger w-100 mb-2" type="button" onclick="Changestatus('<?php echo $row_slide['blog_id']; ?>');">ปิด</button> <?php } ?> <button class="btn btn-sm btn-warning w-100 mb-2" type="button" onclick="EditContent('<?php echo $row_slide['blog_id']; ?>');">แก้ไข</button> <button class="btn btn-sm btn-danger w-100 mb-2" type="button" onclick="DeleteContent('<?php echo $row_slide['blog_id']; ?>');">ลบ</button> </td> </tr> <?php } ?> </tbody> </table> </div> <script> </script>