Viewing file:  news_form_edit.php (12.47 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
ob_start();
session_start();
if(!$_SESSION['fullname']){
header("location: index.php");
}
require_once ('includes/db.php');
$r_id=$_GET['r_id'];
if(isset($_POST['submitform'])){
//$datenow=date("Y-m-d");
$homename=$_POST['homename'];
$detail=$_POST['detail'];
if (!empty($_FILES["inputfiles"]["name"])){
$images = $_FILES["inputfiles"]["tmp_name"];
$file = strtolower($_FILES["inputfiles"]["name"]);
//$sizefile = $_FILES["inputfile"]["size"];
$datefile=date("YmdHis");
$type= strrchr($file,".");
$new_images = "thumbnails_".mt_rand(10,9999).$datefile;
//copy($_FILES["inputfile"]["tmp_name"],"uploads/".$_FILES["inputfile"]["name"]);
$width=800; //*** Fix Width & Heigh (Autu caculate) ***//
$size=GetimageSize($images);
$height=round($width*$size[1]/$size[0]);
$images_orig = ImageCreateFromJPEG($images);
$photoX = ImagesX($images_orig);
$photoY = ImagesY($images_orig);
$images_fin = ImageCreateTrueColor($width, $height);
ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width+1, $height+1, $photoX, $photoY);
ImageJPEG($images_fin,"uploadphoto/Thumbnails/".$new_images.$type);
ImageDestroy($images_orig);
ImageDestroy($images_fin);
@unlink("uploadphoto/Thumbnails/".$_POST["oldfile"]);
}else
{
$file= $_POST["oldfile"];
$file = strtolower($file);
$type= strrchr($file,".");
$exp = explode('.' , $file);
$new_images = substr($file , 0 , -(strlen($exp[count($exp)-1])+1));
}
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "UPDATE cat_news SET home_name ='$homename', detail ='$detail',thumbnail='$new_images$type' WHERE cat_id = '$r_id' ";
$stmt = $conn->prepare($sql);
$stmt->execute();
header( "location: news_dashboard.php" );
exit(0);
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Admin Dashboard : Automation Software</title>
<meta charset="utf-8">
<meta content="ie=edge" http-equiv="x-ua-compatible">
<meta content="template language" name="keywords">
<meta content="Autosoft" name="author">
<meta content="Admin dashboard Autosoft" name="description">
<meta content="width=device-width, initial-scale=1" name="viewport">
<link href="img/favicon_autosoft.png" rel="shortcut icon">
<link href="https://fonts.googleapis.com/css?family=Rubik:300,400,500" rel="stylesheet" type="text/css">
<link href="bower_components/select2/dist/css/select2.min.css" rel="stylesheet">
<link href="bower_components/bootstrap-daterangepicker/daterangepicker.css" rel="stylesheet">
<link href="bower_components/dropzone/dist/dropzone.css" rel="stylesheet">
<link href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css" rel="stylesheet">
<link href="bower_components/fullcalendar/dist/fullcalendar.min.css" rel="stylesheet">
<link href="bower_components/perfect-scrollbar/css/perfect-scrollbar.min.css" rel="stylesheet">
<link href="bower_components/slick-carousel/slick/slick.css" rel="stylesheet">
<link href="css/main.css?version=4.4.0" rel="stylesheet">
<style>
.file {
visibility: hidden;
position: absolute;
}
</style>
<!--jQuery-->
<script type="text/javascript" src="js/jquery-min.js"></script>
<script type="text/javascript" src="js/jquery.filer.min.js?v=1.0.5"></script>
<script type="text/javascript" src="js/custom.js?v=1.0.5"></script>
<style>
body {
font-family: 'Prompt', sans-serif;
font-size: 14px;
line-height: 1.42857143;
color: #333;
background-color: #fff;
margin: 0;
padding: 20px;
}
hr {
margin-top: 20px;
margin-bottom: 20px;
border: 0;
border-top: 1px solid #eee;
}
#content {
width: 77%;
}
</style>
<style type="text/css">
.require{
font-family: 'Prompt', sans-serif;
color:#FF0000;
font-size:12px;
text-align:left;
}
</style>
</head>
<body class="menu-position-side menu-side-left full-screen">
<div class="all-wrapper solid-bg-all">
<div class="layout-w">
<!--------------------
START - Mobile Menu
-------------------->
<?php //include ('includes/mobile_menu.php'); ?>
<!--------------------
START - Main Menu
-------------------->
<?php include ('includes/main_menu.php'); ?>
<!--------------------
END - Main Menu
-------------------->
<div class="content-w">
<!--------------------
START - Top Bar
-------------------->
<?php include('includes/top_setting.php'); ?>
<!--------------------
END - Top Bar
-------------------->
<div class="content-i">
<div class="content-box"><div class="row">
<div class="col-lg-12">
<div class="element-wrapper">
<div class="element-box">
<form action="#" method="POST" enctype="multipart/form-data">
<h5 class="form-header">
ข่าวประชาสัมพันธ์ : PhbCoop
</h5>
<div class="form-desc">
ลงข้อมูล เกี่ยวกับข่าวประชาสัมพันธ์
</div>
<?php
$result1 = $conn->prepare("SELECT * FROM cat_news WHERE cat_id=$r_id");
$result1->execute();
for($i=0; $row1 = $result1->fetch(); $i++ ){
?>
<div class="form-group">
<label for="title" class="col-sm-2 control-label">ชื่อเรื่อง :</label>
<div class="col-sm-8">
<input type="text" autocomplete="off" name="homename" class="form-control" id="homeid" Value="<?php echo $row1['home_name']; ?>">
</div>
</div>
<div class="mt-3 col-sm-8">
<div class="ml-2 col-sm-6">
<img src="uploadphoto/Thumbnails/<?php echo $row1['thumbnail']; ?>" id="preview" class="img-thumbnail">
</div>
<input type="file" name="inputfiles" class="file" accept="image/*">
<input type="hidden" name="oldfile" value="<?php echo $row1["thumbnail"];?>">
<div class="input-group my-3">
<input type="text" class="form-control" disabled placeholder="Upload File" id="file">
<div class="input-group-append">
<button type="button" class="browse btn btn-primary">Browse...</button>
</div>
</div>
</div>
<div class="form-group">
<label for="detail" class="col-sm-2 control-label">รายละเอียด :</label>
<div class="col-sm-8">
<textarea name="detail" cols="8" rows="4" class="form-control" id="detail"><?php echo $row1['detail']; ?> </textarea>
</div>
</div>
<div class="form-group">
<div class="col-sm-8">
<input type="submit" name="submitform" value="แก้ไขข้อมูล" class="btn btn-success">
</div>
</div>
<?php } ?>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="display-type"></div>
</div>
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<script src="bower_components/popper.js/dist/umd/popper.min.js"></script>
<script src="bower_components/moment/moment.js"></script>
<script src="bower_components/chart.js/dist/Chart.min.js"></script>
<script src="bower_components/select2/dist/js/select2.full.min.js"></script>
<script src="bower_components/jquery-bar-rating/dist/jquery.barrating.min.js"></script>
<script src="bower_components/ckeditor/ckeditor.js"></script>
<script src="bower_components/bootstrap-validator/dist/validator.min.js"></script>
<script src="bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<script src="bower_components/ion.rangeSlider/js/ion.rangeSlider.min.js"></script>
<script src="bower_components/dropzone/dist/dropzone.js"></script>
<script src="bower_components/editable-table/mindmup-editabletable.js"></script>
<script src="bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<script src="bower_components/fullcalendar/dist/fullcalendar.min.js"></script>
<script src="bower_components/perfect-scrollbar/js/perfect-scrollbar.jquery.min.js"></script>
<script src="bower_components/tether/dist/js/tether.min.js"></script>
<script src="bower_components/slick-carousel/slick/slick.min.js"></script>
<script src="bower_components/bootstrap/js/dist/util.js"></script>
<script src="bower_components/bootstrap/js/dist/alert.js"></script>
<script src="bower_components/bootstrap/js/dist/button.js"></script>
<script src="bower_components/bootstrap/js/dist/carousel.js"></script>
<script src="bower_components/bootstrap/js/dist/collapse.js"></script>
<script src="bower_components/bootstrap/js/dist/dropdown.js"></script>
<script src="bower_components/bootstrap/js/dist/modal.js"></script>
<script src="bower_components/bootstrap/js/dist/tab.js"></script>
<script src="bower_components/bootstrap/js/dist/tooltip.js"></script>
<script src="bower_components/bootstrap/js/dist/popover.js"></script>
<script src="js/demo_customizer.js?version=4.4.0"></script>
<script src="js/main.js?version=4.4.0"></script>
<script>
$(document).on("click", ".browse", function() {
var file = $(this).parents().find(".file");
file.trigger("click");
});
$('input[type="file"]').change(function(e) {
var fileName = e.target.files[0].name;
$("#file").val(fileName);
var reader = new FileReader();
reader.onload = function(e) {
// get loaded data and render thumbnail.
document.getElementById("preview").src = e.target.result;
};
// read the image file as a data URL.
reader.readAsDataURL(this.files[0]);
});
</script>
<script>
$(document).ready(function(){
if(<?php echo $status; ?>==1) {
$("#Modal_success").modal().on("hidden.bs.modal", function () {
window.location="main_page.php";
});
}
else if(<?php echo $status; ?>==0){
$("#Modal_Fail").modal();
}
});
</script>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','https://www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-XXXXXXX-9', 'auto');
ga('send', 'pageview');
</script>
</body>
</html>
|