<th width="230px">E-mail</th>
<th width="100px">Telefone</th>
<th width="290px">Notas</th>
<th width="10px">Editar</th>
<th width="10px">Apagar</th>
</tr>
<?php
if (!isset($_GET['page'])) {
$page = 1;
} else {
$page = $_GET['page'];
}
$max = $page * 30;
$min = $max - 30;
if (!isset($_GET['searchbox']) or $_GET['searchbox'] == '') {
$guests = $gl->listGuests("1 ORDER BY id DESC LIMIT {$min},{$max}");
} else {
$searchbox = $_GET['searchbox'];
$guests = $gl->listGuests("name LIKE '%{$searchbox}%' LIMIT {$min},{$max}");
}
for ($i = 0; $i < 30; $i++) {
if (!isset($guests[$i])) {
break;
}
echo "\n \t\t\t\t<tr>\n \t\t\t\t<td>" . $guests[$i]["id"] . "</td>\n \t\t\t\t<td>" . $guests[$i]["name"] . "</td>\n\t\t\t\t<td>" . $guests[$i]["email"] . "</td>\n \t\t\t\t<td>" . $guests[$i]["phone"] . "</td>\n\t\t\t\t<td>" . $guests[$i]["comment"] . "</td>\n \t\t\t\t<td><a href=\"edit.php?id=" . $guests[$i]["id"] . "\" class=\"edit\">Editar</a></td>\n \t\t\t<td><a onClick=\"go_there(" . $guests[$i]["id"] . ")\" class=\"delete\">Apagar</a></td>\n \t\t\t\t</tr>";
}
?>
</table>
<div id="listagem">
<?php
$pagem = $page - 1;
//Check User Session
require 'functions.session.php';
DEFINE(LOGINPAGE, 'login.html');
if (!checkSession()) {
echo '<script type="text/javascript">alert("Necessita fazer login primeiro")</script>';
redirectTo(LOGINPAGE, 0);
die;
}
if (!isset($_GET["id"])) {
redirectTo('admin.php', 0);
}
require 'class.guestlist.php';
$gl = new Guestlist();
$id = $_GET['id'];
$guest = $gl->listGuests("id={$id}");
$guest = $guest[0];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ecrã de Administração Guest List</title>
<link href="style.css" media="screen" type="text/css" rel="stylesheet" />
</head>
<body>
<div id="wrapper">
<a href="admin.php" id="adminlogo">Back to Salsa Latina</a>
<a href="session.php?logout=1" id="logout" class="button">Sair</a>
<a href="pdf.php" id="export" class="button">Exportar para PDF</a>
<a href="addnew.php" id="addguest" class="button">Adicionar novo Convidado</a>
