22

✏️ Editing: search_feedback.php

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

// Connect to DB
$conn = new mysqli($host, $user, $pass, $dbname);
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$search_result = null;
$error = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  $natid = $conn->real_escape_string($_POST['natid']);
  
  $sql = "SELECT * FROM nissan_registrations WHERE mobile = '$natid' and status = 'Started' LIMIT 0,2";
  $result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
    $search_result = [];
while ($row = $result->fetch_assoc()) {
    $search_result[] = $row;
}
  } else {
    $error = "No registration found or test drive haven't started with the provided Mobile number.";
  }

//print_r($search_result);  
  
}
?>

<!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;
    }
    a:-webkit-any-link {
    color: -webkit-link;
    cursor: pointer;
    text-decoration: none !important;
}
  </style>
</head>
<body>

<a href="/"><img src="https://nissan-test-drive.core3.agency/assets/Nissan Logo-01.png" alt="Petromin Logo" />   </a> 
  <h2>Search Test Drive by <br> Mobile Number</h2>
  <div style="height:20px;"></div>  
    
  <form method="post">
    <label for="natid">Enter Mobile Number:</label>
    <input type="tel" name="natid" id="natid" required />
    <button type="submit" class="btn">Search</button>
  </form>

<?php if ($error): ?>
    <div class="error"><?= $error ?></div>
  <?php endif; ?>

<?php if ($search_result): ?>
  <?php foreach ($search_result as $row): ?>
    <div class="info" style="margin-top: 20px; text-align: left;">
      <p><strong>Name:</strong> <?= htmlspecialchars($row['first_name'] . ' ' . $row['last_name']) ?></p>
      <p><strong>Mobile:</strong> <?= htmlspecialchars($row['mobile']) ?></p>
      <p><strong>Email:</strong> <?= htmlspecialchars($row['email']) ?></p>
      <p><strong>Vehicle:</strong> <?= htmlspecialchars($row['vehicle']) ?></p>
      <form action="start_feedback.php" method="post">
        <input type="hidden" name="natid" value="<?= htmlspecialchars($row['id']) ?>" />
        <button type="submit" class="btn">Submit Feedback</button>
      </form>
    </div>
  <?php endforeach; ?>
<?php endif; ?>
</div>

</body>
</html>

MR SKB