📁 File Manager
Editing:
/home/wedigitalindia/www/manralsolar.com/admin/blog-edit.php
<?php require_once('header.php'); ?> <?php // ================= INIT ================= $error_message = ''; $success_message = ''; $valid = 1; // ================= CHECK ID ================= if (!isset($_REQUEST['id'])) { header('location: logout.php'); exit; } // Fetch existing blog $statement = $pdo->prepare("SELECT * FROM blogs WHERE id=?"); $statement->execute([$_REQUEST['id']]); $total = $statement->rowCount(); if ($total == 0) { header('location: logout.php'); exit; } $row = $statement->fetch(PDO::FETCH_ASSOC); // Existing data $name = $row['name']; $sdesc = $row['short_description']; $desc = $row['description']; $slug = $row['slug']; $status = $row['status']; $mtitle = $row['meta_title']; $mkey = $row['keywords']; $mdesc = $row['meta_description']; $banner = $row['banner']; // ================= FORM SUBMIT ================= if (isset($_POST['form1'])) { if (empty($_POST['title'])) { $valid = 0; $error_message .= "Title cannot be empty.<br>"; } // ================= IMAGE HANDLING ================= if (!empty($_FILES['banner']['name'])) { $bpath_tmp = $_FILES['banner']['tmp_name']; $bext = strtolower(pathinfo($_FILES['banner']['name'], PATHINFO_EXTENSION)); $allowed = ['jpg','jpeg','png','gif','webp']; if (!in_array($bext, $allowed)) { $valid = 0; $error_message .= "Invalid image format.<br>"; } if ($valid == 1) { // ✅ Unique filename with timestamp $bfinal_name = 'blog_' . $_REQUEST['id'] . '_' . time() . '.' . $bext; // Delete old image if (!empty($_POST['obanner']) && file_exists('assets/images/blog-image/' . $_POST['obanner'])) { unlink('assets/images/blog-image/' . $_POST['obanner']); } move_uploaded_file( $bpath_tmp, 'assets/images/blog-image/' . $bfinal_name ); } } else { // Keep old image $bfinal_name = $_POST['obanner']; } // ================= UPDATE ================= if ($valid == 1) { $statement = $pdo->prepare(" UPDATE blogs SET name=?, short_description=?, description=?, status=?, slug=?, banner=?, meta_title=?, keywords=?, meta_description=? WHERE id=? "); $statement->execute([ $_POST['title'], $_POST['sdesc'], $_POST['desc'], $_POST['status'], $_POST['slug'], $bfinal_name, $_POST['mtitle'], $_POST['mkey'], $_POST['mdesc'], $_REQUEST['id'] ]); $success_message = 'Blog updated successfully.'; $banner = $bfinal_name; } } ?> <section class="content-header"> <div class="content-header-left"> <h1>Add Blog</h1> </div> <div class="content-header-right"> <a href="blog.php" class="btn btn-primary btn-sm">View All</a> </div> </section> <section class="content"> <div class="row"> <div class="col-md-12"> <?php if($error_message): ?> <div class="callout callout-danger"> <p> <?php echo $error_message; ?> </p> </div> <?php endif; ?> <?php if($success_message): ?> <div class="callout callout-success"> <p><?php echo $success_message; ?></p> </div> <?php endif; ?> <form class="form-horizontal" action="" method="post" enctype="multipart/form-data"> <div class="box box-info"> <div class="box-body"> <div class="form-group"> <label for="" class="col-sm-3 control-label">Status<span>*</span></label> <div class="col-sm-4"> <select name="status" class="form-control select2"> <option value="1">Active</option> <option value="0">Deactive</option> </select> </div> </div> <div class="form-group"> <label for="" class="col-sm-2 control-label">Existing Image</label> <div class="col-sm-9" style="padding-top:5px"> <img src="assets/images/blog-image/<?php echo $row['banner'];; ?>" alt="Blog Image" style="width:400px;"> </div> </div> <div class="form-group"> <label for="" class="col-sm-3 control-label">Image<span>*</span></label> <div class="col-sm-4"> <input type="file" class="form-control" name="banner"> <input type="hidden" class="form-control" value="<?php echo $banner; ?>" name="obanner"> </div> </div> <div class="form-group"> <label for="" class="col-sm-3 control-label">Title <span>*</span></label> <div class="col-sm-4"> <input type="text" class="form-control" value="<?php echo $name;?>" name="title"> </div> </div> <div class="form-group"> <label for="" class="col-sm-3 control-label">Short Description <span>*</span></label> <div class="col-sm-4"> <textarea type="text" class="form-control" rows="5" cols="30" name="sdesc"><?php echo $sdesc;?></textarea> </div> </div> <div class="form-group"> <label for="" class="col-sm-3 control-label">Description <span>*</span></label> <div class="col-sm-8"> <textarea type="text" class="form-control" id="editor1" cols="30" rows="10" name="desc"><?php echo $desc;?></textarea> </div> </div> <div class="form-group"> <label for="" class="col-sm-3 control-label">Slug<span>*</span></label> <div class="col-sm-4"> <input type="text" class="form-control" value="<?php echo $slug;?>" required name="slug"> </div> </div> <!--<div class="form-group">--> <!-- <label for="" class="col-sm-3 control-label">Meta Title <span>*</span></label>--> <!-- <div class="col-sm-4">--> <!-- <input type="text" class="form-control" value="<?php echo $mtitle;?>" name="mtitle">--> <!-- </div>--> <!--</div>--> <!--<div class="form-group">--> <!-- <label for="" class="col-sm-3 control-label">Meta Keyword <span>*</span></label>--> <!-- <div class="col-sm-4">--> <!-- <textarea type="text" class="form-control" rows="5" name="mkey"><?php echo $mkey;?></textarea>--> <!-- </div>--> <!--</div>--> <!--<div class="form-group">--> <!-- <label for="" class="col-sm-3 control-label">Meta Description <span>*</span></label>--> <!-- <div class="col-sm-4">--> <!-- <textarea type="text" class="form-control" rows="5" name="mdesc"><?php echo $mdesc;?></textarea>--> <!-- </div>--> <!--</div>--> <div class="form-group"> <label for="" class="col-sm-3 control-label"></label> <div class="col-sm-6"> <button type="submit" class="btn btn-success pull-left" name="form1">Submit</button> </div> </div> </div> </div> </form> </div> </div> </section> <?php require_once('footer.php'); ?>
Save
Cancel