Php mysql update form with image upload
<?php include "header.php"; $banner_id = $_GET['id']; $query = "SELECT * FROM banners WHERE id = $banner_id"; $q_result = mysqli_query($obj->conn, $query); $res = mysqli_fetch_assoc($q_result); if (isset($_POST['submit'])) { $title = $_POST['title']; $des = $_POST['discription']; $targetDir = "uploads/banners/"; $fileName = basename($_FILES['banner']['name']); $targetFilePath = $targetDir . $fileName; $fileType = pathinfo($targetFilePath, PATHINFO_EXTENSION); move_uploaded_file($_FILES["banner"]["tmp_name"], $targetFilePath); if (!empty($fileName)) { $sql = "UPDATE `banners` SET `title`='$title',`data`='$des',`image`='$fileName' WHERE `id`= '$banner_id'"; } else { $sql = "UPDATE `banners` SET `title`='$title',`data`='$des' WHERE `id`= '$banner_id'"; } $result = mysqli_query($obj->conn, $sql); if ($result == 'true') { echo "<script>alert('Banner updated successfully.')</script>"; echo "<script>window.location = 'banners.php';</script>"; } else { echo "<script>alert('Error')</script>"; } } ?>
