her bliver du sat ind i db'en
<?php
include("config.php");
$connect = mysql_connect("$user_hostname", "$user_username",
"$user_password");
mysql_select_db("$user_database", $connect);
$sql = "SELECT * FROM users WHERE username = \"$username\"";
$result = @mysql_query($sql) or die("No.");
$num = mysql_num_rows($result);
if(!$submit) {
$password = md5($password2);
echo "<form method=\"POST\" action=$PHP_SELF>
<center>
<table border=\"2\" width=\"100%\" bordercolor=\"#FFDD51\"cellspacing=\"0\"
cellpadding=\"7\">
<tr>
<td>Navn:</td>
<td><input type=\"text\" name=\"fname\" size=\"20\"></td>
</tr>
<tr>
<td>E-mail:</td>
<td><input type=\"text\" name=\"email\" size=\"20\"></td>
</tr>
<tr>
<td>Profil:</td>
<td><select size=\"1\" name=\"billede\">
<option>profil/01.gif</option>
<option>profil/02.gif</option>
<option>profil/03.gif</option>
<option>profil/04.gif</option>
<option>profil/06.gif</option>
<option>profil/07.gif</option>
<option>profil/08.gif</option>
<option>profil/09.gif</option>
<option>profil/10.gif</option>
<option>profil/11.gif</option>
<option>profil/12.gif</option>
<option>profil/13.gif</option>
<option>profil/14.gif</option>
<option>profil/15.gif</option>
<option>profil/16.gif</option>
<option>profil/17.gif</option>
<option>profil/18.gif</option>
<option>profil/19.gif</option>
<option>profil/20.gif</option>
<option>profil/21.gif</option>
<option>profil/22.gif</option>
<option>profil/23.gif</option>
<option>profil/24.gif</option>
<option>profil/25.gif</option>
<option>profil/26.gif</option>
<option>profil/27.gif</option>
<option>profil/28.gif</option>
<option>profil/29.gif</option>
<option>profil/30.gif</option>
<option>profil/31.gif</option>
</select><a href=\"javascript:NewWin()\">Se profil billeder</a></td>
</tr>
<tr>
<td>Brugernavn</td>
<td><input type=\"text\" name=\"username\" size=\"20\"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type=\"password\" name=\"password2\" size=\"20\">
<input type=\"hidden\" name=\"password\" value=\"$password\" size=\"20\">
</tr>
</table>
<p><input type=\"submit\" value=\"Submit\" name=\"submit\"></p>
</center>
</form>";
} else if($submit && empty($fname) && empty($lname) && empty($username) &&
empty($username)) {
echo "<center>Udfyld alle felterne tak!</center>";
} else if($num == "1") {
echo "<center>Brugernavnet er i brug så prøv med et nyt.</center>";
} else if($submit && !empty($fname) && !empty($email) && !empty($username)
&& !empty($username) && $num == "0") {
$insert = "INSERT INTO users VALUES ('', '$fname', '$email', '$username',
'$password', '$billede')";
$insert_res = @mysql_query($insert) or die("No.");
echo "Du er registreret som $username.";
}
mysql_close($connect);
?>
Det virker fint og passwordet bliver krypteret!
Her logger man så ind:
<?php
include("config.php");
$connect = mysql_connect("$user_hostname", "$user_username",
"$user_password");
mysql_select_db("$user_database", $connect);
session_start();
if(!isset($username)) {
echo "<html>
<head>
<title>Storkie.1go.dk</title>
<link rel=\"StyleSheet\" href=\"stylemenu.css\" type=\"text/css\">
<style type=\"text/css\">
body {
text-align:center;
scrollbar-arrow-color: black;
scrollbar-base-color: white;
scrollbar-dark-shadow-color: black;
scrollbar-track-color: white;
scrollbar-face-color: white;
scrollbar-shadow-color: black;
scrollbar-highlight-color: black;
scrollbar-3d-light-color: white;
}
</style>
</head>
<body bgcolor=\"#ffffcc\">
<div id=\"frame\">
<div id=\"toppen\"><table border=\"0\" cellpadding=\"7\" cellspacing=\"0\"
width=\"100%\" bordercolor=\"#FFDD51\">
<tr>
<td width=\"100%\"><a href=\"index.php\"><img border=\"3\"
src=\"images/Storkietop.gif\" width=\"740\" hight=\"89\"
style=\"border-style: solid; border-color: #FFDD51\"></a></td>
</tr>
</table></div>
<div id=\"venstre\">
<div>
<iframe src=\"menu1.php\" width=\"240\" height=\"2000\" frameborder=\"0\">
</iframe>
</div>
</div>
<div id=\"hojre\">
<br><table border=\"2\" background=\"images/tabelbg.jpg\" cellpadding=\"7\"
cellspacing=\"0\" width=\"100%\" bordercolor=\"#FFDD51\"><tr>
<td width=\"100%\">
<p align=\"center\"><font size=\"5\"
color=\"#ffdd51\">Login</font></td>
</tr>
</table><br><body bgcolor=\"ffffcc\"><form method=\"POST\" action=$PHP_SELF>
<p align=\"left\">
<table>
<tr>
<td>
Brugernavn:<br><input type=\"text\" name=\"username\" size=\"8\"></td>
</tr>
<tr>
<td>
Password:<br><input type=\"password\" name=\"password\" size=\"8\">
</td>
</tr>
<tr>
<td colspan=\"2\">
<p align=\"left\"><input type=\"submit\" value=\"Submit\"
name=\"submit\"></td>
</tr>
</table>
</p>
</form></body>";
exit;
}
session_register("username");
session_register("password");
$sql = "SELECT * FROM users WHERE username = \"$username\" AND password =
\"$password\"";
$result = @mysql_query($sql) or die("No.");
if(mysql_num_rows($result) == "0") {
session_unregister("username");
session_unregister("password");
echo "Forkert brugernavn og <br> password, nyt forsøg";
exit;
}
$username = mysql_result($result,0,"username");
mysql_close($connect);
?>
</div>