verify

<div id="ticket-result">Checking ticket...</div>

<script>
  // -------- Step 1: Get ticket ID from URL --------
  function getParameterByName(name) {
    const url = window.location.href;
    name = name.replace(/[[]]/g, "\\$&");
    const regex = new RegExp("[?&]" + name + "(=([^&#]*)|&|#|$)"),
          results = regex.exec(url);
    if (!results) return null;
    if (!results[2]) return '';
    return decodeURIComponent(results[2].replace(/\+/g, " "));
  }

  const ticketID = getParameterByName('ticket');
  const resultDiv = document.getElementById('ticket-result');

  if (!ticketID) {
    resultDiv.innerHTML = "No ticket provided.";
  } else {

    // -------- Step 2: Google Sheets API URL --------
    const sheetID = "1WrPoXBF78eIrsjJKOrsqedHImCuv-kt-wbn-GpU6GDs";
    const apiKey = "AIzaSyBu4mAbgbET275QkfLAQoIyg4BR_zGWxLU";

    // Adjusted range to your sheet "Ulaznice", assuming header row in first row
    const range = "Ulaznice!A2:C"; // Name | Email | TicketID
    const url = `https://sheets.googleapis.com/v4/spreadsheets/${sheetID}/values/${range}?key=${apiKey}`;

    // -------- Step 3: Fetch sheet data --------
    fetch(url)
      .then(response => response.json())
      .then(data => {
        const rows = data.values;
        let found = false;

        if (rows && rows.length > 0) {
          for (let i = 0; i < rows.length; i++) {
            const rowTicketID = rows[i][2]; // TicketID is column C
            if (rowTicketID === ticketID) {
              found = true;
              const attendeeName = rows[i][0]; // Name is column A
              resultDiv.innerHTML = `<span style="color:green; font-weight:bold;">Ticket Valid ✅</span><br>Name: ${attendeeName}<br>Ticket ID: ${ticketID}`;
              break;
            }
          }
        }

        if (!found) {
          resultDiv.innerHTML = `<span style="color:red; font-weight:bold;">Invalid Ticket ❌</span>`;
        }
      })
      .catch(error => {
        console.error(error);
        resultDiv.innerHTML = "Error checking ticket. Please try again later.";
      });
  }
</script>