Arkadaşlar işin içinden çıkamadım nerede hata yaptım bende bilmiyorum son çare konu açayım dedim. Aldığım hata ise;
Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in
C:\AppServ\www\v1\admin\inc\islem.php on line
34 Form Kodlarım <form class="form" action="../inc/islem.php" method="POST">
<div class="form-group row">
<label for="example-url-input" class="col-2 col-form-label">Kullanıcı</label>
<div class="col-10">
<input class="form-control" type="text" placeholder="Örn: Ahmet veya Firma Adı" name="ayar_kullanici" value="<?php echo $ayarcek['ayar_kullanici']; ?>">
</div>
</div>
<div class="form-group row">
<label for="example-url-input" class="col-2 col-form-label">Site URL</label>
<div class="col-10">
<input class="form-control" type="url" placeholder="http veya https ekleyiniz..." id="example-url-input" name="ayar_siteurl" value="<?php echo $ayarcek['ayar_siteurl']; ?>">
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-2 col-form-label">Site Başlığı</label>
<div class="col-10">
<input class="form-control" type="text" placeholder="Tavsiye edilen uzunluk: 70 Karakter" id="example-text-input" name="ayar_sitebaslik" value="<?php echo $ayarcek['ayar_sitebaslik']; ?>">
</div>
</div>
<div class="form-group row">
<label for="example-search-input" class="col-2 col-form-label">Site Açıklaması</label>
<div class="col-10">
<textarea class="form-control" rows="5" placeholder="Tavsiye edilen uzunluk: 320 Karakter" name="ayar_siteaciklama"><?php echo $ayarcek['ayar_siteaciklama']; ?></textarea>
</div>
</div>
<div class="form-group row">
<label for="example-search-input" class="col-2 col-form-label">Site Anahtar Kelimeleri</label>
<div class="col-10">
<textarea class="form-control" rows="5" name="ayar_siteanahtarkelime"><?php echo $ayarcek['ayar_siteanahtarkelime']; ?></textarea>
</div>
</div>
<div class="form-group row">
<label for="example-email-input" class="col-2 col-form-label">E-Mail</label>
<div class="col-10">
<input class="form-control" type="email" placeholder="siteniz@siteniz.com" id="example-email-input" name="ayar_email" value="<?php echo $ayarcek['ayar_email']; ?>" >
</div>
</div>
<div class="form-group row">
<label for="example-tel-input" class="col-2 col-form-label">Telefon</label>
<div class="col-10">
<input class="form-control" type="tel" placeholder="+90(555)555 55 55" id="example-tel-input" name="ayar_telefon" value="<?php echo $ayarcek['ayar_telefon']; ?>">
</div>
</div>
<div class="form-group row">
<label for="example-search-input" class="col-2 col-form-label">Adres</label>
<div class="col-10">
<textarea class="form-control" rows="5" name="ayar_adres"><?php echo $ayarcek['ayar_adres']; ?>"</textarea>
</div>
</div>
<div class="form-group row">
<label for="example-text-input" class="col-2 col-form-label">Çalışma Saatleri</label>
<div class="col-10">
<input class="form-control" type="text" placeholder="Pazartesi - Cuma 08:00 - 18:00" id="example-text-input" name="ayar_calisma" value="<?php echo $ayarcek['ayar_calisma']; ?>">
</div>
</div>
<div class="form-group row">
<label for="example-search-input" class="col-2 col-form-label">Hakkımızda</label>
<div class="col-10">
<textarea class="form-control" rows="5" name="ayar_hakkimizda"><?php echo $ayarcek['ayar_hakkimizda']; ?></textarea>
</div>
</div>
<div class="col-lg-2 col-sm-4 col-xs-12">
<button class="btn btn-block btn-info waves-effect" type="submit" name="genelayarkaydet">Güncelle</button>
</div>
</form>İşlem Kodlarım <?php
ob_start();
include 'baglan.php';
if(isset($_POST['genelayarkaydet'])) {
$ayarkaydet=$db->prepare("UPDATE genelayarlar SET
ayar_kullanici=:kullanici,
ayar_siteurl=:siteurl,
ayar_sitebaslik=:sitebaslik,
ayar_siteaciklama=:siteaciklama,
ayar_siteanahtarkelime=:siteanahtarkelime,
ayar_email=:email,
ayar_telefon=:telefon,
ayar_adres=:adres,
ayar_calisma=:calisma,
ayar_hakkimizda=:hakkimizda
WHERE ayar_id=0");
$guncelle=$ayarkaydet->execute(array(
'kullanici' => $_POST['ayar_kullanici'],
'siteurl' => $_POST['ayar_siteurl'],
'sitebaslik' => $_POST['ayar_sitebaslik'],
'ayar_siteaciklama' => $_POST['ayar_siteaciklama'],
'siteanahtarkelime' => $_POST['ayar_siteanahtarkelime'],
'email' => $_POST['ayar_email'],
'telefon' => $_POST['ayar_telefon'],
'adres' => $_POST['ayar_adres'],
'calisma' => $_POST['ayar_calisma'],
'hakkimizda' => $_POST['ayar_hakkimizda']
));
if($guncelle) {
echo "Güncelleme başarılı..";
}
}
?>