ikan Uploader :
Directory : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/
Upload File : |
| Current File : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/facebook-news.php |
<?php
session_start();
include('include/config.php');
$username = $_SESSION['alogin'];
date_default_timezone_set('Asia/Kolkata'); // change according to your timezone
if (strlen($_SESSION['alogin']) == 0) {
header('location: login.php');
exit();
} else {
// Delete functionality
if (isset($_GET['del']) && isset($_GET['id'])) {
$id = intval($_GET['id']); // Ensures only integer values
$stmt = $con->prepare("DELETE FROM fb_videos WHERE id = ?");
$stmt->bind_param("i", $id);
if ($stmt->execute()) {
$_SESSION['delmsg'] = "Image deleted successfully!";
} else {
$_SESSION['delmsg'] = "Error deleting image: " . $stmt->error;
}
$stmt->close();
}
// Insert functionality
if (isset($_POST['submit'])) {
$image = $_FILES["image"]["name"];
$postingDate = date("d-m-Y");
$currentDateTime = date("Y-m-d H:i:s");
$date = date('d-m-Y');
$dir = "facebook_news/$date";
$fb_link = mysqli_real_escape_string($con, $_POST['fb_link']);
$headlines = mysqli_real_escape_string($con, $_POST['headlines']);
if (!is_dir($dir)) {
mkdir($dir, 0777, true);
}
move_uploaded_file($_FILES["image"]["tmp_name"], "$dir/$image");
$stmt = $con->prepare("INSERT INTO fb_videos (headlines, fb_link, image, postingDate, Creation_date) VALUES (?, ?, ?, ?, ?)");
$stmt->bind_param("sssss", $headlines, $fb_link, $image, $postingDate, $currentDateTime);
if ($stmt->execute()) {
$_SESSION['msg'] = "News Inserted Successfully !!";
} else {
$_SESSION['msg'] = "Error: " . $stmt->error;
}
$stmt->close();
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta charset="utf-8">
<title>Kalamassery Local News | Admin & Dashboard Template</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="Premium Multipurpose Admin & Dashboard Template" name="description">
<meta content="Themesbrand" name="author">
<link rel="shortcut icon" href="assets/images/favicon.ico">
<link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css">
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css">
<link href="assets/css/app.min.css" rel="stylesheet" type="text/css">
<script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script>
<script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script>
</head>
<body data-sidebar="dark">
<div id="layout-wrapper">
<?php include('include/header.php'); ?>
<!-- Sidebar -->
<?php
$sql = mysqli_query($con, "SELECT role FROM admin WHERE username='$username'");
$row = mysqli_fetch_assoc($sql);
if ($row['role'] == 'ADMIN') {
include('include/left-sidebar.php');
} else {
include('include/reporter-left-sidebar.php');
}
?>
<!-- Main Content -->
<div class="main-content">
<div class="page-content">
<div class="container-fluid">
<!-- Page Title -->
<div class="page-title-box">
<div class="row align-items-center">
<div class="col-md-8">
<h6 class="page-title">Facebook News</h6>
</div>
</div>
</div>
<!-- Alert Messages -->
<?php if (isset($_SESSION['msg'])) { ?>
<div class="alert alert-success">
<strong>Success!</strong> <?php echo htmlentities($_SESSION['msg']); ?>
</div>
<?php unset($_SESSION['msg']); ?>
<?php } ?>
<?php if (isset($_SESSION['delmsg'])) { ?>
<div class="alert alert-danger">
<strong>Deleted!</strong> <?php echo htmlentities($_SESSION['delmsg']); ?>
</div>
<?php unset($_SESSION['delmsg']); ?>
<?php } ?>
<!-- Form for Adding News -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<form class="form-horizontal row-fluid" method="post" enctype="multipart/form-data">
<div class="form-group">
<label>Headlines</label>
<textarea name="headlines" placeholder="Enter Headlines" rows="4" class="form-control"></textarea>
</div>
<div class="form-group">
<label>Facebook Link</label>
<input type="text" name="fb_link" placeholder="Enter Facebook Link" class="form-control" required>
</div>
<div class="form-group">
<label>Image</label>
<input type="file" name="image" required class="form-control">
</div>
<div class="text-center mt-3">
<button type="submit" name="submit" class="btn btn-primary">Add News</button>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- Display Existing News -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<div class="table-responsive">
<table class="table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Headlines</th>
<th>Image</th>
<th>Posting Date</th>
<th>Creation Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
$query = mysqli_query($con, "SELECT * FROM fb_videos ORDER BY id DESC");
while ($row = mysqli_fetch_array($query)) {
?>
<tr>
<td><?php echo htmlentities($row['id']); ?></td>
<td><?php echo htmlentities($row['headlines']); ?></td>
<td><img src="facebook_news/<?php echo htmlentities($row['postingDate']); ?>/<?php echo htmlentities($row['image']); ?>" width="150" height="100"></td>
<td><?php echo htmlentities($row['postingDate']); ?></td>
<td><?php echo htmlentities($row['Creation_date']); ?></td>
<td>
<a href="edit-fb.php?id=<?php echo $row['id']; ?>" class="btn btn-success btn-sm">Edit</a>
<a href="facebook-news.php?id=<?php echo $row['id']; ?>&del=1" onClick="return confirm('Are you sure you want to delete?')" class="btn btn-danger btn-sm">Delete</a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div> <!-- container-fluid -->
</div> <!-- End Page-content -->
<?php include('include/footer.php'); ?>
</div> <!-- end main content -->
</div> <!-- END layout-wrapper -->
<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/libs/metismenu/metisMenu.min.js"></script>
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/node-waves/waves.min.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
........