Built automotive aftermarket parts directory with PHP that queried DB of vehicle info to generate thousands of indexed pages, increasing site visibility and SEO traffic. Dynamically created product pages from database relationships.
I leveraged the core database tables - Manufacturer, Vehicle Model, Model Year, and Automotive Part. By joining and filtering these tables, I could efficiently query parts by manufacturer, model, year, etc. This allowed me to generate over hundreds of thousands of dynamic pages for SEO.