set_charset("utf8mb4"); $result = $mysqli->query("SELECT count(*) AS anz FROM hz_guestbook"); $line = $result->fetch_assoc(); $pages = ceil($line["anz"] / $entrys); ?>

Ins Gästebuch eintragen

1) { if ($page > 1) { $lastPage = $page - 1; echo "< "; } else { echo "< "; } for ($i = 1; $i <= $pages; $i++) { if ($i == $page) { echo "$i"; } else { echo "$i"; } if ($i < $pages) { echo " | "; } } if ($page < $pages) { $nextPage = $page + 1; echo " >"; } else { echo " >"; } } ?>

query("SELECT name, email, text, DATE_FORMAT(date, '%d.%m.%Y') date FROM hz_guestbook ORDER BY id DESC LIMIT $offset, $entrys"); while ($line = $result->fetch_assoc()) { ?> $line[name]"; } else { echo "$line[name]"; } echo " schrieb am $line[date]"; ?>