prepare($sql);
$recipesStatement->execute();
$recipes = $recipesStatement->fetchAll();
$nb1=0;
$nb2=0;
$nb4=0;
$nb5=0;
$maj1 = « »;
$maj2 = « »;
$maj4 = « »;
$maj5 = « »;
foreach($recipes as $recipe){
if($recipe[« id_categorie »] == « 1 »){
$nb1 = $recipe[« nb »];
$maj1 = $recipe[‘date_maj’];
}
if($recipe[« id_categorie »] == « 2 »){
$nb2 = $recipe[« nb »];
$maj2 = $recipe[‘date_maj’];
}
if($recipe[« id_categorie »] == « 4 »){
$nb4 = $recipe[« nb »];
$maj4 = $recipe[‘date_maj’];
}
if($recipe[« id_categorie »] == « 5 »){
$nb5 = $recipe[« nb »];
$maj5 = $recipe[‘date_maj’];
}
}
?>
AJOUTER MES PROPRES ARTICLES.
Lien de l’article
Titre de l’article
Catégorie
Choisir la catégorie
prepare($sql);
$recipesStatement->execute();
$recipes = $recipesStatement->fetchAll();
foreach ($recipes as $recipe){
?>
« >
Loading…
Loading…
Loading…
RECHERCHER DES MISSIONS DE FORMATION
RECHERCHER DES CLIENTS / APPRENANTS
Ajouter une option à mon abonnement
Lorem ipsum dolor sit amet, consectetur adipisicing elit,
=14″;
}
//Mise à jour tous les 7 jrs abonnement SMART
if($_SESSION[‘id_abonnement’] == « 2 »){
$where_maj = « and DATEDIFF(‘ ».date(‘Y-m-d’). »‘, A.date_entree_article)>=7″;
}
$where2 = » and concat(A.url_article, ‘_’, A.id_categorie) not in (select concat(url_article, ‘_’, id_categorie) from articles_masquer where id_abonnee= ».$_SESSION[‘id_abonnee’]. ») »;
if ($where_liste_cat == « »){
$where2 = » where concat(A.url_article, ‘_’, A.id_categorie) not in (select concat(url_article, ‘_’, id_categorie) from articles_masquer where id_abonnee= ».$_SESSION[‘id_abonnee’]. ») »;
}
$limit = 12;
$sql = « select count(*) as nb from articles A $where_liste_cat $where2 $search_query $where_maj and A.propre_article=’0′ »;
//echo $sql;
$recipesStatement = $mysqlClient->prepare($sql);
$recipesStatement->execute();
$recipes = $recipesStatement->fetchAll();
$max_page = 1;
foreach($recipes as $recipe){
if($recipe[‘nb’] > 0){
$max_page = $recipe[‘nb’]/$limit;
if($recipe[‘nb’] % $limit >0){
$max_page = intval($recipe[‘nb’]/$limit)+1;
}
}
}
//echo $max_page;
$per_page = 5;
$max_pagin = $per_page;
$min_pagin = 1;
$p_encours = 1;
$sql = « SELECT A.id_article as id_article,A.id_categorie as id_categorie,A.titre_article as titre_article,if(length(A.description_article)>100, concat(substr(A.description_article, 1, 100), ‘…’), substr(A.description_article, 1, 100)) as description_article,A.url_article as url_article,A.date_article as date_article,A.datetext_article as datetext_article,A.photo_article as photo_article,A.source_article as source_article, (select nom_categorie from categories where id_categorie=A.id_categorie) as nom_categorie FROM articles A $where_liste_cat $where2 $search_query $where_maj and A.propre_article=0 order by A.date_entree_article desc limit $limit »;
if(isset($_GET[‘page’])){
if($_GET[‘page’]>1){
$p_encours = $_GET[‘page’];
$delim = intval($limit*($p_encours-1));
//$max_id=$max_id+1;
$sql = « SELECT A.id_article as id_article,A.id_categorie as id_categorie,A.titre_article as titre_article,if(length(A.description_article)>100, concat(substr(A.description_article, 1, 100), ‘…’), substr(A.description_article, 1, 100)) as description_article,A.url_article as url_article,A.date_article as date_article,A.datetext_article as datetext_article,A.photo_article as photo_article,A.source_article as source_article, (select nom_categorie from categories where id_categorie=A.id_categorie) as nom_categorie FROM articles A $where_liste_cat $where2 $search_query $where_maj and A.propre_article=0 order by A.date_entree_article desc limit 12 OFFSET $delim »;
if($p_encours % $per_page == « 0 »){
$max_pagin = $p_encours;
$min_pagin = $max_pagin – ($per_page-1);
}else{
for($a=1;$a<=($per_page-1); $a++){
$p = $p_encours+$a;
if($p % $per_page == "0"){
$max_pagin = $p;
$min_pagin = $max_pagin - ($per_page-1);
}
}
}
}
}
//echo $sql;
if($max_pagin > $max_page){
$max_pagin = $max_page;
}
//echo $min_pagin. » to « .$max_pagin;
$recipesStatement = $mysqlClient->prepare($sql);
$recipesStatement->execute();
$recipes = $recipesStatement->fetchAll();
$gd = 1;
foreach($recipes as $recipe){
if($gd == « 1 »){
?>
Pas de description pour l’article« ;
}
?>
Abonné
Pas de description pour l’article« ;
}
?>
Abonné
« ;
}
?>
