D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
mtf.encodersunlimited.com
/
mtadminf
/
Filename :
edit_project.php
back
Copy
<?php require('config.php'); if (isset($_POST['updateproject'])) { $project_id = $_POST['project_id']; $name = $_POST['name']; $year = $_POST['year']; $director = $_POST['director']; $yt_link = $_POST['yt_link']; $status = $_POST['status']; $created_at = $_POST['created_at']; // Handling Image Upload if ($_FILES['image']['name'] != '') { $image = $_FILES['image']['name']; $target = "uploads/" . basename($image); move_uploaded_file($_FILES['image']['tmp_name'], $target); $query = "UPDATE projects SET name='$name', year='$year', director='$director', yt_link='$yt_link', image='$image', status='$status', created_at='$created_at' WHERE id='$project_id'"; } else { $query = "UPDATE projects SET name='$name', year='$year', director='$director', yt_link='$yt_link', status='$status', created_at='$created_at' WHERE id='$project_id'"; } if (mysqli_query($conn, $query)) { echo "Project updated successfully!"; } else { echo "Error updating project: " . mysqli_error($conn); } } ?> <!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>Maa Tara Films</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--> <?php require('config.php'); // Database connection if (isset($_GET['id'])) { $project_id = $_GET['id']; $query = "SELECT * FROM projects WHERE id='$project_id'"; $result = mysqli_query($conn, $query); if (mysqli_num_rows($result) > 0) { $project = mysqli_fetch_array($result); } else { echo "No project found!"; } } ?> <form 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"> <input type="hidden" name="project_id" value="<?= $project['id']; ?>"> <div class="row"> <div class="col-sm-6"> <div class="mb-3"> <label>Name</label> <input class="form-control" type="text" name="name" value="<?= $project['name']; ?>" required> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>Year</label> <input class="form-control" type="text" name="year" value="<?= $project['year']; ?>" required> </div> </div> </div> <div class="row"> <div class="col-sm-6"> <div class="mb-3"> <label>Director</label> <input class="form-control" type="text" name="director" value="<?= $project['director']; ?>" required> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>YouTube Link</label> <input class="form-control" type="url" name="yt_link" value="<?= $project['yt_link']; ?>" required> </div> </div> </div> <div class="row"> <div class="col-sm-6"> <div class="mb-3"> <label>Upload Image</label> <input type="file" name="image" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <img src="uploads/<?= $project['image']; ?>" width="100" height="100" alt="Project Image"> </div> </div> <div class="col-sm-6"> <div class="mb-3"> <label>Status</label> <select class="form-control" name="status" required> <option value="1" <?= ($project['status'] == '1') ? 'selected' : ''; ?>>Active</option> <option value="0" <?= ($project['status'] == '0') ? 'selected' : ''; ?>>Inactive</option> </select> </div> </div> </div> <div class="row"> <div class="col-sm-6"> <div class="mb-3"> <label>Created At</label> <input class="form-control" type="date" name="created_at" value="<?= $project['created_at']; ?>" required> </div> </div> </div> <div class="row"> <div class="col"> <button type="submit" class="btn btn-success" name="updateproject">Update Project</button> <button type="reset" class="btn btn-outline-secondary">Cancel</button> </div> </div> </div> </div> </div> </div> </div> </div> </form> <!-- Container-fluid Ends--> </div> <!-- footer start--> <?php require('footer.php'); ?> <!-- footer end--> </div> </div> </body> </html>