get web first then cache

self.addEventListener('fetch', (event) => {
event.respondWith(
  fetch(event.request)
    .then((networkResponse) => {
      // Clone the response before caching (it can only be read once)
      return caches.open('dynamic-cache').then((cache) => {
        cache.put(event.request, networkResponse.clone());
        return networkResponse;
      });
    })
    .catch(() => {
      // Fallback to cache if the network request fails (offline)
      return caches.match(event.request);
    })
);
});

schedule sql

$sql = "SELECT tblGamesBrief.ID as briefID, tblGamesFull.ID as homeID, tblGamesFull.xTeam as homeTeam, tblGamesFull.xDate as xDate, tblGamesFull.xWeek as xWeek, tblGamesFull_1.ID as awayID, tblGamesFull_1.xTeam as awayTeam, (case when (Month(tblGamesFull.xDate)> 5) then Year(tblGamesFull.xDate) else Year(tblGamesFull.xDate) - 1 end) as xYear FROM (tblGamesBrief INNER JOIN tblGamesFull ON tblGamesBrief.xHomeTeam = tblGamesFull.ID) INNER JOIN tblGamesFull AS tblGamesFull_1 ON tblGamesBrief.xVisitingTeam = tblGamesFull_1.ID Where (case when (Month(tblGamesFull.xDate)> 5) then Year(tblGamesFull.xDate) else Year(tblGamesFull.xDate) - 1 end)=$getYear order by tblGamesFull.xDate";

encryption

network first for start_url
if (event.request.mode === 'navigate') {
  event.respondWith(
    // 1. Try the network first
    fetch(event.request)
      .then((response) => {
        // Clone the response so we can put one in cache and return the other
        const responseToCache = response.clone();
        
        caches.open(CACHE_NAME).then((cache) => {
          cache.put(event.request, responseToCache);
        });
        
        return response;
      })
      .catch(() => {
        // 2. Fallback to cache if network fails (offline)
        return caches.match(event.request);
      })
  );
}

javascriptasync function encryptData(plaintext, hexKey) {
  // 1. Convert hex key to byte array
  const keyBuffer = new Uint8Array(hexKey.match(/.{1,2}/g).map(byte => parseInt(byte, 16)));
  
  // 2. Import the raw key into Web Crypto API
  const cryptoKey = await crypto.subtle.importKey(
      "raw", keyBuffer, { name: "AES-CBC" }, false, ["encrypt"]
  );

  // 3. Generate a random 16-byte initialization vector (IV)
  const iv = crypto.getRandomValues(new Uint8Array(16));
  const encoder = new TextEncoder();
  const encodedPlaintext = encoder.encode(plaintext);

  // 4. Encrypt the data
  const ciphertextBuffer = await crypto.subtle.encrypt(
      { name: "AES-CBC", iv: iv }, cryptoKey, encodedPlaintext
  );

  // 5. Convert IV and Ciphertext to Base64
  const ivBase64 = btoa(String.fromCharCode(...iv));
  const ciphertextBase64 = btoa(String.fromCharCode(...new Uint8Array(ciphertextBuffer)));

  // 6. Combine them with a colon separator for transmission
  return `${ivBase64}:${ciphertextBase64}`;

}

// Execution Example:
encryptData("Hello from the browser!", "603deb1015ca71be2b73aef0857d77811f352c073b6108d72d9810a30914df1a")
  .then(encryptedString => console.log("Send this to PHP:", encryptedString));
Use code with caution.🐘 PHP Decryption (Server)The PHP script accepts the composite Base64 string, splits it   back into the individual IV and ciphertext segments, and decrypts it using the built-in OpenSSL library.php<?php

function decryptData($encryptedString, $hexKey) {
  // 1. Convert hex key back to binary
  $key = hex2bin($hexKey);

  // 2. Split the incoming payload into IV and Ciphertext components
  $parts = explode(':', $encryptedString);
  if (count($parts) !== 2) {
      return false; // Invalid payload structure
  }

  $iv = base64_decode($parts[0]);
  $ciphertext = base64_decode($parts[1]);

  // 3. Decrypt using native OpenSSL
  $decrypted = openssl_decrypt(
      $ciphertext,
      'aes-256-cbc',
      $key,
      OPENSSL_RAW_DATA,
      $iv
  );

  return $decrypted;
}

// Execution Example:
$hexKey = "603deb1015ca71be2b73aef0857d77811f352c073b6108d72d9810a30914df1a";
$receivedPayload = $_POST['encrypted_data'] ?? 'PASTE_JAVASCRIPT_OUTPUT_HERE';

$decryptedMessage = decryptData($receivedPayload, $hexKey);

if ($decryptedMessage !== false) {
  echo "Decryption Successful: " . $decryptedMessage;
} else {
  echo "Decryption Failed.";
}