article.articleImage
FROM article
WHERE brouillon = 1 ORDER BY article.publishDate DESC limit 3
";
 
$sql3 = "SELECT 
categories.categoriesName,
COUNT(article.article_id) AS total_articles
FROM 
categories
LEFT JOIN 
article ON article.category = categories.categories_id
GROUP BY 
categories.categories_id, categories.categoriesName
ORDER BY 
total_articles DESC;
";
$recents = $db ->query($sql2);
$categories = $db ->query($sql3);
$results = $db ->query($sql);
Database::disconnect(); 
 
?>
 
<section class="page-title-section overlay" data-background="images/backgrounds/batiment-e3mg.jpg">
  <div class="container">
    <div class="row">
      <div class="col-md-8">
        <ul class="list-inline custom-breadcrumb">
          <li class="list-inline-item"><a class="h2 text-primary font-secondary" href="@@page-link">Actualités</a></li>
          <li class="list-inline-item text-white h3 font-secondary @@nasted"></li>
        </ul>
        <!-- <p class="text-lighten">Our courses offer a good compromise between the continuous assessment favoured by some universities and the emphasis placed on final exams by others.</p> -->
      </div>
    </div>
  </div>
</section>
<!-- /page title -->
 
  <section class="main">

$router->map('GET','/filiere-formation',function(){
    require_once "../views/pages/filiere-formation.php";
},'filiere-formation');

$router->map('GET','/formation-continue',function(){
    require_once "../views/pages/buld.php";
},'formation-continue');

$router->map('GET','/lab-genie-procede',function(){
    require_once "../views/pages/buld.php";
},'lab-genie-procede');

$router->map('GET','/lab-geoscience',function(){
    require_once "../views/pages/buld.php";
},'lab-geoscience');



$router->map('GET','/actualite',function(){
    require_once "../views/pages/actualite.php";
},'actualite');
$router->map('GET','/index.php?page=[i]',function(){
    require_once "../views/pages/actualite.php";
},'actualite.actualite');


$router->map('GET','/actualite-[i:id]',function($id){
    require_once "../views/pages/articles-single.php";
},'actualite.single');

$router->map('GET','/ressource',function(){
    require_once "../views/pages/buld.php";
},'notice');
$router->map('GET','/technicien-en-mines-et-metallurgie',function(){
    require_once "../views/pages/buld.php";
},'lmm');
$router->map('GET','/technicien-maitenaice-des-systemes-et-des-equipements',function(){
    require_once "../views/pages/buld.php";
},'lmse');
$router->map('GET','/ingenieur-en-extraction-miniere',function(){

 
 
// Register the Composer autoloader...
require __DIR__.'/../vendor/autoload.php';
//Register route
$whoops = new \Whoops\Run;
$whoops->pushHandler(new \Whoops\Handler\PrettyPageHandler);
$whoops->register();
 
$router = new AltoRouter();
require __DIR__.'/../configs/route.php';
 
 
 
$match = $router->match();
 
// call closure or throw 404 status
if(is_array($match)){
    if(is_callable( $match['target'] ) ) {
        call_user_func_array( $match['target'], $match['params']);
    } else {
        // no route was matched
        // $params = $match['params'];
        // require "../templates/{$match['target']}.php";
        header( $_SERVER["SERVER_PROTOCOL"] . ' 404 Not Found');
    }
}else{
    include "../views/error/404.view.php";
}