D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
tapaslight.encodersunlimited.com
/
tadminl
/
Filename :
edit_project.php
back
Copy
<?php session_start(); include 'config.php'; if (!isset($_SESSION['admin_name'])) { echo '<script>window.location.href = "login.php";</script>'; exit; } $id = isset($_GET['id']) ? intval($_GET['id']) : 0; if ($_SERVER['REQUEST_METHOD'] == 'POST') { $name = mysqli_real_escape_string($conn, $_POST['name']); $description = mysqli_real_escape_string($conn, $_POST['description']); $category = mysqli_real_escape_string($conn, $_POST['category']); // Start building the update query $updateQuery = "UPDATE `projects` SET `name` = '$name', `description` = '$description', `category` = '$category'"; for ($i = 1; $i <= 8; $i++) { if (isset($_FILES['img' . $i]) && $_FILES['img' . $i]['error'] == UPLOAD_ERR_OK) { $image = $_FILES['img' . $i]; $imagePath = 'uploads/' . basename($image['name']); if (move_uploaded_file($image['tmp_name'], $imagePath)) { $updateQuery .= ", `img$i` = '$imagePath'"; } else { echo '<script>alert("Error uploading image ' . $i . '.");</script>'; } } } $updateQuery .= " WHERE `id` = $id"; if (mysqli_query($conn, $updateQuery)) { echo '<script>alert("Project updated successfully!"); window.location.href = "projects.php";</script>'; } else { echo '<script>alert("Error updating project.");</script>'; } } // Fetch existing project data $query = "SELECT * FROM `projects` WHERE `id` = $id"; $result = mysqli_query($conn, $query); $project = mysqli_fetch_assoc($result); if (!$project) { echo '<script>alert("Project not found."); window.location.href = "projects.php";</script>'; exit; } ?> <!DOCTYPE html> <html lang="en"> <head> <?php require('style.php'); ?> </head> <body> <!-- loader starts--> <div class="loader-wrapper"> <div class="loader"> <div class="box"></div> <div class="box"></div> <div class="box"></div> <div class="box"></div> <div class="box"></div> </div> </div> <!-- loader ends--> <!-- tap on top starts--> <div class="tap-top"><i data-feather="chevrons-up"></i></div> <!-- tap on tap ends--> <!-- page-wrapper Start--> <div class="page-wrapper default-wrapper" id="pageWrapper"> <!-- Page Header Start--> <div class="page-header"> <div class="header-wrapper row m-0"> <div class="header-logo-wrapper col-auto p-0"> <div class="logo-wrapper"> <a href="index.php"><img class="img-fluid for-light" src="assets/images/ashwikalogo.png" alt=""><img class="img-fluid for-dark" src="assets/images/ashwikalogo.png" alt=""></a> </div> </div> <div class="left-header col-xxl-5 col-xl-6 col-md-4 col-auto box-col-6 horizontal-wrapper p-0"> <div class="left-menu-header"> <ul class="header-left"> <li> <div class="form-group w-100"> <div class="Typeahead Typeahead--twitterUsers"> <div class="u-posRelative d-flex"> <input class="demo-input py-0 Typeahead-input form-control-plaintext w-100" type="text" placeholder="Search anything..." name="q" title=""> </div> </div> </div> </li> </ul> </div> </div> <div class="nav-right col-xxl-7 col-xl-6 col-auto box-col-6 pull-right right-header p-0 ms-auto"> <ul class="nav-menus"> <li class="serchinput"> <div class="serchbox"> <svg> <use href="https://admin.pixelstrap.net/crocsassets/svg/icon-sprite.svg#fill-search"></use> </svg> </div> <div class="form-group search-form"> <input type="text" placeholder="Search here..."> </div> </li> <li> <div class="mode"> <i class="fa-solid fa-circle-half-stroke"></i> </div> </li> <li class="profile-nav onhover-dropdown p-0"> <div class="d-flex align-items-center profile-media"><img class="b-r-10 img-40" src="assets/images/dashboard/profile.png" alt=""> <div class="flex-grow-1"><span>Tapas Lights</span> <p class="mb-0">Welcome Admin</p> </div> </div> </li> </ul> </div> </div> </div> <!-- Page Header Ends --> <!-- Page Body Start--> <div class="page-body-wrapper default-menu default-menu"> <!-- Page Sidebar Start--> <?php require('sidebar.php'); ?> <!-- Page Sidebar Ends--> <div class="page-body"> <div class="container-fluid"> <div class="page-title"> <div class="row"> <div class="col-sm-6 ps-0"> <h3>Edit Project</h3> </div> </div> </div> </div> <!-- Container-fluid starts--> <form action="edit_project.php?id=<?php echo $id; ?>" method="POST" enctype="multipart/form-data"> <div class="container-fluid"> <div class="row"> <div class="col-sm-12"> <div class="card"> <div class="card-body"> <div class="form theme-form"> <div class="row"> <div class="col"> <div class="mb-3"> <label>Name</label> <input class="form-control" type="text" name="name" value="<?php echo htmlspecialchars($project['name'], ENT_QUOTES, 'UTF-8'); ?>" placeholder="Name *" required> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Description</label> <textarea class="form-control" name="description" placeholder="Description *" required><?php echo htmlspecialchars($project['description'], ENT_QUOTES, 'UTF-8'); ?></textarea> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Category</label> <select class="form-control" name="category" required> <option value="">Select Category</option> <option value="government" <?php if ($project['category'] == 'government') echo 'selected'; ?>>Government</option> <option value="private" <?php if ($project['category'] == 'private') echo 'selected'; ?>>Private</option> </select> </div> </div> </div> <div class="row"> <!-- First Row of Image Uploads --> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image 1</label> <input type="file" name="img1" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if (!empty($project['img1'])): ?> <img src="<?php echo 'uploads/' . htmlspecialchars(basename($project['img1']), ENT_QUOTES, 'UTF-8'); ?>" alt="Current Image 1" width="150px"> <?php else: ?> <p>No image found for Image 1</p> <?php endif; ?> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image 2</label> <input type="file" name="img2" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if (!empty($project['img2'])): ?> <img src="<?php echo 'uploads/' . htmlspecialchars(basename($project['img2']), ENT_QUOTES, 'UTF-8'); ?>" alt="Current Image 2" width="150px"> <?php else: ?> <p>No image found for Image 2</p> <?php endif; ?> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image 3</label> <input type="file" name="img3" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if (!empty($project['img3'])): ?> <img src="<?php echo 'uploads/' . htmlspecialchars(basename($project['img3']), ENT_QUOTES, 'UTF-8'); ?>" alt="Current Image 3" width="150px"> <?php else: ?> <p>No image found for Image 3</p> <?php endif; ?> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image 4</label> <input type="file" name="img4" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if (!empty($project['img4'])): ?> <img src="<?php echo 'uploads/' . htmlspecialchars(basename($project['img4']), ENT_QUOTES, 'UTF-8'); ?>" alt="Current Image 4" width="150px"> <?php else: ?> <p>No image found for Image 4</p> <?php endif; ?> </div> </div> </div> <div class="row"> <!-- Second Row of Image Uploads --> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image 5</label> <input type="file" name="img5" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if (!empty($project['img5'])): ?> <img src="<?php echo 'uploads/' . htmlspecialchars(basename($project['img5']), ENT_QUOTES, 'UTF-8'); ?>" alt="Current Image 5" width="150px"> <?php else: ?> <p>No image found for Image 5</p> <?php endif; ?> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image 6</label> <input type="file" name="img6" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if (!empty($project['img6'])): ?> <img src="<?php echo 'uploads/' . htmlspecialchars(basename($project['img6']), ENT_QUOTES, 'UTF-8'); ?>" alt="Current Image 6" width="150px"> <?php else: ?> <p>No image found for Image 6</p> <?php endif; ?> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image 7</label> <input type="file" name="img7" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if (!empty($project['img7'])): ?> <img src="<?php echo 'uploads/' . htmlspecialchars(basename($project['img7']), ENT_QUOTES, 'UTF-8'); ?>" alt="Current Image 7" width="150px"> <?php else: ?> <p>No image found for Image 7</p> <?php endif; ?> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image 8</label> <input type="file" name="img8" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if (!empty($project['img8'])): ?> <img src="<?php echo 'uploads/' . htmlspecialchars(basename($project['img8']), ENT_QUOTES, 'UTF-8'); ?>" alt="Current Image 8" width="150px"> <?php else: ?> <p>No image found for Image 8</p> <?php endif; ?> </div> </div> </div> <div class="row"> <div class="col"> <button type="submit" class="btn btn-primary">Update Project</button> </div> </div> </div> </div> </div> </div> </div> </div> </form> <!-- Container-fluid Ends--> </div> </div> </div> <!-- Page Body Ends --> <!-- footer start--> <?php require('footer.php'); ?> <!-- footer end--> <!-- latest jquery--> <script src="assets/js/jquery-3.6.0.min.js"></script> <!-- Bootstrap js--> <script src="assets/js/bootstrap.bundle.min.js"></script> <!-- feather icon js--> <script src="assets/js/feather-icons/feather.min.js"></script> <script src="assets/js/feather-icons/feather-icon.js"></script> <!-- Config js--> <script src="assets/js/config.js"></script> <!-- Theme js--> <script src="assets/js/script.js"></script> </body> </html>