keii.dev
1<?php
2
3session_start();
4
5require_once '../priv/twig.php';
6require_once '../priv/pdo.php';
7require_once '../priv/errorhandler.php';
8
9if(!isset($_SESSION['qr']['is_admin']) || $_SESSION['qr']['is_admin'] === '0')
10{
11 header('Location: index.php');
12 die();
13}
14
15if(isset($_GET['id']))
16{
17 $sql = 'SELECT feedback, rate FROM qr_feedback WHERE qr_events_id = ?';
18 $feedback = DB::prepare($sql)->texecute([$_GET['id']])->fetchAll();
19 $model['feedback'] = $feedback;
20 $model['average'] = array_sum(array_column($feedback, 'rate')) / count($feedback);
21 echo $twig->render('admin/feedback.html', $model);
22 die();
23}
24
25$sql = 'SELECT id, name FROM qr_events';
26$events = DB::prepare($sql)->texecute()->fetchAll();
27echo $twig->render('admin/feedback.html', ['events' => $events]);
28die();