şöyle kodlarım var arkdaşlar, ayrı ayrı formda resim inputları var ama veritabanına eklenmiyor.
<form action="../netting/islem.php" method="POST" id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" enctype="multipart/form-data">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name"><span class=""></span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">İkon 1<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<?php
if (strlen($randevucek['randevu_ikon1'])>0) {?>
<img src="../../<?php echo $randevucek['randevu_ikon1']; ?>">
<?php } else {?>
<img width="150" src="../../images/apple-touch-icon.png">
<?php } ?>
<input type="file" id="first-name" name="randevu_ikon1" value="<?php echo $randevucek['randevu_ikon1']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 1 Başlık<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_baslik1" value="<?php echo $randevucek['randevu_baslik1']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 1 İçerik<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_icerik1" value="<?php echo $randevucek['randevu_icerik1']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">İkon 2<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<?php
if (strlen($randevucek['randevu_ikon2'])>0) {?>
<img src="../../<?php echo $randevucek['randevu_ikon2']; ?>">
<?php } else {?>
<img width="150" src="../../images/apple-touch-icon.png">
<?php } ?>
<input type="file" id="first-name" name="randevu_ikon2" value="<?php echo $randevucek['randevu_ikon2']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 2 Başlık<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_baslik2" value="<?php echo $randevucek['randevu_baslik2']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 2 İçerik<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_icerik2" value="<?php echo $randevucek['randevu_icerik2']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">İkon 3<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<?php
if (strlen($randevucek['randevu_ikon3'])>0) {?>
<img src="../../<?php echo $randevucek['randevu_ikon3']; ?>">
<?php } else {?>
<img width="150" src="../../images/apple-touch-icon.png">
<?php } ?>
<input type="file" id="first-name" name="randevu_ikon3" value="<?php echo $randevucek['randevu_ikon3']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 3 Başlık<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_baslik3" value="<?php echo $randevucek['randevu_baslik3']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 3 İçerik<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_icerik3" value="<?php echo $randevucek['randevu_icerik3']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">İkon 4<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<?php
if (strlen($randevucek['randevu_ikon4'])>0) {?>
<img src="../../<?php echo $randevucek['randevu_ikon4']; ?>">
<?php } else {?>
<img width="150" src="../../images/apple-touch-icon.png">
<?php } ?>
<input type="file" id="first-name" name="randevu_ikon4" value="<?php echo $randevucek['randevu_ikon4']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 4 Başlık<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_baslik4" value="<?php echo $randevucek['randevu_baslik4']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 4 İçerik<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_icerik4" value="<?php echo $randevucek['randevu_icerik4']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">İkon 5<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<?php
if (strlen($randevucek['randevu_ikon5'])>0) {?>
<img src="../../<?php echo $randevucek['randevu_ikon5']; ?>">
<?php } else {?>
<img width="150" src="../../images/apple-touch-icon.png">
<?php } ?>
<input type="file" id="first-name" name="randevu_ikon5" value="<?php echo $randevucek['randevu_ikon5']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 5 Başlık<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_baslik5" value="<?php echo $randevucek['randevu_baslik5']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 5 İçerik<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_icerik5" value="<?php echo $randevucek['randevu_icerik5']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">İkon 6<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<?php
if (strlen($randevucek['randevu_ikon6'])>0) {?>
<img src="../../<?php echo $randevucek['randevu_ikon6']; ?>">
<?php } else {?>
<img width="150" src="../../images/apple-touch-icon.png">
<?php } ?>
<input type="file" id="first-name" name="randevu_ikon6" value="<?php echo $randevucek['randevu_ikon6']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 6 Başlık<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_baslik6" value="<?php echo $randevucek['randevu_baslik6']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu 6 İçerik<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" name="randevu_icerik6" value="<?php echo $randevucek['randevu_icerik6']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Adınız Soyadınız<span class=""></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" required="required" name="randevu_formname" value="<?php echo $randevucek['randevu_formname']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Mail Adresi<span class="required"></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="mail" id="first-name" required="required" name="randevu_formmail" value="<?php echo $randevucek['randevu_formmail']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu Günü<span class="required"></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" required="required" name="randevu_formgun" value="<?php echo $randevucek['randevu_formgun']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Randevu Saati<span class="required"></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" required="required" name="randevu_formsaat" value="<?php echo $randevucek['randevu_formsaat']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Telefon Numaranız<span class="required"></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<input type="text" id="first-name" required="required" name="randevu_tel" value="<?php echo $randevucek['randevu_tel']; ?>" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-2 col-sm-2 col-xs-12" for="first-name">Form Mesaj<span class="required"></span>
</label>
<div class="col-md-9 col-sm-9 col-xs-12">
<textarea class="ckeditor" id="editor1" name="randevu_formmesaj"><?php echo $randevucek['randevu_formmesaj']; ?></textarea>
</div>
</div>
<script type="text/javascript">
CKEDITOR.replace( 'editor1',
{
filebrowserBrowseUrl : 'ckfinder/ckfinder.html',
filebrowserImageBrowseUrl : 'ckfinder/ckfinder.html?type=Images',
filebrowserFlashBrowseUrl : 'ckfinder/ckfinder.html?type=Flash',
filebrowserUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files',
filebrowserImageUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images',
filebrowserFlashUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash',
forcePasteAsPlainText: true
}
);
</script>
<div align="right" class="col-md-9 col-sm-9 col-xs-12 col-md-offset-3">
<button type="submit" name="randevukaydet" class="btn btn-primary">Güncelle</button>
</div>
</form>islem.phpif (isset($_POST['randevukaydet'])) {
$uploads_dir = '../../images';
@$tmp_name = $_FILES['randevu_ikon1']["tmp_name"];
@$name = $_FILES['randevu_ikon1']["name"];
@move_uploaded_file($tmp_name, "$uploads_dir/$name");
$uploads_dir = '../../images';
@$tmp_name = $_FILES['randevu_ikon2']["tmp_name"];
@$name = $_FILES['randevu_ikon2']["name"];
@move_uploaded_file($tmp_name, "$uploads_dir/$name");
$uploads_dir = '../../images';
@$tmp_name = $_FILES['randevu_ikon3']["tmp_name"];
@$name = $_FILES['randevu_ikon3']["name"];
@move_uploaded_file($tmp_name, "$uploads_dir/$name");
$uploads_dir = '../../images';
@$tmp_name = $_FILES['randevu_ikon4']["tmp_name"];
@$name = $_FILES['randevu_ikon4']["name"];
@move_uploaded_file($tmp_name, "$uploads_dir/$name");
$uploads_dir = '../../images';
@$tmp_name = $_FILES['randevu_ikon5']["tmp_name"];
@$name = $_FILES['randevu_ikon5']["name"];
@move_uploaded_file($tmp_name, "$uploads_dir/$name");
$uploads_dir = '../../images';
@$tmp_name = $_FILES['randevu_ikon6']["tmp_name"];
@$name = $_FILES['randevu_ikon6']["name"];
@move_uploaded_file($tmp_name, "$uploads_dir/$name");
$ayarkaydet=$db->prepare("UPDATE randevu SET
randevu_ikon1=:randevu_ikon1,
randevu_baslik1=:randevu_baslik1,
randevu_icerik1=:randevu_icerik1,
randevu_ikon2=:randevu_ikon2,
randevu_baslik2=:randevu_baslik2,
randevu_icerik2=:randevu_icerik2,
randevu_ikon3=:randevu_ikon3,
randevu_baslik3=:randevu_baslik3,
randevu_icerik3=:randevu_icerik3,
randevu_ikon4=:randevu_ikon4,
randevu_baslik4=:randevu_baslik4,
randevu_icerik4=:randevu_icerik4,
randevu_ikon5=:randevu_ikon5,
randevu_baslik5=:randevu_baslik5,
randevu_icerik5=:randevu_icerik5,
randevu_ikon6=:randevu_ikon6,
randevu_baslik6=:randevu_baslik6,
randevu_icerik6=:randevu_icerik6,
randevu_formname=:randevu_formname,
randevu_formmail=:randevu_formmail,
randevu_formgun=:randevu_formgun,
randevu_formsaat=:randevu_formsaat,
randevu_formdoktor=:randevu_formdoktor,
randevu_formmesaj=:randevu_formmesaj
WHERE randevu_id=1");
$update=$ayarkaydet->execute(array(
'randevu_baslik1' => $_POST['randevu_baslik1'],
'randevu_icerik1' => $_POST['randevu_icerik1'],
'randevu_baslik2' => $_POST['randevu_baslik2'],
'randevu_icerik2' => $_POST['randevu_icerik2'],
'randevu_baslik3' => $_POST['randevu_baslik3'],
'randevu_icerik3' => $_POST['randevu_icerik3'],
'randevu_baslik4' => $_POST['randevu_baslik4'],
'randevu_icerik4' => $_POST['randevu_icerik4'],
'randevu_baslik5' => $_POST['randevu_baslik5'],
'randevu_icerik5' => $_POST['randevu_icerik5'],
'randevu_baslik6' => $_POST['randevu_baslik6'],
'randevu_icerik6' => $_POST['randevu_icerik6'],
'randevu_formname'=>$_POST['randevu_formname'],
'randevu_formmail'=>$_POST['randevu_formmail'],
'randevu_formgun'=>$_POST['randevu_formgun'],
'randevu_formsaat'=>$_POST['randevu_formsaat'],
'randevu_formdoktor'=>$_POST['randevu_formdoktor'],
'randevu_formmesaj'=>$_POST['randevu_formmesaj'],
'randevu_ikon1' => $_POST['randevu_ikon1'],
'randevu_ikon2' => $_POST['randevu_ikon2'],
'randevu_ikon3' => $_POST['randevu_ikon3'],
'randevu_ikon4' => $_POST['randevu_ikon4'],
'randevu_ikon5' => $_POST['randevu_ikon5'],
'randevu_ikon6' => $_POST['randevu_ikon6']
));
if ($update) {
$resimsilunlink=$_POST['eski_yol'];
unlink("../../$resimsilunlink");
Header("Location:../production/randevu.php?durum=ok");
} else {
Header("Location:../production/randevu.php?durum=no");
}
}Bu sorunu nasıl çözebilirim