prepare("UPDATE gallery SET image_path=?, title_ar=?, title_tr=?, title_en=? WHERE id=?");
$stmt->bind_param("ssssi", $img_name, $t_ar, $t_tr, $t_en, $gallery_id);
$msg = "updated";
} else {
$stmt = $conn->prepare("INSERT INTO gallery (image_path, title_ar, title_tr, title_en) VALUES (?, ?, ?, ?)");
$stmt->bind_param("ssss", $img_name, $t_ar, $t_tr, $t_en);
$msg = "added";
}
} else {
if (!empty($gallery_id)) {
$stmt = $conn->prepare("UPDATE gallery SET title_ar=?, title_tr=?, title_en=? WHERE id=?");
$stmt->bind_param("sssi", $t_ar, $t_tr, $t_en, $gallery_id);
$msg = "updated";
}
}
$stmt->execute();
header("Location: gallery.php?msg=" . $msg);
exit();
}
// معالجة الحذف
if (isset($_GET['delete'])) {
$id = (int)$_GET['delete'];
$res = $conn->query("SELECT image_path FROM gallery WHERE id = $id");
$img = $res->fetch_assoc();
if($img) @unlink("uploads/" . $img['image_path']);
$conn->query("DELETE FROM gallery WHERE id = $id");
header("Location: gallery.php?msg=deleted");
exit();
}
?>
<?php echo $t['gallery']; ?> | <?php echo $t['institute_name']; ?>
|
|
|
query("SELECT * FROM gallery ORDER BY id DESC");
while($row = $result->fetch_assoc()):
?>
 |
|
|
