| Server IP : 103.233.192.212 / Your IP : 3.137.161.250 Web Server : Apache/2 System : Linux sv1.inde.co.th 3.10.0-1160.36.2.el7.x86_64 #1 SMP Wed Jul 21 11:57:15 UTC 2021 x86_64 User : sumpatuan ( 1058) PHP Version : 5.5.38 Disable Function : symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,putenv,passthru,escapeshellarg,escapeshellcmd,pcntl_exec,proc_get_status,proc_nice,proc_terminate,pclose,ini_alter,virtual,openlog,ini_restore MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/sumpatuan/domains/sumpatuan.go.th/private_html/admin/data/ |
Upload File : |
<?php
require_once('session_backend_administrator.php');
header('Content-Type: text/html; charset=UTF-8');
date_default_timezone_set("Asia/Bangkok");
$datetime = date('d/m/Y H.i');
if($STT_login=="admin_login_true"){
$check_iddata = $con_db_administrator->real_escape_string($_GET['id']);
$check_namedata = $con_db_administrator->real_escape_string($_GET['name']);
if( $check_iddata=="" or !isset($check_iddata) or $check_namedata=="" or !isset($check_namedata) ){
echo "<SCRIPT type='text/javascript'>
alert('ไม่พบข้อมูล ที่ต้องการแก้ไข');
window.location.replace('../index');
</SCRIPT>";
exit;
}else{
$sql_data = "SELECT * , CONCAT( DAY(str_to_date(`lastupdate_village`,'%d/%m/%Y')) ,'/', MONTH(str_to_date(`lastupdate_village`,'%d/%m/%Y')) ,'/', YEAR(str_to_date(`lastupdate_village`,'%d/%m/%Y'))+543 ) AS 'cv_lastupdate_village'
FROM `data_village` WHERE `id_village`='$check_iddata' AND `name_village`='$check_namedata' ";
$qr_data = mysqli_query($con_db_administrator,$sql_data) or die( mysqli_error($con_db_administrator));
$rs_data = mysqli_fetch_assoc($qr_data);
if( empty($rs_data) ){
echo "<SCRIPT type='text/javascript'>
alert('ไม่ข้อมูล ที่ต้องการแก้ไข');
window.location.replace('$check_link');
</SCRIPT>";
exit;
}
}
}else{
echo "<SCRIPT type='text/javascript'>
alert('กรุณาเข้าสู่ระบบ');
window.location.replace('../index');
</SCRIPT>";
exit;
}
?>
<!doctype html>
<html lang="en">
<head>
<?php include_once ("head.html"); ?>
</head>
<body class="" >
<?php include_once ("menu.php"); ?>
<div class="container pt-3 pb-4" >
<div class="row ">
<div class="col text-secondary" >
<div class="p-1 ps-2 box-link " ><a href="../backend-administrator" class="link-info">หน้าหลัก</a> / <a href="VillageMain" class="link-info">จำนวนหมู่บ้านประชากร</a> / แก้ไขข้อมูลหมู่บ้าน</div>
</div>
<div class="w-100 pb-4"></div>
<div class="col m-auto" >
<div class="bg-line-1"></div>
</div>
<div class="col-auto text-center">
<span class="lh-sm h1 fw-700">แก้ไขข้อมูลหมู่บ้าน</span>
</div>
<div class="col m-auto" >
<div class="bg-line-1"></div>
</div>
</div>
<div class="row mt-4 mb-5 pe-2 ps-2">
<div class="col mx-auto box-data p-3 " style="max-width:600px">
<form action="action/save-VillageMain-edit" name='form_VillageMain_adddata' id='form_VillageMain_adddata' method="post" enctype="multipart/form-data">
<input type="hidden" name="edt_oldid" value="<?php echo $rs_data['id_village'];?>">
<div class="row mb-4">
<label class="col-4 col-form-label fw-700 text-end">หมู่ที่</label>
<div class="col-8">
<input type="text" class="form-control " name="edt_id" value="<?php echo $rs_data['id_village'];?>" oninput="this.value = this.value.replace(/\D+/g, '').replace(/^0[^.]/, '0');" maxlength="3" required>
</div>
</div>
<div class="row mb-4">
<label class="col-4 col-form-label fw-700 text-end">ชื่อหมู่บ้าน</label>
<div class="col-8">
<input type="text" class="form-control" name="edt_name" value="<?php echo $rs_data['name_village'];?>" required>
</div>
</div>
<div class="row mb-4">
<label class="col-4 col-form-label fw-700 text-end">จำนวนครัวเรือน</label>
<div class="col-8">
<input type="text" class="form-control " name="edt_family" value="<?php echo $rs_data['family_village'];?>" oninput="this.value = this.value.replace(/\D+/g, '').replace(/^0[^.]/, '0');" required>
</div>
</div>
<hr class="hr-das mb-4">
<div class="row mb-4">
<label class="col-4 col-form-label fw-700 text-end">จำนวนผู้ชาย</label>
<div class="col-8">
<input type="text" class="form-control " name="edt_male" id="total_male_village" value="<?php echo $rs_data['total_male_village'];?>" oninput="this.value = this.value.replace(/\D+/g, '').replace(/^0[^.]/, '0');" required>
</div>
</div>
<div class="row mb-4">
<label class="col-4 col-form-label fw-700 text-end">จำนวนผู้หญิง</label>
<div class="col-8">
<input type="text" class="form-control " name="edt_female" id="total_female_village" value="<?php echo $rs_data['total_female_village'];?>" oninput="this.value = this.value.replace(/\D+/g, '').replace(/^0[^.]/, '0');" required>
</div>
</div>
<div class="row mb-4">
<label class="col-4 col-form-label fw-700 text-end">รวมประชากร</label>
<div class="col-8">
<input type="text" class="form-control " id="total_all_village" value="<?php echo $rs_data['total_all_village'];?>" disabled readonly>
<input type="hidden" name="edt_total" value="<?php echo $rs_data['total_all_village'];?>" id="insert_total_all_village" >
</div>
</div>
<hr class="hr-das mb-4">
<div class="row mb-4">
<label class="col-4 col-form-label fw-700 text-end">อัพเดทข้อมูลล่าสุด</label>
<div class="col-8">
<input type="text" class="form-control " name="datetime" value="<?php echo $rs_data['cv_lastupdate_village']; ?>" disabled readonly>
</div>
</div>
<hr class="hr-das mb-3">
<div class="text-center">
<button type="submit" class="btn btn-success"><i class="fas fa-save me-2" ></i> บันทึกข้อมูล</button>
<button type="button" class="btn btn-danger ms-2" onclick="location.href='VillageMain'">ย้อนกลับ</button>
</div>
</form>
</div>
</div>
<?php include_once ("../footer.php"); ?>
<script>
$("#total_male_village, #total_female_village").on('input', function() {
var value2 = parseInt($("#total_female_village").val()) > 0 ? parseInt($("#total_female_village").val()) : 0;
var value1 = parseInt($("#total_male_village").val()) > 0 ? parseInt($("#total_male_village").val()) : 0
var sumOfValues = value1 + value2;
$("#total_all_village").val(sumOfValues);
$("#insert_total_all_village").val(sumOfValues);
});
</script>
</div>
</body>
</html>