Building a 24,000-Page Programmatic SEO Architecture in 30 Days (PHP/MySQL)

Hey DEV community! 👋

I’m a full-stack developer and I just launched my first major Programmatic SEO project. I wanted to share the architecture behind it, how I bypassed duplicate content penalties, and the early ranking results.

The Problem: Fragmented B2B Data

I decided to target US municipal building permit costs and local contractor regulations. It’s a "boring" B2B niche, but that means the search intent is high. The problem? Every one of the 3,000+ US counties has different base fees, sales taxes, and climate-specific building codes (like hurricane or seismic regulations).

The Stack & Architecture

I kept the stack incredibly lightweight for maximum performance and fast server response times (crucial for SEO crawling budgets):

• Backend: Raw PHP.
• Database: MySQL.
• Frontend: HTML/CSS/JS (No heavy JS frameworks to ensure immediate rendering).

I built a relational database to cross-reference core tables:

1. States (State-wide multipliers and default rules)
2. Counties (Local population density, agricultural exceptions, specific climate risks)
3. Projects (Roofing, Solar Panels, Fences, etc.)

The SEO Strategy (Spintax Generation)

Generating 24,000 pages programmatically is easy; getting Google to index them without a "thin content" penalty is the hard part.

Instead of just swapping out the county name (e.g., "Roof permit in County X"), I built a custom spintax algorithm in PHP. The logic dynamically generates paragraphs based on the data conditions. For example, if a county is in Florida, the PHP script injects specific paragraphs about hurricane code compliance and wind mitigation requirements. This ensures every single URL has unique, highly relevant content.

The Results (1 Month In)

I submitted a massive sitemap and let Google digest it slowly.

• Indexed Pages: ~24,100 (Google is picking up chunks of 500 pages every few days, which is a very healthy crawl rate).
• Rankings: The "Google Sandbox" phase is stabilizing, and Search Console is currently showing an average position of 8.6 for my primary B2B keywords. Breaking into Page 1 this fast with a programmatic site was a huge technical win.

Here is the live site if you want to test the routing or the dynamic calculators:
👉 StateDataIndex.com

I’m currently figuring out the best way to scale backlinks to push these pages from position 8 to the top 3.

Has anyone here built something similar? Would love any feedback on programmatic structures or B2B link-building strategies!