HOME BAPTISMOS ADMIN
” . $row[‘date’] . “ |”;
}
$date_filter = $_GET[“id”];
$con=mysqli_connect(“internal-db.s5467.gridserver.com”,”db5467_peterpan”,”gliderpeterpan”,”db5467_peterpan”);
// Check connection
if (mysqli_connect_errno())
{
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}
$sql = “select name, phone, voucher_nr, time, event.date, slot_status, video, event.event_status from register join client on register.client_id=client.client_id right join slot on slot.slot_id=register.slot_id join event on slot.event_id=event.event_id where event.event_status=’OPEN'”;
if ($date_filter != “”){
$sql .= ” and event.date='” . $date_filter . “‘”;
}
$sql .= ” order by time”;
$result = mysqli_query($con,$sql);
echo “
# | Nome | Contacto | Voucher Nr | Horário | Notas | ||
---|---|---|---|---|---|---|---|
RESERVADO | VIDEO |
“;
mysqli_close($con);
?>