query("SELECT * FROM sub_slider_images WHERE id = $id");
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
} else {
die("Record not found.");
}
}
if (isset($_POST['update'])) {
$id = $_POST['id'];
$number = mysqli_real_escape_string($conn, $_POST['number']);
$process_name = mysqli_real_escape_string($conn, $_POST['process_name']);
$h2 = mysqli_real_escape_string($conn, $_POST['h2']);
$paragrpah = mysqli_real_escape_string($conn, $_POST['paragrpah']);
$old_image = $_POST['old_image'];
$uploadDir = "uploads/sub_slider/";
if (!is_dir($uploadDir)) {
mkdir($uploadDir, 0777, true);
}
$image = $old_image;
if (!empty($_FILES['image']['name'])) {
$fileType = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
$allowedTypes = ['jpg', 'jpeg', 'png', 'gif', 'webp'];
if (in_array(strtolower($fileType), $allowedTypes)) {
$newImageName = uniqid('process_') . "_" . time() . "." . $fileType;
$targetFile = $uploadDir . $newImageName;
if (move_uploaded_file($_FILES['image']['tmp_name'], $targetFile)) {
$image = $newImageName;
}
}
}
$sql = "UPDATE sub_slider_images SET
number='$number',
process_name='$process_name',
h2='$h2',
paragrpah='$paragrpah',
image='$image'
WHERE id=$id";
if ($conn->query($sql) === TRUE) {
echo "";
header("Location: gallery.php");
} else {
echo "Error: " . $conn->error . "
";
}
}
?>
OM INTERIOR - Dashborad