cloudflare worker logging to d1

database

create d1 database, bind it to worker
make a log table, add fields you need.

loggerjs.html

  <script>
    var _pixel = new Image(1, 1);
    _pixel.src = &quot;https://WORKER.workers.dev/?page=&quot; + 
      encodeURIComponent(window.location.pathname) + &quot;&amp;&quot; +
      &quot;ref=&quot; + encodeURIComponent(document.referrer);
    </script>

worker.js

/* idk js but this works */
export default {
  async fetch(request, env, ctx) {
    let srcip = request.headers.get('CF-Connecting-IP');
    let time = Date.now();
    let useragent = request.headers.get("User-Agent")

    const { searchParams } = new URL(request.url)
    let page = "NULL"
    let ref = "NULL"
    page = searchParams.get('page')
    ref = searchParams.get('ref')

    try {
      await env.trafficlog
        .prepare('INSERT INTO log (srcip, useragent, ref, page, time) VALUES (?1, ?2, ?3, ?4, ?5)')
        .bind(srcip, useragent, ref, page, time)
        .run();
    }  catch(err) {
      console.log(err)
    }

    return new Response("");
  },
};