<?php
if ($_SERVER['REQUEST_METHOD'] === "POST") {
if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) {
$check = getimagesize($_FILES['image']['tmp_name']);
if ($check !== false) {
$imageContent = file_get_contents($_FILES['image']['tmp_name']);
$stmt = $con->prepare("INSERT INTO events(Image, Text, Datetime, Show_Hide)
VALUES(:img, :txt, NOW(), 1)");
$stmt->bindParam(":img", $imageContent, PDO::PARAM_LOB);
$stmt->bindParam(":txt", $_POST['event_info']);
$stmt->execute();
header("Location: " . $_SERVER['PHP_SELF'] . '?ev=Add&lang=' . $language);
exit();
} else {
echo "Error: Invalid image file.";
}
} else {
echo "Error: No image uploaded or upload failed.";
}
}
$evSt = $con->prepare("SELECT * FROM events ORDER BY ID DESC");
$evSt->execute();
$evRows = $evSt->fetchAll(PDO::FETCH_ASSOC);
if (!empty($evRows)) {
?>
<div class="events_manage w-100">
<?php foreach ($evRows as $data): ?>
<div class="event_card card">
<img src="data:image/jpeg;base64,<?php echo base64_encode($data['Image']); ?>" alt="">
</div>
<?php endforeach; ?>
</div>
<?php
}
?>