prepare("SELECT id, name, seo_text FROM cities WHERE slug = ?");
$stmt->execute([$city_slug]);
$city = $stmt->fetch();
if (!$city) {
header("Location: /404.php");
exit;
}
$city_id = $city['id'];
$city_display_name = htmlspecialchars($city['name']);
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$profiles_per_page = 10;
$offset = ($page - 1) * $profiles_per_page;
$stmt = $pdo->prepare("SELECT p.*,
c.name AS city_name
FROM profiles p
JOIN cities c ON p.city_id = c.id
WHERE c.id = ?
ORDER BY p.created_at DESC
LIMIT ? OFFSET ?
");
$stmt->bindParam(1, $city_id, PDO::PARAM_INT);
$stmt->bindParam(2, $profiles_per_page, PDO::PARAM_INT);
$stmt->bindParam(3, $offset, PDO::PARAM_INT);
$stmt->execute();
$profiles = $stmt->fetchAll();
$stmt = $pdo->prepare("SELECT COUNT(*) FROM profiles WHERE city_id = ?");
$stmt->execute([$city_id]);
$total_profiles = $stmt->fetchColumn();
$total_pages = ceil($total_profiles / $profiles_per_page);
?>
e, ö -> o, etc.)
// Attention : en fonction de la locale et de l’OS, iconv peut mieux ou moins bien marcher.
$trans = @iconv('UTF-8', 'ASCII//TRANSLIT', $string);
if ($trans !== false) {
$string = $trans;
}
// 3) Remplacer tout ce qui n’est pas lettre ou chiffre par un tiret
// Ici on remplace la séquence de caractères spéciaux par un seul tiret
// (ex: "genève!!!" -> "geneve-").
$string = preg_replace('/[^a-z0-9]+/', '-', $string);
// 4) Enlever d’éventuels tirets en début ou fin
$string = trim($string, '-');
return $string;
}
?>
Seksitreffit <?php echo $city_display_name; ?> | <?php echo $ad_count; ?> ilmoitusta löydettävissä nyt SEXSITREFFIT FI:ssä