phpMyAdmin yAdmin MySQL İnsert

Php İnsert Kodu:
<?php
error_reporting( ~E_NOTICE ); // avoid notice
require_once 'dbconfig.php';

if(isset($_POST['btnkaydet']))

{
$ad = $_POST['ad'];
$soyad = $_POST['soyad'];
$email = $_POST['email'];
$adres = $_POST['adres'];

// if no error occured, continue ....
if(!isset($errMSG))
{
$stmt- = $baglanti->prepare('INSERT INTO kullanici(ad,soyad,email,adres) VALUES(:ad, :soyad, :email, :adres)');
$stmt->bindParam(':ad',$ad );
$stmt->bindParam(':soyad',$soyad);
$stmt->bindParam(':email',$email);
$stmt->bindParam(':adres',$adres);

if($stmt->execute())
{
$successMSG = "Kayıt Tamamlandı ...";
header("refresh:5;index.php"); // redirects image view page after 5 seconds.
}
else
{
$errMSG = "Hata";
}
}
}
?>
Form Yapısı Aşağıdaki Gibidir:
<form action="liste.php" method="post">
<table>
     <tr>
    <td><label>Adı.</label></td>
        <td><input class="harf" name="ad" placeholder="Ad" type="text" /></td>
     </tr>
     <tr>
    <td><label>Soyadı</label></td>
        <td><input class="harf" name="soyad" placeholder="Soyad" type="text" /></td>
     </tr>
     <tr>
    <td><label>Email</label></td>
        <td><input name="email" placeholder="Email" type="email" /></td>
     </tr>
     <tr>
    <td><label>Adres</label></td>
        <td><input  name="adres" placeholder="Adres" type="text" /></td>
     </tr> 
     <tr>
        <td colspan="2"><input  name="btnkaydet" type="submit" value="Kaydet" /</td>
    </tr>
</table>
</form>
Form Çıktısı :


Hiç yorum yok:

Yorum Gönder