<?php

include('configs/pdo.inc.php');
include('libs/Smarty.class.php');

// create object
$smarty = new Smarty;

// pagina ophalen
$page = empty($_GET['pagina']) ? 1 : (int) $_GET['pagina'];
$smarty->assign('paginaverder', '<div class="span-6 push-6 last"><a href="clubs.php?pagina='. $page-- .'">Volgende pagina >>></a></div>');
$smarty->assign('paginaterug', '<div class="span-8"><a href="clubs.php?pagina='. $page++ .'"><<< Vorige pagina</a></div>');

// Clubs ophalen
try {
    // querry voor alle zichtbare clubs en pagination
    $start_from = $page == 1 ? 0 : (($page - 1) * 10 - 1);
    $query = $oPDO->prepare("SELECT * FROM V_clubs WHERE Zichtbaar = 1 ORDER BY ID ASC LIMIT " . $start_from . ", 1");
    $query->execute();

    // array anders weergeven om ?id=$id goed te laten werken.
    $t = array();
    foreach ($query as $row) {
        $t[$row['ID']] = $row;
    }

    // dat assigned wij dan ook
    $smarty->assign('clubs', $t);

    // Categorieen ophalen
    $categorie = $oPDO->query("SELECT * FROM t_categorie ORDER BY D_categorie ASC");
    $smarty->assign('categorie', $categorie);
    // Provincies ophalen
    $prov = $oPDO->query("SELECT * FROM t_provincies ORDER BY D_provincie ASC");
    $smarty->assign('prov', $prov);
    // Clubteller
    $xclubs = $oPDO->prepare("SELECT ID from V_clubs");
    $xclubs->execute();
} catch (PDOException $e) {
    echo '<pre>';
    echo 'Regelnummer: ' . $e->getLine() . '<br>';
    echo 'Bestand: ' . $e->getFile() . '<br>';
    echo 'Foutmelding: ' . $e->getMessage() . '<br>';
    echo '</pre>';
}

// display it
$smarty->display('extends:layout.tpl|header.tpl|clubs.tpl|footer.tpl');
?>