Bonjour,
Jai un pbm mon moteur de recherche ne recherche pas les truc avec les accents ... J evoudrais quil le fasse aidez moi
recherche.php :
<script>
function Lien() {
i = document.Choix.Liste.selectedIndex;
if (i == 0) return;
url = document.Choix.Liste.options[i].value;
parent.location.href = url;
}
</script>
<div class="recherche">
<div class="footing">
<h2></h2>
<center><table border="0" width="510" bgcolor="#FFFFFF">
<tr>
<td width="340" height="5">
</td>
<td width="160" height="5">
<p><form name="Choix" action="testo.php" method="GET">
<select name="Liste" onChange="Lien()" style="border: 1px solid rgb(118, 204, 55); color: rgb(0, 0, 0);">
<option value="repeat">Séléctionner une catégorie
</option>
<?php
/////////////////////////////system affichage des categorie///////////////////////////////
$retour = mysql_query("SELECT COUNT(*) AS nb_categorie FROM categorie");
$donnees = mysql_fetch_array($retour);
$nbr_categorie = $donnees['nb_categorie'];
$donnes = mysql_query("SELECT * FROM categorie ORDER BY id");
while($rep = mysql_fetch_array($donnes))
{
$categorie=$rep['categorie'];
?>
<optgroup style="background-color: rgb(188, 230, 156);text-align:center;font-weight:bold;" disabled="disabled" label="<?php echo $rep['categorie']; ?>"> <center><b><?php echo $categorie; ?></b></center></optgroup>
<?php $don = mysql_query("SELECT * FROM sous_categorie WHERE categorie ='$categorie' ORDER BY id");
while($rep2=mysql_fetch_array($don))
{
?>
<option value="index.php?recherche=<?php if(isset($_POST['keywords'])) { echo $_POST['keywords']; } else { echo $_GET['recherche']; } ?>&cat_search=<?php echo $rep2['sous_categorie']; ?>"><?php echo $rep2['sous_categorie']; ?></option>
<?php
}
}
?>
</select></form>
</p>
</center></p>
</td> </tr>
</table><br />
<?php
/////////////////////////////////// Traitement de la recherche //////////////////////////////////////
function postInput($string) {
$string = trim($string);
$string = htmlspecialchars($string);
$string = stripslashes($string);
$string = mysql_escape_string($string);
return $string;
}
if(isset($_POST['keywords']))
{
if($_POST['keywords'] != "")
{
$recherche = postInput($_POST['keywords']);
$donnees=mysql_query("SELECT * FROM upload WHERE autorisation='oui' AND titre LIKE \"%$recherche%\" OR texte LIKE \"%$recherche%\" ORDER BY titre ASC") or die(mysql_error());
}
else
{
$erreur=1;
}
}
elseif(isset($_GET['cat_search']))
{
$recherche = mysql_escape_string($_GET['recherche']);
$categorie=mysql_escape_string($_GET['cat_search']);
$donnees=mysql_query("SELECT * FROM upload WHERE autorisation='oui' AND categorie='$categorie' AND titre LIKE \"%$recherche%\" ORDER BY titre ASC") or die(mysql_error());
}
if(!isset($erreur))
{
while($rep=mysql_fetch_array($donnees))
{
$texte= str_replace('\\','',$rep['texte']);
$texte = str_replace('<b>Le synopsis:</b><br />','',$texte);
?>
<table align="center" border="0" width="550" style="border-width:1px; border-color:rgb(229,229,227); border-style:solid;">
<tr>
<td colspan="3" width="550" height="19" bgcolor="#76CC37"><p style="text-align:left"><b><a style="font-size:1.1em;" href="<?php echo $rep['id']; ?>-<?php echo str_replace("#","",str_replace(":","",str_replace(" ","-",str_replace("'","",str_replace('?','',str_replace('/','',str_replace('\\','',$rep['titre']))))))); ?>-<?php if($rep['heberger'] == "mu") { echo "Megaupload"; } elseif($rep['heberger'] == "multi") { echo "Megaupload-FREE-Rapidshare"; } elseif($rep['heberger'] == "free") { echo "FREE"; } elseif($rep['heberger'] == "gigaup") { echo "GigaUP"; } elseif($rep['heberger'] == "other") { echo "Autre"; } elseif($rep['heberger'] == "rs" OR "rapid") { echo "Rapidshare"; } else { echo "Autre"; } ?>.html"><?php echo str_replace('\\','',ucfirst($rep['titre'])); ?></a></b></p></td>
</tr>
<tr>
<td colspan="3" bgcolor="#FFFFFF"><p style="text-align:right"><i>Proposé par <img alt="User" src="images/icones/user.png"></img> <?php echo str_replace('\\','',$rep['pseudo']); ?> dans </i><a href="categorie-<?php echo str_replace('é','e',$rep['categorie']); ?>.html"><?php echo $rep['categorie']; ?></a><i> Le <?php if(ereg("-",$rep['date']) == true) { echo $rep['date']; } else { echo date('d-m-Y à H:h', $rep['date']); } ?></i></p></td>
</tr>
<tr>
<td width="130" height="180" rowspan="4"><a title="<?php echo str_replace('?','',str_replace('\\','',$rep['titre'])); ?>" href="<?php echo $rep['image']; ?>" rel="lightbox[roadtrip]"><img src="<?php echo $rep['image']; ?>" width="130" height="180" ></a></td>
</tr>
<tr>
<td colspan="2" width="390" bgcolor="#FFFFFF"><p style="text-align:left"><?php echo substr($texte,0,300); ?></p></td>
</tr>
<tr>
<td width="210" height="4" style="background-color:rgb(255,255,255); border-width:1px; border-color:white; border-style:solid;">
<p>Genre : <b><?php echo str_replace('\\','',$rep['genre']); ?></b></p>
<p>Type : <b><?php echo str_replace('\\','',$rep['qualiter']); ?></b></p>
</td>
<td width="210" height="4" style="background-color:rgb(255,255,255); border-width:1px; border-color:white; border-style:solid;">
<p>Hébergeur : <b> <?php if($rep['heberger'] == "mu") { echo "MegaUpload"; } elseif($rep['heberger'] == "multi") { echo "Multi"; } elseif($rep['heberger'] == "free") { echo "FREE"; } elseif($rep['heberger'] == "gigaup") { echo "GigaUP"; } elseif($rep['heberger'] == "other") { echo "Autre"; } elseif($rep['heberger'] == "rs" OR "rapid") { echo "Rapidshare"; } else { echo "Autres"; } ?></b></p>
<p>Téléchargements : <b><?php echo $rep['nombres']; ?></b></p>
</td>
</tr>
<tr>
<td colspan="3" width="390" height="22" bgcolor="#FFFFFF"><p style="text-align:center"><a href="<?php echo $rep['id']; ?>-<?php echo str_replace("%","",str_replace("#","",str_replace(":","",str_replace(" ","-",str_replace("'","",str_replace('?','',str_replace('/','',str_replace('\\','',$rep['titre'])))))))); ?>-<?php if($rep['heberger'] == "mu") { echo "Megaupload"; } elseif($rep['heberger'] == "multi") { echo "Megaupload-FREE-Rapidshare"; } elseif($rep['heberger'] == "free") { echo "FREE"; } elseif($rep['heberger'] == "gigaup") { echo "GigaUP"; } elseif($rep['heberger'] == "other") { echo "Autre"; } elseif($rep['heberger'] == "rs" OR "rapid") { echo "Rapidshare"; } else { echo "Autre"; } ?>.html"><img border="0" alt="[ Voir la fiche ]" src="images/voir_la_fiche.png"></img></a></p></td>
</tr>
</table>
<br />
<div style="text-align:center" class="sepaa"><h1></h1></div><br />
<?php
}
}
else
{
if($erreur = 1 )
{
?>
<table align="center" border="0" width="550" bgcolor="#A0DC74">
<tr>
<td width="550">
<center><b><font color="white">Veuillez entrer un mot clé s'il vous plaît!</font></b></center>
</td>
</tr>
</table><br />
<?php
}
}
?>
</div></div>
