connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
// Sanitize inputs
$id = (int) $_POST['id'];
$experience_rating = $conn->real_escape_string($_POST['experience_rating']);
$engine_rating = $conn->real_escape_string($_POST['engine_rating']);
$space_rating = $conn->real_escape_string($_POST['space_rating']);
$tech_rating = $conn->real_escape_string($_POST['tech_rating']);
$purchase_interest = $conn->real_escape_string($_POST['purchase_interest']);
$price_opinion = $conn->real_escape_string($_POST['price_opinion']);
$status = 'Completed';
// Prepare update query
$stmt = $conn->prepare("
UPDATE nissan_registrations SET
experience_rating = ?,
engine_rating = ?,
space_rating = ?,
tech_rating = ?,
purchase_interest = ?,
price_opinion = ?,
status = ?,
completion_time = '$start_date',
feedback_time = '$start_date'
WHERE id = ?
");
if (!$stmt) {
die("Prepare failed: " . $conn->error);
}
// Bind parameters and execute
$stmt->bind_param("sssssssi", $experience_rating, $engine_rating, $space_rating, $tech_rating, $purchase_interest, $price_opinion, $status, $id);
if ($stmt->execute()) {
//echo "Feedback submitted successfully. Thank you!
";
} else {
//echo "Error: " . $stmt->error . "
";
}
$stmt->close();
}
$conn->close();
?>
Petromin Nissan Registration