|
|
www.ecolo-trucs.com | Détails | Hits : 0 |
|
-
Flux RSS Ecolo Trucs - Trucs et astuces pour l'écologie. :
-
Confirmation de votre inscription. - 01-01-2001
'."\r\n"; $headers = 'Mime-Version: 1.0'."\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-15'."\r\n"; $headers .= "\r\n"; $msg = ' Newsletter Ecolo-Trucs
Email : ' . $email . '
'; mail($to, $sujet, $msg, $headers); echo (" Votre adresse " . $email . " a bien été enregistrée, merci.
"); ?>
-
Le Top-20 de vos Trucs préférés - 01-01-2001
"; while($row = mysql_fetch_row($resultderniers)) { if ($cpt<20) {$ttc = $row[1]; $ttn = $row[2]; $ttl0 = $row[0]; $querycontenu = "SELECT distinct contenu FROM search WHERE lien LIKE \"".$ttl0."\""; $resultcontenu = mysql_query($querycontenu); while($row = mysql_fetch_row($resultcontenu)) {$ttt=$row[0];} $ttt = str_replace(" "," ",$ttt); $ttt = substr($ttt, 0, 100)."..."; $ttl = str_replace("./","http://www.ecolo-trucs.com/",$ttl0); echo " - ".$ttc.". (note : ".$ttn.")"; echo "
\n";} $cpt=$cpt+1; } echo ""; ?>
-
Les 20 derniers Trucs - 01-01-2001
"; while($row = mysql_fetch_row($resultderniers)) { $ttt = str_replace(" "," ",$row[1]); $ttt = substr($ttt, 0, 100)."..."; $ttl = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); echo " - $row[2]."; echo "
\n"; } echo ""; ?>
-
Tous nos Trucs Ecolos - 01-01-2001
Cuisine et Santé :"; while($row = mysql_fetch_row($result)) { $sstt=$row[1]; $sstt = str_replace(" "," ",$sstt); $sstt = substr($sstt, 0, 200)."..."; $ltt = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); echo "- $row[2]."; if ($row[3] == 1) {echo "
";} echo "
\n";} echo " ";$query = "SELECT distinct lien,contenu,titre,new FROM search WHERE categorie LIKE \"%Mode%\" ORDER BY date DESC"; $result = mysql_query($query);echo "Mode et Beauté :"; while($row = mysql_fetch_row($result)) { $sstt=$row[1]; $sstt = str_replace(" "," ",$sstt); $sstt = substr($sstt, 0, 200)."..."; $ltt = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); echo "- $row[2]."; if ($row[3] == 1) {echo "
";} echo "
\n";} echo " ";$query = "SELECT distinct lien,contenu,titre,new FROM search WHERE categorie LIKE \"%Dechets%\" ORDER BY date DESC"; $result = mysql_query($query); echo "Déchets et Tri :"; while($row = mysql_fetch_row($result)) { $sstt=$row[1]; $sstt = str_replace(" "," ",$sstt); $sstt = substr($sstt, 0, 200)."..."; $ltt = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); echo "- $row[2]."; if ($row[3] == 1) {echo "
";} echo "
\n"; } echo " ";$query = "SELECT distinct lien,contenu,titre,new FROM search WHERE categorie LIKE \"%Construction%\" ORDER BY date DESC"; $result = mysql_query($query);echo "Constructions :"; while($row = mysql_fetch_row($result)) { $sstt=$row[1]; $sstt = str_replace(" "," ",$sstt); $sstt = substr($sstt, 0, 200)."..."; $ltt = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); echo "- $row[2]."; if ($row[3] == 1) {echo "
";} echo "
\n"; } echo " ";$query = "SELECT distinct lien,contenu,titre,new FROM search WHERE categorie LIKE \"%Maison%\" ORDER BY date DESC "; $result = mysql_query($query);echo "Maison et Energie :"; while($row = mysql_fetch_row($result)) { $sstt=$row[1]; $sstt = str_replace(" "," ",$sstt); $sstt = substr($sstt, 0, 200)."..."; $ltt = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); echo "- $row[2]."; if ($row[3] == 1) {echo "
";} echo "
\n"; } echo " ";$query = "SELECT distinct lien,contenu,titre,new FROM search WHERE categorie LIKE \"%Jardin%\" ORDER BY date DESC "; $result = mysql_query($query);echo "Jardin et Parc :"; while($row = mysql_fetch_row($result)) { $sstt=$row[1]; $sstt = str_replace(" "," ",$sstt); $sstt = substr($sstt, 0, 200)."..."; $ltt = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); echo "- $row[2]."; if ($row[3] == 1) {echo "
";} echo "
\n"; } echo " ";$query = "SELECT distinct lien,contenu,titre,new FROM search WHERE categorie LIKE \"%Loisir%\" ORDER BY date DESC "; $result = mysql_query($query);echo "Quotidien et Loisirs :"; while($row = mysql_fetch_row($result)) { $sstt=$row[1]; $sstt = str_replace(" "," ",$sstt); $sstt = substr($sstt, 0, 200)."..."; $ltt = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); echo "- $row[2]."; if ($row[3] == 1) {echo "
";} echo "
\n"; } echo " ";mysql_close(); ?>
-
Résultat de la recherche - 01-01-2001
Vous n'avez tapé aucun mot clé ! ";} else { $query = "SELECT distinct count(lien) FROM search WHERE keyword LIKE \"%$Mot%\" OR titre LIKE \"%$Mot%\" "; $result = mysql_query($query); $row = mysql_fetch_row($result); $Nombre = $row[0]; if ($Nombre == "0") { echo " Aucun résultat ne correspond à votre recherche ";} else { $query = "SELECT distinct lien,keyword,titre,categorie,contenu FROM search WHERE keyword LIKE \"%$Mot%\" OR titre LIKE \"%$Mot%\" ORDER by titre ASC"; $result = mysql_query($query); if ($Nombre == "1") { echo " Un Truc correspond à votre recherche : "; } else { echo " $Nombre Trucs correspondent à votre recherche : "; } while($row = mysql_fetch_row($result)) { $lien = str_replace("./","http://www.ecolo-trucs.com/",$row[0]); $title = str_replace(" "," ",$row[4]); $title = substr($title, 0, 100)."..."; echo " \n "; echo " - $row[2].\n \n "; }}} mysql_close();?>
|
|