require "../../replace.php";
require "../../../connection.php";
//require "/home/academie/connection.php";
//require "../../../connection.php";
$acces=0;
//////////////////////////////////////////////////////////////////////
if (isset($_REQUEST['acces'])){$acces=$_REQUEST['acces'];}
//else{if (isset($HTTP_GET_VARS['acces'])){$acces=$HTTP_GET_VARS['acces'];}}
//echo "acces = ".$acces;
if ($acces==1){
$grand_titre="Toutes les actualités";
/////////////////////////////////////////////////////
/////////////////////////////////////////////////////
if (isset($_REQUEST['mot_1'])){$mot_1=$_REQUEST['mot_1'];}
//else{if (isset($HTTP_GET_VARS['mot_1'])){$mot_1=$HTTP_GET_VARS['mot_1'];}}
//echo "mot_1 = ".$mot_1;
$cot="'";
$guillemet="\"";
$co=explode(";",$mot_1);
for ($i=0; $i'');
$mo[$i]=range(1,100);
$article_mots[$i]=array(0=>'');
$nombre=count($co);
//$co[$i]=utf8_encode($co[$i]);
}
switch ($nombre) {
case 0:
$requete="select * from agenda_arabe where numero != 140 ORDER BY date_insertion desc ";
break;
case 1:
$requete="select * from agenda_arabe where titre like '%$co[0]%' AND numero != 140 ORDER BY date_insertion desc";
break;
case 2:
$requete="select * from agenda_arabe where titre like '%$co[0]%' and titre like '%$co[1]%' AND numero != 140 ORDER BY date_insertion desc";
break;
case 3:
$requete="select * from agenda_arabe where titre like '%$co[0]%' and titre like '%$co[1]%' and titre like '%$co[2]%' AND numero != 140 ORDER BY date_insertion desc";
case 4:
$requete="select * from agenda_arabe where titre like '%$co[0]%' and titre like '%$co[1]%' and titre like '%$co[2]%' and titre like '%$co[3]%' AND numero != 140 ORDER BY date_insertion desc";
break;
case 5:
$requete="select * from agenda_arabe where titre like '%$co[0]%' and titre like '%$co[1]%' and titre like '%$co[2]%' and titre like '%$co[3]%' and titre like '%$co[4]%' AND numero != 140 ORDER BY date_insertion desc";
break;}
///////////////////////////////////////////////////////
/////////////////////////////////////////////////////
if (isset($_REQUEST['requete'])){$requete=$_REQUEST['requete'];}
//else{if (isset($HTTP_GET_VARS['requete'])){$requete=$HTTP_GET_VARS['requete'];}}
//echo "requete = ".$requete;
$mess=1;
}
else{$mot_1="";
$requete="select * from agenda_arabe WHERE numero != 140 ORDER BY date_insertion desc";
$grand_titre="Toute l'actualité";
$mess=2;
}
mysql_query('SET NAMES UTF8');
$resultat_total=mysql_query($requete) or die ('probleme la bas');
$nb=mysql_num_rows($resultat_total);
$limite=0;
if (isset($_REQUEST['limite'])){$limite=$_REQUEST['limite'];}
//else{if (isset($HTTP_GET_VARS['limite'])){$limite=$HTTP_GET_VARS['limite'];}}
//echo "limite = ".$limite;
$m=10;
$requete=$requete." LIMIT ".$limite.",".$m;
$resultat=mysql_query($requete) or die ('probleme ici');
//echo ".......................".mysql_num_rows($resultat);
$entier=(int)($nb/10);
$reste=$nb%10;
//echo "....................".$nb;
?>