pdo Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo fakat leo dapibus.
Lorem ipsum dolor sit amet,fakat consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum ama dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, fakat pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ama ullamcorper mattis, pulvinar dapibus leo.
Lorem ama ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec fakat ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur ama adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, fakat luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur ama adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec fakat ullamcorper mattis, pulvinar dapibus leo.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus,ama luctus nec ullamcorper mattis, pulvinar dapibus leo.
Veri tabanıyla bağlantı oluşturuldu. == baglanti.php
<?php
$db = new PDO("mysql:host=localhost;dbname=test","root","");
?>
index.php dosyası
<h2>Veri Kaydetme</h2>
<form action="islemler.php" method="POST">
Ad Soyad: <input type="text" name="adSoyad" ><br>
Mail: <input type="text" name="mail" ><br>
Şifre: <input type="text" name="sifre" ><br>
<input type="submit" value="Kaydet" name="kaydet">
</form>
<h2>Veri Listeleme</h2>
<table border="1">
<tr>
<th>ID</th>
<th>Ad Soyad</th>
<th>Mail</th>
<th>Şifre</th>
<th>İşlem</th>
</tr>
<?php
include 'baglanti.php';
$sorgu = $db->query("SELECT * FROM admin")->fetchAll(PDO::FETCH_ASSOC);
foreach($sorgu as $veri) {
?>
<tr>
<td><?php echo $veri['id'] ?></td>
<td><?php echo $veri['adSoyad'] ?></td>
<td><?php echo $veri['mail'] ?></td>
<td><?php echo $veri['sifre'] ?></td>
<td>
<a href='islemler.php?sil&id=<?php echo $veri['id'] ?>'>Sil</a> | <a href='guncelle.php?id=<?php echo $veri['id'] ?>'>Güncelle</a>
</td>
</tr>
<?php
}
?>
</table>
islemler.php dosyası
<?php
include 'baglanti.php';
$islem = $_GET['islem'];
if (isset($_POST["kaydet"])) {
$adSoyad = $_POST['adSoyad'];
$mail = $_POST['mail'];
$sifre = $_POST['sifre'];
$sorgu = $db->prepare("INSERT INTO admin (adSoyad, mail, sifre) VALUES (?, ?, ?)");
$sorgu->execute([$adSoyad, $mail, $sifre]);
header("Location: index.php");
}
if (isset($_GET["sil"])) {
$id = $_GET['id'];
$sorgu = $db->prepare("DELETE FROM admin WHERE id = ?");
$sorgu->execute([$id]);
header("Location: index.php");
}
if ($islem == 'guncelle') {
header("Location: guncelle.php");
}
?>
guncelle.php dosyası
<?php
include 'baglanti.php';
$id = $_GET['id'];
$sorgu = $db->prepare("SELECT * FROM admin WHERE id = ?");
$sorgu->execute([$id]);
$veri = $sorgu->fetch();
if (isset($_POST["kaydet"])) {
$adSoyad = $_POST['adSoyad'];
$mail = $_POST['mail'];
$sifre = $_POST['sifre'];
$sorgu = $db->prepare("UPDATE admin SET adSoyad = ?, mail = ?, sifre = ? WHERE id = ?");
$sorgu->execute([$adSoyad, $mail, $sifre, $id]);
header("Location: index.php");
}
?>
<h2>Veri Güncelleme</h2>
<form action="" method="POST">
Ad Soyad: <input type="text" name="adSoyad" value="<?php echo $veri['adSoyad']; ?>" ><br>
Mail: <input type="text" name="mail" value="<?php echo $veri['mail']; ?>" ><br>
Şifre: <input type="text" name="sifre" value="<?php echo $veri['sifre']; ?>" ><br>
<input type="submit" value="Güncelle" name="kaydet">
</form>
1 Yorum
Sorularınız varsa yanıtlayabilirim?