$anzahl = 5; if ($_REQUEST['page'] == "") { $page = 1; } $limit = ($page - 1) * $anzahl; $db->query("SELECT author, text, UNIX_TIMESTAMP(date) AS datum\n\t\t\tFROM guestbook\n\t\t\tORDER BY date DESC\n\t\t\tLIMIT {$limit},{$anzahl}"); while ($db->next_record()) { echo "<table>"; echo "<tr><td>"; echo "User: <span style=\"font-style: italic; font-weight: bold;\">" . htmlentities($db->record['author']) . "</span>"; echo "</tr><tr><td>"; echo "Date: " . date("d.m.Y \\u\\m H:i", $db->record['datum']); echo "</td></tr><tr><td>"; echo nl2br(htmlentities($db->record['text'])); echo "</td></tr>"; echo "</table>"; echo "<hr>"; } echo '<form action="gb_input.php"><input type="submit" value="Hab auch was zu sagen"></form><br>'; if ($page != 1) { echo '<a href="gb_output.php?page=' . ($page - 1) . '">Back</a> '; } $db->query('SELECT count(*) FROM guestbook'); $rows = $db->result(); if ($rows - ($page * $anzahl + $anzahl - $rows % $anzahl) >= 0) { echo '<a href="gb_output.php?page=' . ($page + 1) . '">Forward</a><br>'; } echo "\$limit: " . $limit . "<br>"; echo "\$rows: " . $rows . "<br>"; echo "\$page * \$anzahl: " . $page * $anzahl . "<br>"; echo 3 % 5;
$album[$i] = ucfirst($album[$i]); } } $album = implode(' ', $album); //check for typos in album name so we don't insert a new album by mistake if ($_POST['usefromdb']) { $album = $album_db; } if (!isset($_POST['confirmed']) || $_POST['confirmed'] != 1) { $firstletter = substr($album, 0, 1); $db->query("SELECT id, name FROM catalbums WHERE name LIKE '{$firstletter}%'"); $db2 = new db_local(); while ($db->next_record()) { $db2->query("SELECT artist FROM catfiles WHERE album='" . $db->record['id'] . "'"); $distance = levenshtein($album, $db->record['name']); if ($distance > 0 && $distance < 4 && $db2->result() == $artist) { printf("<form action=\"{$PHP_SELF}\" method=\"POST\">\r\n\t\t\t\t\t<p align=\"center\">" . $lang['add2']['spellcheckerinfo'] . "</p>\r\n\t\t\t\t\t<p align=\"center\"><b>" . $db->record['name'] . "</b><br>\r\n\t\t\t\t\t<input type=\"submit\" name=\"usefromdb\" value=\"" . $lang['add2']['usethisalbum'] . "\">\r\n\t\t\t\t\t</p>", $artist); echo '<p align="center"> <input type="hidden" name="artist" value="' . htmlentities($artist) . '"> <input type="hidden" name="title" value="' . htmlentities($title) . '"> <input type="text" name="album" size="' . (strlen($album) + 5) . '" maxlength="60" value="' . htmlentities($album) . '"> <input type="hidden" name="album_db" value="' . htmlentities($db->record['name']) . '"> <input type="hidden" name="content" value="' . htmlentities($content) . '"> <input type="hidden" name="addedby" value="' . htmlentities($addedby) . '"> <input type="hidden" name="confirmed" value="1"><br> <input type="submit" name="usefromuser" value="' . $lang['add2']['confirmnewalbum'] . '"> </p> </form> '; $design->addVar("basic", "PAGECONTENT", $design->getParsedTemplate("")); $design->displayParsedTemplate("basic");