1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
| <?php
/*TRAITEMENT DES DONNEES RECUPEREES*/
/*Nettoyage de la requete de l'utilisateur*/
$mot = strtolower(trim($mot));
$mot = str_replace(array(",", "-", ".", ":", ";", "'"), " ", $mot);
$mot = str_replace(" ", " ", $mot);
$mot = str_replace("<", "", $mot);
$mot = str_replace(">", "", $mot);
$mot = str_replace("\'", "'", $mot);
$mot = str_replace("_", " ", $mot);
$mot = str_replace("&", "et", $mot);
$mot = str_replace("+", " ", $mot);
$mot = str_replace("?", "", $mot);
$mot = str_replace("é", "e", $mot);
$mot = str_replace("è", "e", $mot);
$mot = str_replace("ë", "e", $mot);
$mot = str_replace("ê", "e", $mot);
$mot = str_replace("à", "a", $mot);
//etc, etc...je les met pas toutes, ça serait trop long
/*Extraction des mots clefs*/
$mots = explode( " ", $_POST['mot'] );
/*Requête*/
$query = "";
{
foreach( $mots as $Mot )
{
//Ajout de la whereclause
$query .= ( (empty($query)) ? '' : ' AND' )." (theme LIKE '%{$Mot}%' OR pays LIKE '%{$Mot}%' OR ville LIKE '%{$Mot}%'OR titre LIKE '%{$Mot}%' OR contenu LIKE '%{$Mot}%'OR motscles LIKE '%{$Mot}%' )";
}
$query = "SELECT * FROM culture WHERE $query ORDER BY date ASC";
$reponse = mysql_query( $query ) or exit( "Une erreur est survenue avec la base de données:<br />\n".mysql_error() );
}
?> |
