.

%PDF- %GIF98; %PNG; . Cyber Programmer
Server : Apache
System : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64
User : ndkhermy ( 1200)
PHP Version : 8.5.12
Disable Function : NONE
Directory : /home1/ndkhermy/public_html/website_6ca89795/admin/
Upload File :
Current File : /home1/ndkhermy/public_html/website_6ca89795/admin/solutionsform.php
<?php
include('header.php');
include('../dbcon.php');
include('function.php');

// Check if form is submitted
if (isset($_POST['submit'])) {
    // Retrieve form data
    $sid = $_POST['sid'];
    $title = $_POST['title'];
    $submenu = $_POST['submenu'];
    $subtitle1 = $_POST['subtitle1'];
    $page_title = $_POST['page_title'];
    $description = $_POST['description'];
    $keywords = $_POST['keywords'];
    $robots = $_POST['robots'];
    $canonical = $_POST['canonical'];
    $imagename = $_FILES['simg']['name'];
    $tempname = $_FILES['simg']['tmp_name'];

    // Generate slug from title
    $titleslug = slug($title);

    // Check if an image is uploaded
    if (!empty($imagename)) {
        // Move uploaded file to directory
        move_uploaded_file($tempname, "../dataimg/$imagename");
    }

    // Update query
    $qry = "UPDATE `solution` SET `title`='$title', `submenu`='$submenu', `titleslug`='$titleslug', `page_title`='$page_title', `description`='$description', `keywords`='$keywords', `robots`='$robots', `canonical`='$canonical', `subtitle1`='$subtitle1'";

    // Append image field to query if an image is uploaded
    if (!empty($imagename)) {
        $qry .= ", `image`='$imagename'";
    }

    // Append WHERE clause
    $qry .= " WHERE `id`='$sid'";

    // Execute query
    $run = mysqli_query($conn, $qry);

    // Check if query was successful
    if ($run) {
        echo '<script>alert("Data Updated Successfully");</script>';
        echo '<script>window.location.href="solutionsshow.php";</script>';
    } else {
        echo '<script>alert("Failed to Update Data");</script>';
    }
}

// Fetch director details to pre-populate the form for editing
$sid = $_GET['sid'];
$sql = "SELECT * FROM `solution` WHERE `id`='$sid'";
$run = mysqli_query($conn, $sql);
$updateabout = mysqli_fetch_assoc($run);
?>

<div class="container">
    <div class="title">Update Director</div>
    <script src="https://cdn.ckeditor.com/4.16.2/standard/ckeditor.js"></script>
    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post" enctype="multipart/form-data">
        <div class="form-group">
            <label for="exampleInputEmail1">Title</label>
            <input type="text" class="form-control" id="title" name="title" value="<?php echo $updateabout['title']; ?>" required>
        </div>
        <div class="form-group">
            <label for="exampleInputEmail1">Project Menu</label>
            <input type="text" class="form-control" id="submenu" name="submenu" value="<?php echo $updateabout['submenu']; ?>" required>
        </div>
        <div class="form-group">
            <label for="exampleInputEmail1">Page Title</label>
            <input type="text" class="form-control" name="page_title" value="<?php echo $updateabout['page_title']; ?>">
        </div>
        <div class="form-group">
            <label for="exampleInputEmail1">Description</label>
            <input type="text" class="form-control" name="description" value="<?php echo $updateabout['description']; ?>">
        </div>
        <div class="form-group">
            <label for="exampleInputEmail1">Keywords</label>
            <input type="text" class="form-control" name="keywords" value="<?php echo $updateabout['keywords']; ?>">
        </div>
        <div class="form-group">
            <label for="exampleInputEmail1">Robots</label>
            <input type="text" class="form-control" name="robots" value="<?php echo $updateabout['robots']; ?>">
        </div>
        <div class="form-group">
            <label for="exampleInputEmail1">Canonical</label>
            <input type="text" class="form-control" name="canonical" value="<?php echo $updateabout['canonical']; ?>">
        </div>
        <div class="form-group">
            <label for="exampleInputPassword1">Sub Title</label>
            <textarea id="subtitle1" name="subtitle1"><?php echo $updateabout['subtitle1']; ?></textarea>
        </div>
        <div class="form-group">
            <label for="exampleInputPassword1">Image</label>
            <input type="file" name="simg">
            
        </div>
        <!-- Hidden input field to store the director ID -->
        <input type="hidden" name="sid" value="<?php echo $sid; ?>">
        <button type="submit" name="submit" class="btn btn-primary">Submit</button>
    </form>
    <script>
        CKEDITOR.replace('subtitle1');
    </script>
</div>




            <!-- / Content -->

           
            <div class="content-backdrop fade"></div>
          </div>
          <!-- Content wrapper -->
        </div>
        <!-- / Layout page -->
      </div>
    </div>
    <!-- / Layout wrapper -->

    

    <!-- Core JS -->
    <!-- build:js assets/vendor/js/core.js -->
    <script src="../assets/vendor/libs/jquery/jquery.js"></script>
    <script src="../assets/vendor/libs/popper/popper.js"></script>
    <script src="../assets/vendor/js/bootstrap.js"></script>
    <script src="../assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.js"></script>

    <script src="../assets/vendor/js/menu.js"></script>
    <!-- endbuild -->

    <!-- Vendors JS -->

    <!-- Main JS -->
    <script src="../assets/js/main.js"></script>

    <!-- Page JS -->

    <!-- Place this tag in your head or just before your close body tag. -->
    <script async defer src="https://buttons.github.io/buttons.js"></script>
  </body>
</html>
VaKeR 2022