Gecko [ eachadeal.com ]

Linux host2.homegym.sg 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64
Apache
Server IP : 159.223.38.192 & Your IP : 159.223.38.192
Domains : 20 Domain
User : eachadea

Name	Size	Permission	Date
autosave-form.php	1.36 KB	-rw-r--r--	2019-10-09 08:39
autosave.php	1008 B	-rw-r--r--	2016-03-19 17:59
error_log	249 KB	-rw-r--r--	2024-05-30 20:39
loadForm.php	420 B	-rw-r--r--	2016-03-16 18:37
save-image.php	301 B	-rw-r--r--	2016-03-20 06:31

Rename

<?php require '../config.php'; ?>
<?php

date_default_timezone_set('Asia/Singapore');
$customer_id = $_POST['customer_id'];
$maintenance_data_id = $_POST['maintenance-form'];

$sql = "SELECT * FROM checklist_data where maintenance_data_id=".$maintenance_data_id." ORDER BY equipment_own_id ASC";
$result = mysqli_query($conn, $sql);

$completed=1;
while($row = mysqli_fetch_assoc($result)) {
	if ($_POST['check-'.$row['id']]=="true" || $_POST['check-'.$row['id']]=="on" || $_POST['check-'.$row['id']]=="checked"  ) $check = 1; 
	else { $check = 0; $completed=0; }
	$sql = "UPDATE checklist_data SET checked='".$check."', remarks='".$_POST['remarks-'.$row['id']]."' WHERE id='".$row['id']."'";
	$result2 = mysqli_query($conn, $sql);
}

$sql = "SELECT * FROM equipment_data where maintenance_data_id=".$maintenance_data_id; 
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)) {
	$sql = "UPDATE equipment_data SET status='".$_POST['status-'.$row['id']]."' WHERE id='".$row['id']."' && maintenance_data_id=".$maintenance_data_id; 
	$result2 = mysqli_query($conn, $sql);
}
	
$date = date('Y-m-d H:i:s');
$sql = "UPDATE maintenance_data SET modified_date='".$date."', completed='".$completed."', remarks='".$_POST['remarks']."', updated_by='".$_POST['updated_by']."' WHERE id='".$maintenance_data_id."'";
$result = mysqli_query($conn, $sql);
?>
<?php mysqli_close($conn);?>