ikan Uploader :
Directory : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/
Upload File : |
| Current File : /home/u956822991/domains/kalamasserylocalnews.com/public_html/admin/edit-fb.php |
<?php
session_start();
include('include/config.php');
$username = $_SESSION['alogin'];
if(strlen($_SESSION['alogin'])==0) {
header('location:login.php');
} else {
$vid = intval($_GET['id']); // video id
if(isset($_POST['submit'])) {
$videoTitle = $_POST['videoTitle'];
$videoDesc = $_POST['videoDesc'];
$videoFile = $_FILES["videoFile"]["name"];
$postingDate = date("d-m-Y");
$date = date('d-m-Y');
$dir = "fb_videos/$date";
if(!is_dir($dir)) {
mkdir($dir);
}
if($videoFile) {
move_uploaded_file($_FILES["videoFile"]["tmp_name"], "$dir/$videoFile");
$sql = mysqli_query($con, "UPDATE fb_videos SET videoTitle='$videoTitle', videoDesc='$videoDesc', videoFile='$videoFile', updationDate='$postingDate' WHERE id='$vid'");
} else {
$sql = mysqli_query($con, "UPDATE fb_videos SET videoTitle='$videoTitle', videoDesc='$videoDesc', updationDate='$postingDate' WHERE id='$vid'");
}
$_SESSION['msg'] = "Video Updated Successfully !!";
}
?>
<!doctype html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta charset="utf-8">
<title>Edit FB Video | Admin Dashboard</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<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">
</head>
<body data-sidebar="dark">
<div id="layout-wrapper">
<?php include('include/header.php'); ?>
<?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');
}
?>
<div class="main-content">
<div class="page-content">
<div class="container-fluid">
<div class="page-title-box">
<h6 class="page-title">Edit FB Video</h6>
</div>
<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-bs-dismiss="alert"></button>
<strong>Success!</strong> <?php echo htmlentities($_SESSION['msg']); ?>
<?php echo htmlentities($_SESSION['msg']=""); ?>
</div>
<?php } ?>
<div class="card-body">
<?php
$query = mysqli_query($con, "SELECT * FROM fb_videos WHERE id='$vid'");
while($row = mysqli_fetch_array($query)) { ?>
<form method="post" enctype="multipart/form-data">
<div class="mb-3">
<label class="form-label">Video Title</label>
<input type="text" name="videoTitle" value="<?php echo htmlentities($row['videoTitle']); ?>" class="form-control" required>
</div>
<div class="mb-3">
<label class="form-label">Video Description</label>
<textarea name="videoDesc" rows="5" class="form-control" required><?php echo htmlentities($row['videoDesc']); ?></textarea>
</div>
<div class="mb-3">
<label class="form-label">Current Video</label>
<video width="320" height="240" controls>
<source src="fb_videos/<?php echo htmlentities($row['postingDate']); ?>/<?php echo htmlentities($row['videoFile']); ?>" type="video/mp4">
Your browser does not support the video tag.
</video>
</div>
<div class="mb-3">
<label class="form-label">Change Video File</label>
<input type="file" name="videoFile" class="form-control">
</div>
<div class="text-center">
<button type="submit" name="submit" class="btn btn-primary">Update Video</button>
</div>
</form>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include('include/footer.php'); ?>
</div>
</div>
<script src="assets/libs/jquery/jquery.min.js"></script>
<script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
<?php } ?>
........