Veri tabanından x id sini çağırıp resim ve yazıları aşağıdaki gibi düzenliyorum dilerseniz bunuda kullanabilirsiniz.
<?php
include_once('config.php');
if(isset($_GET['delete_id']))
{
$id = strip_tags(trim($_GET['delete_id']));
$stmt_select = $DB_con->prepare('SELECT SLIDE_GORSEL FROM slideler WHERE SLIDE_ID=:id');
$stmt_select->execute(array(':uid'=>$id));
$imgRow=$stmt_select->fetch(PDO::FETCH_ASSOC);
unlink("../images/slideler/".$imgRow['resim']);
$stmt_delete = $DB_con->prepare('DELETE FROM icerikler WHERE SLIDE_ID=:id');
$stmt_delete->bindParam(':id',$id);
$stmt_delete->execute();
header("Location: index.php");
}
if(isset($_GET['edit_id']) && !empty($_GET['edit_id']))
{
$id = strip_tags(trim($_GET['edit_id']));
$stmt_edit = $DB_con->prepare('SELECT SLIDE_ADI, SLIDE_LINK, SLIDE_GORSEL, SLIDE_LINKADI FROM slideler WHERE SLIDE_ID =:uid');
$stmt_edit->execute(array(':uid'=>$id));
$edit_row = $stmt_edit->fetch(PDO::FETCH_ASSOC);
extract($edit_row);
}else{
header("Location: slideler.php");
}
if(isset($_POST['btn_save_updates']))
{
$slideadi = strip_tags(trim($_POST['slideadi']));
$slidelink = strip_tags(trim($_POST['slidelink']));
$slideadicek = $DB_con->prepare('SELECT LINK_ADI, LINK_YOLU FROM linkler WHERE LINK_YOLU =:linkyolu');
$slideadicek->execute(array(':linkyolu'=>$slidelink));
$slideadi_cek = $slideadicek->fetch(PDO::FETCH_ASSOC);
extract($slideadi_cek);
$slidelinkadibu = $slideadi_cek['LINK_ADI'];
$imgFile = $_FILES['slidegorsel']['name'];
$tmp_dir = $_FILES['slidegorsel']['tmp_name'];
$imgSize = $_FILES['slidegorsel']['size'];
if($imgFile)
{
$upload_dir = '../images/slideler/';
$imgExt = strtolower(pathinfo($imgFile,PATHINFO_EXTENSION)); // get image extension
$valid_extensions = array('jpeg', 'jpg', 'png', 'gif'); // valid extensions
$SLIDE_GORSEL = rand(1000,1000000).".".$imgExt;
if(in_array($imgExt, $valid_extensions))
{
if($imgSize < 10000000)
{
unlink($upload_dir.$edit_row['SLIDE_GORSEL']);
move_uploaded_file($tmp_dir,$upload_dir.$SLIDE_GORSEL);
}
else
{
$errMSG = "Sorry, your file is too large it should be less then 10 MB";
}
}
else
{
$errMSG = "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
}
}else{
$SLIDE_GORSEL = $edit_row['SLIDE_GORSEL'];
}
if(!isset($errMSG))
{
$stmt = $DB_con->prepare('UPDATE slideler SET SLIDE_ADI=:slideadi, SLIDE_LINK=:slidelink, SLIDE_GORSEL=:slidegorsel, SLIDE_LINKADI=:slidelinkadi WHERE SLIDE_ID=:uid');
$stmt->bindParam(':slideadi',$slideadi);
$stmt->bindParam(':slidelink',$slidelink);
$stmt->bindParam(':slidegorsel',$SLIDE_GORSEL);
$stmt->bindParam(':slidelinkadi',$slidelinkadibu);
$stmt->bindParam(':uid',$id);
if($stmt->execute()){
?>
<script>
alert('Güncelleme Başarılı ...');
window.location.href='slideler.php';
</script>
<?php
}else{
$errMSG = "Sorry Data Could Not Updated !";
}
}
}ben bu şekilde kullanıyorum en basit haliyle. belki işine yarar.