<?php
require_once "check_login_status.php";
require_once __DIR__ . '/dbmodel/dbmodel.php';
$connection = dbconnect();
global $connection;
$message = $_GET['message'];
$id = $_GET['id'];
$table = $_GET['table'];
# Next 2 lines print
# out the GET variables
# useful for debugging
# var_dump($id);
# var_dump($message);
$query = "UPDATE {$table} SET post = '{$message}' WHERE id = {$id};";
mysqli_query($connection, $query);
closeconnection($connection);
header('location: ADMIN_home.php');
exit;
?>
<!-- <a href="ADMIN_read_news.php" class="btn btn-primary" role="button">Read News Posts</a> -->
function readAllEvents()
{
global $connection;
$events = '';
$query = "SELECT id, created, post FROM events;";
$result = mysqli_query($connection, $query);
while ($row = mysqli_fetch_assoc($result)) {
$id = $row['id'];
$date = $row['created'];
$post = $row['post'];
$events .= "{$post}<a href='ADMIN_delete.php?id={$id}&table=events' class='btn btn-danger btn-sm'>Delete</a><a href='ADMIN_update.php?id={$id}&table=events' class='btn btn-info btn-sm'>Update</a>";
$events .= "<hr>";
}
closeconnection($connection);
return $events;
}
