AI Master Programmer with Dr. Chuck: Building a Simple UTM Tracker with PHP, SQLite, and Cursor AI @ChuckSeverance
AI Master Programmer with Dr. Chuck: Building a Simple UTM Tracker with PHP, SQLite, and Cursor AI  @ChuckSeverance
Uploaded August 2026 | Updated November 2026, 2 hours ago
If you want to join Dr. Chuck's new online offering visit django.dr-chuck.com

Registration will be open August-October 2026.

In this video, I use Cursor AI to add a lightweight UTM tracking system to django.dr-chuck.com

The goal is simple: determine whether visitors arrived through a QR code, LinkedIn post, YouTube video, or another campaign—without installing a full analytics platform or setting up a database server.

We build the tracker using PHP and a small local SQLite database. It records each UTM code, the number of visits, and the first and most recent usage dates. We also add a 250-code limit so that the database cannot grow indefinitely, plus optional password protection for the results page.

Along the way, I test the system locally, deploy it to production, inspect the generated code, and explain why SQLite is such a useful piece of technology for small, fast, self-contained applications.

You can explore my experimental Campus Aligned Open Course (CLOC) in Django at:

django.dr-chuck.com

Try adding your own tracking value to the URL:

django.dr-chuck.com/?utm=42

The course runs alongside my University of Michigan on-campus web development course and gives online students access to the course schedule, Canvas materials, teaching assistants, and office hours.

This is another experiment in my long-running effort to use the Internet, open source software, and open educational resources to improve teaching.

Like, subscribe, and follow along as I continue building the course and sharing the process.
AI Master Programmer with Dr. Chuck: Building a Simple UTM Tracker with PHP, SQLite, and Cursor AIChuck Severance is live at the Classic Pub Three Ball Tournamentvideo lti 1 1(Classic)Mid Ohio - Scott Track Day - 2026-04-10The Single Most BOSS move by hotel staff! #newyork #timessquare #kimptontheta @kimptonAI Coding: Tsugi Open Badges OB3 Signing before a meeting with XaviRefactoring Tsugis Admin Console with AI – Moving Legacy PHP to ControllersRequired Viewing Django Week 3: SQL, Models, ORM, and SQLiteDeleting Courses Safely in Tsugi — Cascades, Badges, and “Are You Sure?”DJ 31.03 Django Many-to-Many Favorites with AJAX Implementation (34:18)Taking the New Tsugi Organization and LTI Model Into ProductionI Broke Production While Reviewing My AI-Generated Code
Chuck Severance |

AI Master Programmer with Dr. Chuck: Building a Simple UTM Tracker with PHP, SQLite, and Cursor AI

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER