Bekijk alle posts

$sql = mysql_query("SELECT * FROM tabel where cat = 'Een'");
$num_rows_sql = mysql_num_rows($sql);

$sql_cat = mysql_query("SELECT cat, COUNT(*) as aantal FROM tab GROUP BY cat");
if ( $sql_cat != false)
{
if ( mysql_num_rows($sql_cat) == 0 )
{
echo '<li>Leeg..</li>';
}
else
{
while($object = mysql_fetch_assoc($sql_cat))
{
$cat = $object["cat"];
$nr = $object["aantal"];
echo '<li><a href="#" class="cCat" id="'.$cat.'">'.$cat.'</a> <span class="ui-li-count">'.$nr.'</span></li>';
}// end while
}// end else
}// end if
?>

pagina.php?=id=10&titel=test

page.php?=id=10&titel=test

RewriteRule page-(.*)-(.*)$ page.php?id=$1&titel=$2 [L]

page-10-test

<?php
$id = $_GET['id'];
if ( !empty ( $id ) AND is_numeric ($id) )
{
$title = $_GET['title'];
if (empty ( $title ))
{
$title = "title";
}
header( "Status: 301 Moved Permanently" );
header( "Location: (Log in om link te zien!) " );
exit(0); // dit is optioneel, maar wordt wel aangeraden. Hiermee voorkom je onnodige output

}
else
{
echo "<meta http-equiv=\"refresh\" content=\"0;URL=http://www.web.com\">\n";
}
?>

<?php
//pagina lezen

if (isset($_GET['pagina']) AND is_numeric ($_GET['pagina'])){
$pagina = $_GET['pagina']; }
else{
$pagina = 1;
}

$regels = 9;

$sql = mysql_query("SELECT * FROM table");
$aantal = mysql_num_rows($sql);
$begin = (($pagina*$regels)-$regels);


//data ophalen
$query = mysql_query("SELECT * FROM table ORDER BY id DESC LIMIT $begin,$regels");
//enz..
?>

<STYLE>
/* Page Numbers */
div.pagination {padding: 3px;margin: 3px;}
div.pagination a {text-align: center; padding: 2px 5px 2px 5px;margin: 2px; border: 1px solid #000000; text-decoration: none; color: #000;}
div.pagination a:hover, div.pagination a:active{ border: 1px solid #000000; color: #000; background-color:#66CCFF}
div.pagination a:visited { border: 1px solid #000000; color: #000;}
div.pagination span.current {padding: 2px 5px 2px 5px; margin: 2px; border: 1px solid #000000; font-weight: bold; background-color: #000099; color: #FFF;}
div.pagination span.disabled { padding: 2px 5px 2px 5px; margin: 2px; border: 1px solid #000000; color: #DDD; }
</STYLE>
<div class="pagination">

<?php

$totalPages = ceil($aantal/$regels);

echo 'Huidige pagina '.$pagina.'  <i><small>(totaal paginas: '.$totalPages.')</small></i><br><br>';

function show_pagenumbers($start, $end, $pagina, $totalPages) {
$str = '';
for ($i = $start; $i <= $end; $i++) {
if ($pagina == $i) {
$str .= '<span class="current">'.$i.'</span>';
}
else{
$str .= '<a href="index.php?pagina='.$i.'" title="Ga naar pagina '.$i.'">'.$i.'</a>';
}
}
return $str;
}

if ($totalPages >= 1) {
if($totalPages > 7) {
$start = $pagina - 3;
$end = $pagina + 3;

while($start < 1) {
$start++;
$end++;
}
while($end > $totalPages) {
$start--;
$end--;
}
echo ( $pagina == 1 ) ? '<span class="disabled">« Eerste</span>  ' : '<a href="index.php?pagina=1" title="Ga naar pagina 1">« Eerste</a>  ';
echo ( $pagina > 4 ) ? '...' : '';

echo show_pagenumbers($start, $end, $pagina, $totalPages);

echo ( $pagina < $totalPages - 3 ) ? '...' : '  ';
echo ( $pagina == $totalPages ) ? '<span class="disabled">:Laatste »</span>' : '<a href="index.php?pagina='.$totalPages.'" title="Ga naar pagina'.$totalPages.'">Laatste »</a>';
}
else {
echo show_pagenumbers(1, $totalPages, $pagina, $totalPages);
}
}
else {
echo 'geen paginas';
}
?>
</div>