File "post-edit.php"
Full path: /home/fsibplc/public_html/admin/post-edit.php
File
size: 8.63 B (8.63 KB bytes)
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
<?php
include('config/dbcon.php');
include('authentication.php');
//session_start();
include('include/header.php');
?>
<div class="container-fluid px-4">
<div class="row mt-4">
<div class="col-md-12">
<?php include('message.php'); ?>
<div class="card">
<div class="card-header">
<h4>Edit Post<a href="post-view.php" class="btn btn-danger float-end">Back</a></h4>
</div>
<div class="card-body">
<?php
if (isset($_GET['id']) && filter_var($_GET['id'], FILTER_VALIDATE_INT)) {
$post_id = mysqli_real_escape_string($conn, $_GET['id']);
// $gallery_id = $_GET['id'];
$stmt = $conn->prepare("SELECT * FROM posts WHERE id= ? LIMIT 1");
$stmt->bind_param("i", $post_id);
$stmt->execute();
$result = $stmt->get_result();
$stmt->close();
/* $post_query = "SELECT * FROM posts WHERE id= '$post_id' LIMIT 1";
$post_query_res = mysqli_query($con, $post_query);*/
if(mysqli_num_rows($result) > 0)
{
$post_row = mysqli_fetch_array($result);
?>
<form action="code.php" method="POST" enctype="multipart/form-data" id="post-form">
<input type="hidden" name="post_id" value="<?= $post_row['id'] ?>">
<div class="row">
<div class="col-md-6 md-3">
<label for="">Category List</label>
<?php
$category = "SELECT * from categories WHERE category_type ='post' AND status ='0' ";
$category_run = mysqli_query($con, $category);
if(mysqli_num_rows($category_run) > 0 )
{
?>
<select name="category_id" required class="form-control">
<option value="">--Select Category--</option>
<?php
foreach($category_run as $categoryitem)
{
?>
<option value="<?=$categoryitem['id']; ?>" <?= $categoryitem['id']==$post_row['category_id'] ? 'selected':''?> >
<?=$categoryitem['name']; ?>
</option>
<?php
}
?>
</select>
<?php
}else{
}
?>
</div>
<!-- <div class="col-md-6 md-3">
<label for="">Slug (URL)</label>
<input type="text" name="slug" value="<?= $post_row['slug']; ?>" required class="form-control">
</div>-->
<div class="col-md-6 md-3">
<label for="">Name English</label>
<input type="text" name="name" value="<?= $post_row['name']; ?>" required class="form-control">
</div>
<!-- <div class="col-md-6 md-3">
<label for="">Short Description</label>
<input type="text" name="name_bn" value="$post_row['name_bn']" required class="form-control">
</div>
-->
<?php
$description = $post_row['description'];
// $description = stripslashes($description);
$description = str_replace('\r\n', ' ', $description);
$description = str_replace("\'", "'", $description);
?>
<div class="col-md-12 md-3">
<label for="">Description English</label>
<textarea id="summernote1" name="description" required class="form-control" rows="4"><?= $description; ?></textarea>
</div>
<!--<div class="col-md-12 md-3">
<label for="">Description Bangla</label>
<textarea id="summernote2" name="description_bn" required class="form-control" rows="4">$post_row['description_bn']</textarea>
</div>
-->
<div class="col-md-12 md-3">
<label for="">Meta Title</label>
<input type="text" name="meta_title" max="191" value="<?= $post_row['meta_title']; ?>" required class="form-control">
</div>
<div class="col-md-6 md-3">
<label for="">Meta Description</label>
<textarea name="meta_description" required class="form-control" rows="4"><?= $post_row['meta_description'] ?></textarea>
</div>
<div class="col-md-6 md-3">
<label for="">Meta Keyword</label>
<textarea name="meta_keyword" required class="form-control" rows="4"><?= $post_row['meta_keyword'] ?></textarea>
</div>
<div class="col-md-12 md-3">
<label for="">Image</label>
<input type="hidden" name="old_image" value="<?= $post_row['image'] ?>">
<input type="file" name="image" class="form-control">
</div>
<div class="col-md-6 md-3">
<label for="Status">Date</label>
<input id="datepicker" width="276" value="<?= $post_row['date'] ?>" name="date" placeholder="dd-mm-yyyy">
</div>
<input type="hidden" name="author" value="<?= $_SESSION['auth_user']['user_name'];?>" >
<div class="col-md-6 md-3">
<label for="Status">Status</label>
<input type="checkbox" name="status" <?= $post_row['status'] == '1' ? 'checked':''?> width="70px" height="70px" />
Checked = Hidden, Unchecked = Visible
</div>
<div class="col-md-6 md-3">
<button type="submit" class="btn btn-primary" name="post_update">Update Post</button>
</div>
</div>
</form>
<?php
}else{
?>
<h4>No Record Found.</h4>
<?php
}
}
?>
</div>
</div>
</div>
</div>
</div>
<?php
include('include/footer.php');
include('include/script.php');
?>