Üye Kaydı

HTML:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Üye Kaydı</title>
<style type="text/css">
<!--
.style2 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
.style3 {
font-size: 10px;
font-weight: bold;
}
.style4 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 24px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<p class="style4">Üye Kaydı</p>
<form action="baglan.php" method="post" name="form1" class="style2" id="form1">
<label>Ad:
<input name="ad" type="text" id="ad" />
</label>
<p>
<label>Soyad:
<input name="soyad" type="text" id="soyad" />
</label>
</p>
<p>
<label>Kullanıcı Adı:
<input name="kullaniciadi" type="text" id="kullaniciadi" />
</label>
</p>
<p>
<label>Şifre:
<input name="sifre" type="password" id="sifre" />
</label>
<span class="style3">**Şifreyi sallayın:))</span> </p>
<p>
<label>E-Mail:
<input name="email" type="text" id="email" />
</label>
</p>
<p>
<label>Görüş:
<textarea name="gorus" rows="5" id="gorus"></textarea>
</label>
</p>
<p>
<label>
<input type="submit" name="Submit" value="Üye Ol" />
</label>
</p>
</form>
</body>
</html>

PHP:

<?
@mysql_connect ("localhost", "kullaniciadi", "sifre") or die ("Baglanti kurulamadi.");
@mysql_select_db ("veritabani") or die ("Veritabanina baglanilamadi.");
$sql ="insert into uyeler (ad, soyad, kullaniciadi, sifre, email, gorus) values ('$ad', '$soyad', '$kullaniciadi', '$sifre', '$email', '$gorus')";
$kayit = mysql_query($sql);
if (isset ($kayit)) {
echo "Kayit basariyla tamamlandi." . "<a href='goruntule.php'>Kayitli olan kullanicilarin bilgilerini görüntülemek için tiklayin...</a>";
} else {
echo "Kayit basarisiz.";
}
?>

PHP:

<html>
<body>
<title>Kullanıcı Listesi</title>
<table border="1" bordercolor="90022E" width="100%">
<tr>
<td width="16%"><font face="Arial Black" size="2">Adi</font></td>
<td width="16%"><font face="Arial Black" size="2">Soyadi</font></td>
<td width="17%"><font face="Arial Black" size="2">Kullanici adi</font></td>
<td width="13%"><font face="Arial Black" size="2">Sifre</font></td>
<td width="21%"><font face="Arial Black" size="2">E-Mail</font></td>
<td width="17%"><font face="Arial Black" size="2">Görüs</font></td>
</tr>
<?
@mysql_connect ("localhost", "kullaniciadi", "sifre") or die ("Baglanti kurulamadi.");
@mysql_select_db ("veritabani") or die ("Veritabanina baglanilamadi.");
$sql = mysql_query ("select * from uyeler");
while ($liste = mysql_fetch_array($sql)) {
?>
<tr>
<td width="16%"><font face="Verdana" size="2"><? echo "$liste[0]"; ?></font></td>
<td width="16%"><font face="Verdana" size="2"><? echo "$liste[1]"; ?></font></td>
<td width="17%"><font face="Verdana" size="2"><? echo "$liste[2]"; ?></font></td>
<td width="13%"><font face="Verdana" size="2"><? echo "$liste[3]"; ?></font></td>
<td width="21%"><font face="Verdana" size="2"><? echo "$liste[4]"; ?></font></td>
<td width="17%"><font face="Verdana" size="2"><? echo "$liste[5]"; ?></font></td>
</tr>
<?
}
?>
</table>
</body>
</html>

Emir AYDIN