Révision 4ba103f6
_scripts/slug.php | ||
---|---|---|
1 |
<?php |
|
2 |
|
|
3 |
/* |
|
4 |
* Transforme un slub en adresse compatible pour le site |
|
5 |
*/ |
|
6 |
|
|
7 |
include_once("../_config/config.php"); |
|
8 |
|
|
9 |
$url = $_SERVER["REQUEST_URI"]; |
|
10 |
|
|
11 |
$slug = substr($url,strrpos($url,"/")+1); |
|
12 |
//var_dump($slug); |
|
13 |
|
|
14 |
$id = getId($slug); |
|
15 |
var_dump($id); |
|
16 |
|
|
17 |
if($id!=null) { |
|
18 |
$url = "Location: index.php?page=mur&id=$id"; |
|
19 |
} else { |
|
20 |
$url = "Location: index.php?page=404"; |
|
21 |
} |
|
22 |
|
|
23 |
//var_dump($url); |
|
24 |
header($url); |
|
25 |
|
|
26 |
|
|
27 |
function getId($slug) { |
|
28 |
$sql = "SELECT id_mur FROM mur WHERE slug='$slug'"; |
|
29 |
|
|
30 |
// Connexion à la BDD |
|
31 |
try { |
|
32 |
$db = new PDO('mysql:host='.DATABASE_HOST.';dbname='.DATABASE_NAME.';charset=utf8', DATABASE_USER, DATABASE_PASSWORD); |
|
33 |
} catch (PDOException $e) { |
|
34 |
print "Erreur !: " . $e->getMessage(); |
|
35 |
die(); |
|
36 |
} |
|
37 |
|
|
38 |
// On recherche le slug dans la BDD pour réupérer l'id |
|
39 |
try { |
|
40 |
if ($query=$db->query($sql)) { |
|
41 |
$res = $query->fetch(PDO::FETCH_NUM); |
|
42 |
return($res[0]); |
|
43 |
} |
|
44 |
} catch (PDOException $e) { |
|
45 |
print "Erreur !: " . $e->getMessage(); |
|
46 |
die(); |
|
47 |
} |
|
48 |
} |
|
49 |
?> |
|
50 |
|
|
51 |
|
Formats disponibles : Unified diff