📁 File Manager
Editing:
/home/wedigitalindia/public_html/manralsolar.com/admin/certificate-edit.php
<?php require_once('header.php'); ?> <?php $error_message = ''; $success_message = ''; /* |-------------------------------------------------------------------------- | Check ID |-------------------------------------------------------------------------- */ if (!isset($_REQUEST['id']) || empty($_REQUEST['id'])) { header('location: logout.php'); exit; } $id = (int) $_REQUEST['id']; /* |-------------------------------------------------------------------------- | Get Certificate |-------------------------------------------------------------------------- */ $statement = $pdo->prepare( "SELECT * FROM tbl_certificate WHERE id = ?" ); $statement->execute([$id]); $row = $statement->fetch(PDO::FETCH_ASSOC); if (!$row) { header('location: logout.php'); exit; } $caption = $row['caption']; $photo = $row['photo']; /* |-------------------------------------------------------------------------- | Handle Form Submission |-------------------------------------------------------------------------- */ if (isset($_POST['form1'])) { /* |-------------------------------------------------------------------------- | Get Caption |-------------------------------------------------------------------------- */ $caption = trim($_POST['page_name'] ?? ''); /* |-------------------------------------------------------------------------- | Update Caption |-------------------------------------------------------------------------- */ $statement = $pdo->prepare( "UPDATE tbl_certificate SET caption = ? WHERE id = ?" ); $statement->execute([ $caption, $id ]); /* |-------------------------------------------------------------------------- | Check Uploaded File |-------------------------------------------------------------------------- */ if ( isset($_FILES['photo']) && $_FILES['photo']['error'] === UPLOAD_ERR_OK ) { $path = $_FILES['photo']['name']; $path_tmp = $_FILES['photo']['tmp_name']; /* |-------------------------------------------------------------------------- | Get Extension |-------------------------------------------------------------------------- */ $ext = strtolower( pathinfo($path, PATHINFO_EXTENSION) ); /* |-------------------------------------------------------------------------- | Allowed File Types |-------------------------------------------------------------------------- */ $allowed_ext = [ 'jpg', 'jpeg', 'png', 'gif', 'webp', 'pdf' ]; /* |-------------------------------------------------------------------------- | Validate Extension |-------------------------------------------------------------------------- */ if (!in_array($ext, $allowed_ext, true)) { $error_message .= 'Only JPG, JPEG, PNG, WEBP, GIF and PDF files are allowed.<br>'; } else { /* |-------------------------------------------------------------------------- | Generate New File Name |-------------------------------------------------------------------------- */ $final_name = 'photo-' . $id . '-' . time() . '.' . $ext; /* |-------------------------------------------------------------------------- | Upload Path |-------------------------------------------------------------------------- */ $upload_path = 'img/certificate/' . $final_name; /* |-------------------------------------------------------------------------- | Upload New File |-------------------------------------------------------------------------- */ if (move_uploaded_file($path_tmp, $upload_path)) { /* |-------------------------------------------------------------------------- | Delete Previous File |-------------------------------------------------------------------------- */ if ( !empty($photo) && file_exists('img/certificate/' . $photo) ) { unlink( 'img/certificate/' . $photo ); } /* |-------------------------------------------------------------------------- | Update Photo |-------------------------------------------------------------------------- */ $statement = $pdo->prepare( "UPDATE tbl_certificate SET photo = ? WHERE id = ?" ); $statement->execute([ $final_name, $id ]); /* |-------------------------------------------------------------------------- | Update Current Photo |-------------------------------------------------------------------------- */ $photo = $final_name; } else { $error_message .= 'Failed to upload the file. Please check the upload folder.<br>'; } } } elseif ( isset($_FILES['photo']['error']) && $_FILES['photo']['error'] !== UPLOAD_ERR_NO_FILE ) { $error_message .= 'There was an error uploading the file.<br>'; } /* |-------------------------------------------------------------------------- | Success Message |-------------------------------------------------------------------------- */ if (empty($error_message)) { $success_message = 'Certificate updated successfully.'; } } ?> <section class="content-header"> <div class="content-header-left"> <h1>Edit Certificate</h1> </div> <div class="content-header-right"> <a href="certificate.php" class="btn btn-primary btn-sm" > View All </a> </div> </section> <section class="content"> <div class="row"> <div class="col-md-12"> <!-- ERROR --> <?php if (!empty($error_message)): ?> <div class="callout callout-danger"> <p> <?php echo $error_message; ?> </p> </div> <?php endif; ?> <!-- SUCCESS --> <?php if (!empty($success_message)): ?> <div class="callout callout-success"> <p> <?php echo $success_message; ?> </p> </div> <?php endif; ?> <!-- FORM --> <form class="form-horizontal" action="" method="post" enctype="multipart/form-data" > <!-- Form Identifier --> <input type="hidden" name="form1" value="1" > <!-- ID --> <input type="hidden" name="id" value="<?php echo $id; ?>" > <div class="box box-info"> <div class="box-body"> <!-- ================================================= CAPTION ================================================== --> <div class="form-group"> <label class="col-sm-2 control-label"> Certificate Caption </label> <div class="col-sm-4"> <input type="text" class="form-control" name="page_name" value="<?php echo htmlspecialchars( $caption, ENT_QUOTES, 'UTF-8' ); ?>" > </div> </div> <!-- ================================================= EXISTING FILE ================================================== --> <div class="form-group"> <label class="col-sm-2 control-label"> Existing File </label> <div class="col-sm-6" style="padding-top:6px;" > <?php if (!empty($photo)): ?> <?php $extension = strtolower( pathinfo( $photo, PATHINFO_EXTENSION ) ); ?> <?php if ($extension === 'pdf'): ?> <!-- PDF --> <div style=" width:300px; height:200px; background:#f5f5f5; border:1px solid #ddd; display:flex; align-items:center; justify-content:center; text-align:center; " > <div> <i class="fa fa-file-pdf-o" style=" font-size:60px; color:#e3342f; " ></i> <br> <a href="img/certificate/<?php echo htmlspecialchars( $photo, ENT_QUOTES, 'UTF-8' ); ?>" target="_blank" class="btn btn-primary btn-sm" style="margin-top:10px;" > View PDF </a> </div> </div> <?php else: ?> <!-- IMAGE --> <img src="img/certificate/<?php echo htmlspecialchars( $photo, ENT_QUOTES, 'UTF-8' ); ?>" style=" width:300px; height:300px; object-fit:contain; border:1px solid #ddd; " > <?php endif; ?> <?php else: ?> <p> No file available. </p> <?php endif; ?> </div> </div> <!-- ================================================= UPLOAD NEW FILE ================================================== --> <div class="form-group"> <label class="col-sm-2 control-label"> Upload New Photo/PDF </label> <div class="col-sm-4" style="padding-top:6px;" > <input type="file" name="photo" accept=".jpg,.jpeg,.png,.gif,.webp,.pdf" > <br> <small class="text-muted"> Allowed: JPG, JPEG, PNG, GIF, WEBP and PDF </small> </div> </div> <!-- ================================================= SUBMIT ================================================== --> <div class="form-group"> <label class="col-sm-2 control-label"></label> <div class="col-sm-6"> <button type="submit" class="btn btn-success" > Submit </button> </div> </div> </div> </div> </form> </div> </div> </section> <?php require_once('footer.php'); ?>
Save
Cancel