Arkadaşlar selam, dün bir insert sorunu yaşamıştım bugünde aynı konu ile ilgili bir update problemim var desteğinize ihtiyacım var.
Formun bulunduğu proje-duzenle.php dosyamın içeriği burada;
<?php require_once"header.php"; ?>
<!-- row -->
<div class="container">
<div class="row">
<div class="col-lg-12 col-md-12">
<div class="card">
<?php
if ($_GET['durum']=="ok") {
echo "İşlem başarılı";
} elseif ($_GET['durum']=="no") {
echo "İşlem başarısız";
}
?>
<div class="card-body">
<?php
$projelersor=$db->prepare("SELECT * from projeler where id=:id ");
$projelersor->execute(array(
'id' => $_GET['id']
));
$projelercek=$projelersor->fetch(PDO::FETCH_ASSOC);
?>
<form action="run.php" method="POST">
<input type="hidden" name="user_id" value="<?php echo $user_id?>">
<div class="main-content-label mg-b-5">
Proje Temel Bilgileri
</div>
<div class="row row-sm">
<div class="col-2">
<div class="form-group mg-b-0">
<label class="form-label">Proje ID: <span class="tx-danger"></span></label>
<input class="form-control" placeholder="" required="" type="text" value="<?php echo $projelercek['id'] ?>" disabled="yes">
</div>
</div>
<div class="col-2">
<div class="form-group mg-b-0">
<label class="form-label">Proje Durum: <span class="tx-danger"></span></label>
<select name="durum" class="form-control select">
<option value="Aktif">Aktif</option>
<option value="Pasif">Pasif</option>
</select>
</div>
</div>
<div class="col-4">
<div class="form-group mg-b-0">
<label class="form-label">Proje Adı: <span class="tx-danger"></span></label>
<input class="form-control" name="adi" placeholder="" required="" type="text" value="<?php echo $projelercek['adi'] ?>">
</div>
</div>
<div class="col-4">
<div class="form-group">
<label class="form-label">Proje Kategorisi: <span class="tx-danger"></span></label>
<select name="kategori" class="form-control select">
<option value="Bitkisel Ürünler">Bitkisel Ürünler</option>
<option value="Teknolojik Ürünler">Teknolojik Ürünler</option>
<option value="Gıda Ürünleri">Gıda Ürünleri</option>
<option value="Giyim Ürünleri">Giyim Ürünleri</option>
<option value="Sayfa Tanıtımı">Sayfa Tanıtımı</option>
<option value="İşletme Tanıtımı">İşletme Tanıtımı</option>
<option value="Diğer">Diğer</option>
</select>
</div>
</div>
<div class="col-4">
<div class="form-group mg-b-0">
<label class="form-label">Çalışma Türü: <span class="tx-danger"></span></label>
<select name="tur" class="form-control select">
<option value="Bütçe / Sürekli">Bütçe / Sürekli</option>
<option value="Tıklama Başına">Tıklama Başına</option>
<option value="Data Başına">Data Başına</option>
</select>
</div>
</div>
<div class="col-4">
<div class="form-group mg-b-0">
<label class="form-label">Proje Başlangıcı: <span class="tx-danger"></span></label>
<input class="form-control fc-datepicker" name="baslangic" placeholder="GG/AA/YYYY" type="text">
</div>
</div>
<div class="col-4">
<div class="form-group mg-b-0">
<label class="form-label">Proje Bitişi: <span class="tx-danger"></span></label>
<input class="form-control fc-datepicker" name="bitis" placeholder="GG/AA/YYYY" type="text">
</div>
</div>
</div>
<div class="main-content-label mg-b-5"><br><br>
Proje Reklam Bilgileri
</div>
<div class="row row-sm">
<div class="col-6">
<div class="form-group">
<label class="form-label">Gün Sıklığı: <span class="tx-danger"></span></label>
<select name="gun" class="form-control select">
<option value="Hergün">Hergün</option>
<option value="1 Gün Arayla">1 Gün Arayla</option>
<option value="2 Gün Arayla">2 Gün Arayla</option>
<option value="3 Gün Arayla">3 Gün Arayla</option>
<option value="5 Gün Arayla">5 Gün Arayla</option>
</select>
</div>
</div>
<div class="col-3">
<div class="form-group">
<label class="form-label">Saat İle: <span class="tx-danger"></span></label>
<select name="saat1" class="form-control select">
<option value="08:00">08:00</option>
<option value="09:00">09:00</option>
<option value="10:00">10:00</option>
<option value="11:00">11:00</option>
<option value="12:00">12:00</option>
<option value="13:00">13:00</option>
<option value="14:00">14:00</option>
<option value="15:00">15:00</option>
<option value="16:00">16:00</option>
<option value="17:00">17:00</option>
<option value="18:00">18:00</option>
<option value="19:00">19:00</option>
<option value="20:00">20:00</option>
<option value="21:00">21:00</option>
<option value="22:00">22:00</option>
<option value="23:00">23:00</option>
<option value="00:00">00:00</option>
<option value="01:00">01:00</option>
<option value="02:00">02:00</option>
<option value="03:00">03:00</option>
<option value="04:00">04:00</option>
<option value="05:00">05:00</option>
<option value="06:00">06:00</option>
<option value="07:00">07:00</option>
</select>
</div>
</div>
<div class="col-3">
<div class="form-group">
<label class="form-label">Saat Arasında: <span class="tx-danger"></span></label>
<select name="saat2" class="form-control select">
<option value="08:00">08:00</option>
<option value="09:00">09:00</option>
<option value="10:00">10:00</option>
<option value="11:00">11:00</option>
<option value="12:00">12:00</option>
<option value="13:00">13:00</option>
<option value="14:00">14:00</option>
<option value="15:00">15:00</option>
<option value="16:00">16:00</option>
<option value="17:00">17:00</option>
<option value="18:00">18:00</option>
<option value="19:00">19:00</option>
<option value="20:00">20:00</option>
<option value="21:00">21:00</option>
<option value="22:00">22:00</option>
<option value="23:00">23:00</option>
<option value="00:00">00:00</option>
<option value="01:00">01:00</option>
<option value="02:00">02:00</option>
<option value="03:00">03:00</option>
<option value="04:00">04:00</option>
<option value="05:00">05:00</option>
<option value="06:00">06:00</option>
<option value="07:00">07:00</option>
</select>
</div>
</div>
<div class="col-6">
<div class="form-group">
<label class="form-label">Yayınlanacağı Yer: <span class="tx-danger"></span></label>
<select name="platform" class="form-control select">
<option value="Facebook">Facebook</option>
<option value="Instagram">Instagram</option>
<option value="Facebook + Instagram">Facebook + Instagram</option>
<option value="Google">Google</option>
<option value="Youtube">Youtube</option>
</select>
</div>
</div>
<div class="col-6">
<div class="form-group">
<label class="form-label">Ürün Sitesi: <span class="tx-danger"></span></label>
<input class="form-control" name="domain" placeholder="" required="" type="text" value="<?php echo $projelercek['domain'] ?>">
</div>
</div>
</div><br>
<div class="main-content-label mg-b-5">
Proje Bütçe Bilgileri
</div>
<div class="row row-sm">
<div class="col-4">
<div class="form-group">
<label class="form-label">Proje Bütçesi: <span class="tx-danger"></span></label>
<div class="input-group-prepend">
<input aria-label="Amount (to the nearest dollar)" class="form-control" type="text" name="butce">
<span class="input-group-text">.00 ₺</span>
</div>
</div>
</div>
<div class="col-4">
<div class="form-group">
<label class="form-label">Harcama Sıklığı: <span class="tx-danger"></span></label>
<select name="harcama" class="form-control select">
<option value="Yavaş Düzey">Yavaş Düzey</option>
<option value="Orta Düzey">Orta Düzey</option>
<option value="Hızlı Düzey">Hızlı Düzey</option>
</select>
</div>
</div>
<div class="col-4">
<div class="form-group">
<label class="form-label">Kontrol Noktası: </label>
<select name="kontrol" class="form-control select">
<option value="İstemiyorum">İstemiyorum</option>
<option value="Bütçenin %20'si">Bütçenin %20'si</option>
<option value="Bütçenin %40'ı">Bütçenin %40'ı</option>
<option value="Bütçenin %50'si">Bütçenin %50'si</option>
</select>
</div>
</div>
<div class="col-3">
<input type="hidden" value="<?php echo $projelercek['id'] ?>" name="id">
<button class="btn btn-primary btn-block float-left" name="projeguncelle" type="submit">Projemi Güncelle</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div> </div> </div> </div>
<!-- /row -->
<?php require_once"footer.php"; ?>burasıda run.php içeriği ;
if (isset($_POST['projeguncelle'])) {
$id=$_POST['id'];
$ayarkaydet=$db->prepare("UPDATE siparisler SET
id=:id,
adi=:adi,
kategori=:kategori,
tur=:tur,
baslangic=:baslangic,
bitis=:bitis,
gun=:gun,
saat1=:saat1,
saat2=:saat2,
platform=:platform,
domain=:domain,
butce=:butce,
harcama=:harcama,
kontrol=:kontrol,
durum=:durum,
where id={$_POST['id']}
");
$projeupdate=$ayarkaydet->execute(array(
'id' => $_POST['id'],
'adi' => $_POST['adi'],
'kategori' => $_POST['kategori'],
'tur' => $_POST['tur'],
'baslangic' => $_POST['baslangic'],
'bitis' => $_POST['bitis'],
'gun' => $_POST['gun'],
'saat1' => $_POST['saat1'],
'saat2' => $_POST['saat2'],
'platform' => $_POST['platform'],
'domain' => $_POST['domain'],
'butce' => $_POST['butce'],
'harcama' => $_POST['harcama'],
'kontrol' => $_POST['kontrol'],
'durum' => $_POST['durum']
));
if ($projeupdate) {
//echo "kayıt başarılı";
Header("Location:aktif-projelerim");
exit;
} else {
//echo "kayıt başarısız";
Header("Location:proje-duzenle.php?durumno&id=$id");
exit;
}
}