<?php
$pdo = require 'config/database.php';

echo "SERVICES:\n";
$services = $pdo->query("SELECT id, service_name, slug FROM services WHERE status='active'")->fetchAll(PDO::FETCH_ASSOC);
print_r($services);

echo "\nLOCATIONS:\n";
$locations = $pdo->query("SELECT id, name, slug FROM locations WHERE status='active'")->fetchAll(PDO::FETCH_ASSOC);
print_r($locations);

echo "\nSEO LANDINGS:\n";
$landings = $pdo->query("SELECT id, service_id, location_id, slug, title, description, h1_title, focus_keyword FROM seo_landings")->fetchAll(PDO::FETCH_ASSOC);
print_r($landings);
