Merhabalar,
veri tabanından verileri form a çektiriyorum. ancak güncelle dediğimde aşağıdaki gibi bir hata alıyorum. aynı kod satırını defalarca yazmama rağmen aynı hatayı aldım. hatayı gören aydınlatırsa çok sevinirim
Burada verileri forma çektiğim görünüyor.
Bu yazılan kodlar ;
<?php
include ("sidebar.php");
?>
<?php
include ("header.php");
?>
<?php
include "connect.php";
if(isset($_POST['guncelle'])){
include "connect.php";
$sql = "UPDATE `uyeler`
SET `uye_id` = ?,
`uye_ad` = ?,
`uye_soyad` = ?,
`uye_telefon` = ?,
`uye_mail` = ?,
`uye_adres` = ?,
`uye_kayıt_tarihi` = ?
WHERE `uyeler`.`uye_id` = ?";
$dizi=[
$_POST['uye_id'],
$_POST['ad1'],
$_POST['soyad1'],
$_POST['telefon1'],
$_POST['mail1'],
$_POST['adres1']
];
$sorgu = $baglan->prepare($sql);
$sorgu->execute($dizi);
}
$sql = "SELECT * FROM uyeler WHERE uye_id = ?";
$sorgu = $baglan -> prepare($sql);
$sorgu->execute([
$_GET['uye_id']
]);
$satir = $sorgu->fetch(PDO::FETCH_ASSOC);
?>
<div class="page-wrapper">
<div class="page-content">
<div class="card border-top border-0 border-4 border-primary">
<div class="card-body p-5">
<div class="card-title d-flex align-items-center">
<div><i class="bx bxs-user me-1 font-22 text-primary"></i>
</div>
<h5 class="mb-0 text-primary">Üye Güncelle</h5>
</div>
<hr>
<form action="" method="POST" class="row g-3">
<input type="hidden" name="uye_id" value="<?=$satir['uye_id']?>">
<div class="col-md-6">
<label for="inputFirstName" class="form-label">Ad</label>
<input type="name" class="form-control" id="inputFirstName" name="ad1" value="<?=$satir['uye_ad']?>">
</div>
<div class="col-md-6">
<label for="inputLastName" class="form-label">Soyad</label>
<input type="name" class="form-control" id="inputLastName" name="soyad1" value="<?=$satir['uye_soyad']?>">
</div>
<div class="col-md-6">
<label for="inputEmail" class="form-label">Telefon</label>
<input type="number" class="form-control" id="inputNumber" name="telefon1" value="<?=$satir['uye_telefon']?>">
</div>
<div class="col-md-6">
<label for="inputEmail" class="form-label">Email</label>
<input type="email" class="form-control" id="inputEmail" name="mail1" value="<?=$satir['uye_mail']?>">
</div>
<div class="col-12">
<label for="inputAddress" class="form-label">Adres</label>
<textarea class="form-control" id="inputAddress" name="adres1" value="<?=$satir['uye_adres']?>" rows="3"></textarea>
</div>
<!-- <div class="col-md-4">
<label for="inputState" class="form-label">Yeni Üye Mi?</label>
<select id="inputState" class="form-select">
<option selected="">Evet</option>
<option>Hayır</option>
</select>
</div> -->
<div class="col-12">
<button type="submit" class="btn btn-primary px-5" name="guncelle">Güncelle</button>
</div>
<?php
if(isset($_SESSION['status']))
{
?>
<div class="alert alert-primary" role="alert">
<strong><?php echo $_SESSION['status'];?></strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Kapat"></button>
</div>
<?php
unset ($_SESSION['status']);
}
?>
</div>
</div>
</div>
<?php
include ("footer.php");
?>
<?php
include ("switcher.php");
?>Buda aldığım hata