Viewing file:  home.php (8.88 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include 'index_IncludeAdmin.php';
$_SESSION['page'] = 'home.php';
$pagecontent_SL = " SELECT * FROM pagecontent WHERE pagecontent_name = 'home'";
$pagecontent_QR = mysqli_query($con,$pagecontent_SL);
$pagecontent = mysqli_fetch_array($pagecontent_QR);
if ($_POST['pagecontent_update']) {
$pagecontent_review = $_POST['pagecontent_review'];
$pagecontent_id = $_POST['pagecontent_id'];
$pagecontent_Update = "UPDATE `pagecontent` SET `pagecontent_review` = '$pagecontent_review' WHERE `pagecontent_id` = '$pagecontent_id'";
$pagecontent_Reult = mysqli_query($con,$pagecontent_Update);
if($pagecontent_Reult) {
echo"<script> window.location='$pagecontent[pagecontent_name].php?UPDATE'; </script>";
}
else{
echo"<script>alert(' เกิดข้อผิดพลาดแจ้งผู้ดูแล '); window.history.back(); </script>";
}
}
if ($_POST['pagecontent_photo_update']) {
if($_FILES['pagecontent_photo']['name']!=''){
@unlink("../Files/pagecontent_photo/".$pagecontent['pagecontent_photo']);
$Jpg = strrchr($_FILES["pagecontent_photo"]["name"],".");
$pagecontent_photo = rand().rand().$Jpg;
$upload = move_uploaded_file($_FILES["pagecontent_photo"]["tmp_name"],"../Files/pagecontent_photo/".$pagecontent_photo);
$pagecontent_photo_Update = "UPDATE `pagecontent` SET `pagecontent_photo` = '$pagecontent_photo' WHERE `pagecontent_id` = '$pagecontent[pagecontent_id]'";
$pagecontent_photo_Reult = mysqli_query($con,$pagecontent_photo_Update);
if (!$pagecontent_photo_Reult) {
echo"<script>alert('เกิดข้อผิดพลาด'); window.history.back(); </script>";
}
if ($pagecontent_photo_Reult) {
echo"<script> window.location='home.php?UPDATE'; </script>";
}
}
}
if ($_GET[pagecontent_photo_update]=='delete') {
@unlink("../Files/pagecontent_photo/".$pagecontent['pagecontent_photo']);
$pagecontent_photo_Update = "UPDATE `pagecontent` SET `pagecontent_photo` = '' WHERE `pagecontent_id` = '$pagecontent[pagecontent_id]' ";
$pagecontent_photo_Reult = mysqli_query($con,$pagecontent_photo_Update);
echo"<script>alert('แก้ไขเรียบร้อยแล้ว'); window.location='home.php?update';</script>";
}
?>
<!DOCTYPE html>
<html>
<head>
<? include 'index_Head.php'; ?>
<style type="text/css">
@media (min-width:991px){
.modal-lg {
width: 80%;
}
}
</style>
</head>
<body>
<? include 'index_Navbar.php'; ?>
<div class="container-fluid">
<div class="row">
<div class="col-md-2" id="main-left">
<div class="row">
<div class="col-md-12">
<? include 'index_AdminMenu.php'; ?>
</div>
</div>
</div>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<h3> จัดการ <? echo $pagecontent[pagecontent_topic]; ?> </h3>
<hr>
</div>
</div>
<? include 'index_Alerts.php'; ?>
<div class="row">
<div class="col-md-12 top-margin2">
<div class="panel panel-default">
<div class="panel-heading">
<div class="row" >
<div class="col-md-12">
หน้าเพจ,เนื้อหา : <span class="text-primary"> <? echo $pagecontent[pagecontent_topic]; ?> </span>
<button type="button" class="btn btn-info" style="margin-top: -5px; margin-bottom: -5px;" data-toggle="modal" data-target="#pagecontent_update<?php echo $pagecontent[pagecontent_id]; ?>">
<span class="glyphicon glyphicon-edit"></span>
แก้ไข
</button>
</div>
</div>
</div>
<div class="panel-body">
<? echo $pagecontent[pagecontent_review]; ?>
</div>
<div id="pagecontent_update<?php echo $pagecontent[pagecontent_id]; ?>" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel">
<div class="modal-dialog modal-lg" role="document">
<div class="modal-content">
<form action="" method="post" encType="multipart/form-data">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="exampleModalLabel"> แก้ไข หน้าเพจ,เนื้อหา :
<span class="text-primary">
<? echo $pagecontent[pagecontent_topic]; ?>
</span>
</h4>
</div>
<div class="modal-body">
<div class="form-group">
<textarea name="pagecontent_review" class="ckeditor"><? echo $pagecontent[pagecontent_review]; ?></textarea>
</div>
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-info">
<span class="glyphicon glyphicon-floppy-disk"></span> บันทึกการแก้ไข
</button>
<input Type="hidden" name="pagecontent_update" value="x">
<input Type="hidden" name="pagecontent_id" value="<?php echo $pagecontent[pagecontent_id]; ?>">
<button type="button" class="btn btn-default" data-dismiss="modal">ยกเลิก</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- 12 -->
<div class="col-md-12 br-margin2">
<div class="panel panel-default">
<div class="panel-heading">
รูปภาพ banner หน้าแรก
<button type="button" class="btn btn-info " data-toggle="modal" data-target="#pagecontent_photo_update">
<span class="glyphicon glyphicon-picture"></span>
แก้ไขรูปภาพ banner
</button>
<div id="pagecontent_photo_update" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<form class="form" enctype="multipart/form-data" method="post">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="exampleModalLabel">แก้ไขรูปภาพ banner หน้าแรก </h4>
</div>
<div class="modal-body">
<div class="form-group">
<label for="recipient-name" class="control-label">เลือกรูปภาพ <span class="text-muted normal">เป็นรูปภาพที่จะนำมาแทนรูปเดิม</span></label>
<input type="file" required class="form-control" multiple="multiple" name="pagecontent_photo">
</div>
</div>
<div class="modal-footer">
<button onclick="return confirm('ยืนยันการแก้ไข ? ')" type="submit" class="btn btn-success">
<span class="glyphicon glyphicon-floppy-disk"></span> บันทึกการแก้ไข
</button>
<input type="hidden" name="pagecontent_photo_update" value="x">
<a href="home.php?pagecontent_photo_update=delete" onclick="return confirm(' ยืนยันการลบข้อมูล ? ')" class="btn btn-danger">
<span class="glyphicon glyphicon-edit"></span>
ลบรูป
</a>
<button type="button" class="btn btn-default" data-dismiss="modal">ยกเลิก</button>
</div>
</form>
</div>
</div>
</div>
</div>
<div class="panel-body">
<?
if (isset($pagecontent[pagecontent_photo])&&trim($pagecontent[pagecontent_photo])!='') {
?>
<img class="full" style="cursor: zoom-in;" id="myImgmain<?php echo $pagecontent[pagecontent_id]; ?>" src="../Files/pagecontent_photo/<?php echo $pagecontent[pagecontent_photo]; ?>" />
<div id="myModal" class="w3-modal">
<span class="zoom-close w3-close">×</span>
<img class="w3-modal-content w3-close" id="img01">
</div>
<script>
var w3modal = document.getElementById("myModal");
var img = document.getElementById("myImgmain<?php echo $pagecontent[pagecontent_id]; ?>");
var modalImg = document.getElementById("img01");
img.onclick = function(){
w3modal.style.display = "block";
modalImg.src = this.src;
}
var span = document.getElementsByClassName("w3-close")[0];
span.onclick = function() {
w3modal.style.display = "none";
}
window.onclick = function(event) {
if (event.target == w3modal) {
w3modal.style.display = "none";
}
}
</script>
<?
}
else{
echo "-";
}
?>
</div>
</div>
</div>
</div>
<!-- row -->
</div>
<!-- 10 -->
</div>
<!-- row -->
</div>
<!-- container -->
</body>
</html>
|