ikan Uploader :
Directory : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/
Upload File : |
| Current File : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/upload-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');
} else {
if(isset($_GET['del']))
{
mysqli_query($con,"delete from contentnews where id = '".$_GET['id']."'");
$_SESSION['delmsg']="Images deleted !!";
}
if (isset($_POST['submit'])) {
$image1=$_FILES["image1"]["name"];
$postingDate= date("d-m-Y");
$currentDateTime = date("Y-m-d H:i:s");
//for getting product id
$date= date('d-m-Y');
$dir="newscontent/$date";
$newscontent = mysqli_real_escape_string($con, $_POST['newscontent']);
$headlines = mysqli_real_escape_string($con, $_POST['headlines']);
$phoneNo= mysqli_real_escape_string($con, $_POST['phoneNo']);
$postingDate = date("d-m-Y");
if(!is_dir($dir)){
mkdir("newscontent/".$date);
}
move_uploaded_file($_FILES["image1"]["tmp_name"],"newscontent/$date/".$_FILES["image1"]["name"]);
$sql = mysqli_query($con, "INSERT INTO contentnews (headlines,newscontent,phoneNo,image1, postingDate,timestamp) VALUES ('$headlines','$newscontent', '$phoneNo','$image1', '$postingDate', '$currentDateTime')");
if ($sql) {
$_SESSION['msg'] = "News Inserted Successfully !!";
} else {
$_SESSION['msg'] = "Error: " . mysqli_error($con);
}
}
}
?>
<!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">
<!-- App favicon -->
<link rel="shortcut icon" href="assets/images/favicon.ico">
<!-- Bootstrap Css -->
<link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css">
<!-- Icons Css -->
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css">
<!-- App Css-->
<link href="assets/css/app.min.css" id="app-style" 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">
<!-- Begin page -->
<div id="layout-wrapper">
<?php include('include/header.php');?>
<!-- ========== Left Sidebar Start ========== -->
<?php
$sql = mysqli_query($con, "SELECT role FROM admin WHERE username='$username'");
$row = mysqli_fetch_assoc($sql); // Corrected variable name from $result to $sql
if ($row['role'] == 'ADMIN') {
include('include/left-sidebar.php');
}
else {
include('include/reporter-left-sidebar.php');
}
?>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="main-content">
<div class="page-content">
<div class="container-fluid">
<!-- start page title -->
<div class="page-title-box">
<div class="row align-items-center">
<div class="col-md-8">
<h6 class="page-title">Upload News</h6>
</div>
</div>
</div>
<!-- end page title -->
<div class="row">
<div class="col-12">
<div class="card">
<?php if(isset($_POST['submit']))
{?>
<div class="alert alert-success">
<button type="button" class="btn-close" data-dismiss="alert"></button>
<strong>Well done!</strong> <?php echo htmlentities($_SESSION['msg']);?><?php echo htmlentities($_SESSION['msg']="");?>
</div>
<?php } ?>
<?php if(isset($_GET['del']))
{?>
<div class="alert alert-error">
<button type="button" class="ion ion-md-close" data-dismiss="alert"></button>
</div>
<?php } ?>
<br />
<div class="card-body">
<form class="form-horizontal row-fluid" name="insertproduct" method="post" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label" for="basicinput">Headlines</label>
<div class="controls">
<textarea name="headlines" placeholder="Enter Product Description" rows="6" cols="110" class="form-control">
</textarea>
</div>
<label class="control-label" for="basicinput">News Content</label>
<div class="controls">
<textarea name="newscontent" placeholder="Enter Product Description" rows="6" cols="110" class="form-control">
</textarea>
</div>
<label class="control-label" for="basicinput">Phone Number</label>
<div class="controls">
<input type="text" name="phoneNo" placeholder="Enter Phone Number" class="form-control">
</div>
<label class="control-label" for="basicinput">Image1</label>
<div class="fallback">
<input name="image1" id="image1" type="file" required>
</div>
</div>
<div class="text-center mt-3">
<button type="submit" name="submit" class="btn btn-primary waves-effect waves-light">Send Files</button>
</div>
</form>
</div>
</div>
</div> <!-- end col -->
</div> <!-- end row -->
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">
<div class="table-responsive">
<br />
<table class="table table-editable table-nowrap align-middle table-edits">
<thead>
<tr>
<th>ID</th>
<th>HEADLINES</th>
<th>CONTENT</th>
<th>IMAGE</th>
<th>PHONE NO</th>
<th>POSTING DATE</th>
<th>UPDATION DATE</th>
<th>EDIT / DELETE</th>
</tr>
</thead>
<?php
$query = mysqli_query($con, "select * from contentnews order by id desc");
while ($row = mysqli_fetch_array($query)) {
?>
<tbody>
<tr data-id="1">
<td><?php echo htmlentities($row['id']); ?></td>
<td>
<div style="width: 200px; height: 100px; overflow: hidden; border: 1px solid #ccc;">
<?php echo htmlentities($row['headlines']); ?>
</div>
</td>
<td>
<div style="width: 200px; height: 100px; overflow: hidden; border: 1px solid #ccc;">
<?php echo htmlentities($row['newscontent']); ?>
</div>
</td>
<td ><img src="newscontent/<?php echo htmlentities($row['postingDate']);?>/<?php echo htmlentities($row['image1']);?>" width="170px" height="125px"></td>
<td><?php echo htmlentities($row['phoneNo']); ?></td>
<td><?php echo htmlentities($row['postingDate']); ?></td>
<td><?php echo htmlentities($row['updationdate']); ?></td>
<td style="width: 100px">
<a href="edit-news.php?id=<?php echo $row['id']; ?>">
<button type="button" class="btn btn-success waves-effect waves-light">
Edit
</button>
</a>
<a href="upload-news.php?id=<?php echo $row['id']; ?>&del=delete" onClick="return confirm('Are you sure you want to delete?')">
<button type="button" class="btn btn-danger waves-effect waves-light">
Delete
</button>
</a>
</td>
</tr>
</tbody>
<?php } ?>
</table>
<!-- end table -->
</div>
<!-- end -->
</div>
</div>
</div> <!-- end col -->
</div> <!-- end row -->
</div> <!-- container-fluid -->
</div>
<!-- End Page-content -->
<?php include('include/footer.php');?>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<!-- Right bar overlay-->
<div class="rightbar-overlay"></div>
<!-- JAVASCRIPT -->
<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>
<!--tinymce js-->
<script src="assets/libs/tinymce/tinymce.min.js"></script>
<!-- init js -->
<script src="assets/js/pages/form-editor.init.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
........