22

✏️ Editing: submitfeedback.php

<?php
// DB configuration
$host = 'localhost';
$dbname = 'balubaid_nissan_test_drive';
$user = 'balubaid_nissan_test_drive';
$pass = 'Vision@2050';

date_default_timezone_set('Asia/Riyadh');
$start_date = date('Y-m-d H:i:s'); // Time in Riyadh (Asia/Riyadh)

// Connect to DB
$conn = new mysqli($host, $user, $pass, $dbname);
if ($conn->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 "<h2 style='text-align:center;font-family:Arial;'>Feedback submitted successfully. Thank you!</h2>";
    } else {
        //echo "<h2 style='text-align:center;font-family:Arial;color:red;'>Error: " . $stmt->error . "</h2>";
    }

$stmt->close();
}

$conn->close();
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1.0"/>
  <title>Petromin Nissan Registration</title>
  <style>
    body {
      font-family: Arial, sans-serif;
      background-color: #ddd;
      display: flex;
      justify-content: center;
      padding: 40px;
    }
    .form-container {
      background-color: #e3e3e3;
      padding: 30px;
      width: 350px;
      border-radius: 8px;
      text-align: center;
    }
    .form-container img {
      max-width: 150px;
      margin-bottom: 10px;
    }
    .form-container h1 {
      font-size: 22px;
      margin-bottom: 20px;
    }
    .form-container label {
      display: block;
      text-align: left;
      margin: 10px 0 5px;
    }
    .form-container input[type="text"],
    .form-container input[type="email"],
    .form-container input[type="file"],
    .form-container input[type="tel"] {
      width: 100%;
      padding: 8px;
      margin-bottom: 10px;
      border: none;
      border-radius: 4px;
    }
    .form-container .radio-group {
      display: flex;
      justify-content: space-around;
      margin-bottom: 15px;
    }
    .form-container .radio-group input {
      margin-right: 5px;
    }
    .form-container .submit-btn {
      background-color: #d72626;
      color: white;
      padding: 12px;
      border: none;
      width: 100%;
      font-weight: bold;
      font-size: 16px;
      border-radius: 5px;
      cursor: pointer;
    }
    .form-container .submit-btn:hover {
      background-color: #b01f1f;
    }
    label.error {
      color: red;
      font-size: 13px;
      display: block;
      text-align: left;
      margin-top: -8px;
      margin-bottom: 8px;
    }
  </style>
  <script>
    setTimeout(function () {
      window.location.href = "https://nissan-test-drive.core3.agency/";
    }, 5000); // 5000 milliseconds = 5 seconds
  </script>
</head>
<body>

<form id="registration-form" class="form-container" novalidate>
 <a href="/"><img src="https://nissan-test-drive.core3.agency/assets/Nissan Logo-01.png" alt="Petromin Logo" />   </a> 
  <h1>Thanks for Feedback</h1>  
  <p>You will be redirected shortly...</p>
</form>

</body>
</html>

MR SKB