add and select users on a mysql database
Download
View Source (print view)
Rating : 4.7
Views : 291
###
/*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>
rss, fedex, xslt, i need webmail login name and password, search results, project, php script" class="neww" target="_blank" title="im neuen, unction, yahoo status check, anton sorina, guest, php snips, doc,_pdf,_rtf,_xsl__files_to_a_single_pdf_at_runtime, php script" class="neww" target="_b...', twenty_2007, paper without wood, \"php_script, yahoo_status, yahoostatus, auto loading combo box, bbcode