query("DELETE FROM `news` WHERE `id` = $id");
echo '';
}
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (!empty($_FILES['image']['name'])) {
$image = photo_upload('image', 'news');
if ($image['status']) {
$con->query("INSERT INTO `news` (`id`, `timestamp`, `image`, `date`, `heading`, `description`)
VALUES (NULL, CURRENT_TIMESTAMP, '".$image['file_name']."','".$_POST['date']."','".$_POST['heading']."','".$_POST['description']."')");
echo '';
} else {
echo '';
}
}
}
// Fetch all news
$query = "SELECT * FROM `news`";
$result = $con->query($query);
?>
| Image |
Date |
Heading |
Description |
Action |
fetch_assoc()) {
echo '';
echo ' | ';
echo ''.$row['date'].' | ';
echo ''.$row['heading'].' | ';
echo ''.$row['description'].' | ';
echo 'Delete | ';
echo '
';
}
?>