Authentication
|
|
|
|
###
/*create table users(
username varchar(20),
email varchar(35),
birth varchar(10),
city varchar(30),
country varchar(40),
adress varchar(50),
posta integer,
spec varchar(120),
UNIQUE K_id(id),
primary key(id)
);,
*/
//Header.php
<?
$dbhost = "localhost";
$dbname = "database";
$dbuser = "root";
$dbpass = "";
mysql_connect("$dbhost", "$dbuser", "$dbpass");
mysql_select_db("$dbname");
?>
//newsign.php
<? require("header.php"); ?>
<?
$numresults=mysql_query("select username from users where username='$username'");
$numrows=mysql_num_rows($numresults);
if($numrows == "0") {
$query = "insert into users (username, email, name, surname, birth, city, country, adress, posta, spec) values ('$username', '$email', '$name1', '$surname', '$birth', '$city', '$country', '$adress', '$posta', '$spec')";
$result = mysql_query($query);
echo "Tebrikler <b>$username</b> kayd�n�z tamam!";
if($result) {
echo "<br>";
}else{
echo " <br> hatal�";
}
}else{
echo "Kullanici adi mevcut L�tfen <a href=javascript:history.back(-1)>geri</a> d�n�p tekrar deneyiniz";
}
?>
//select.php
<? require ("header.php"); ?>
<?
$query = "select * from users where username='$username'";
$result = mysql_query($query);
while ($row = mysql_fetch_array ($result) ) {
$kullanici = $row['username'];
$ad = $row['name'];
$soyad = $row['surname'];
$email = $row['email'];
$dogum = $row['birth'];
$sehir = $row['city'];
$ulke = $row['country'];
$adres = $row['adress'];
$post = $row['posta '];
$ozel = $row['spec'];
$htmldataust = '<title>Aileniz.net</title> <body topmargin = 2 marginleft = 2 marginright = 0><table border = 0 cellspacing = 0 width = 100%> <tr> <td> <font color = black size=2>Aileniz.net...
';
echo "$htmldataust";
echo "$kullanici <br> <br> ";
echo "$ad <br> <br> ";
echo "$soyad <br> <br> ";
echo "$email <br> <br>";
echo "$dogum <br> <br>";
echo "$sehir <br> <br>";
echo "$ulke <br> <br>";
echo "$adres <br> <br>";
echo "$post <br> <br>";
echo "$ozel <br> <br>";
$htmldataalt = '</td></tr></table>';
echo "$htmldataalt";
}
?>
//newsign.htm
<form name=sign action=newsign.php method=post>
Kullan�c� ad�n�z(En az �� en fazla 20 karakter olmal�) <br>
<input type=text name=username size=12><br>
E-mail Adresiniz(�ifrenizin postalanaca�� adres)<br>
<input type=text name=email size=12>
<br>
<br>
<br>
-------------
Ad�n�z
<br>
<input type=text name=name1>
<br>
Soyad�n�z<br>
<input type=text name=surname>
<br>
Do�um Tarihiniz(GG/AA/YY) <br>
<input type=text name=birth>
<br>
Ya�ad���n�z �ehir<br>
<input type=text name=city>
<br>
Ya�ad���n�z �lke<br>
<input type=text name=country>
<br>
Adresiniz<br>
<input type=text name=adress><br>
Posta Kodu<br>
<input type=text name=posta><br>
Ki�isel Tan�m�n�z(Bu B�l�m sizin di�er kullan�c�lar taraf�ndan tan�nman�z i�in kullan�lacakt�r)<br>
<input type=text name=spec>
<br>
<input type=submit value=G�nder> <input type=reset value=Sil>
</form>
|
|
|
Usage Example
|
|
|
Rate This Script
|
|
|
|
Store
Your email: