Mahlzeit für die Neulinge unter PHP.
Früher hatte ich immer ein Problem mit einem Register und Login, deswegen dachte ich mir ich gebe euch ein einfaches Register und Login System.
Spoiler anzeigen
index.html
PHP
<html>
<head>
<title>Anmelden</title>
</head>
<body>
<form action="login.php" method="POST">
<input type="text" name="username" placeholder="Username" />
<input type="password" name="passwort" placeholder="Passwort" />
<input type="submit" name="submit" value="Anmelden" /><a href="register.html"><input type="button" value="Registrieren" /></a>
</form>
</body>
</html>login.php
PHP
<?php
$MySQL['host'] = 'localhost';
$MySQL['username'] = 'root';
$MySQL['password'] = 'root';
$MySQL['datebase'] = 'projekt';
mysql_connect($MySQL['host'],$MySQL['username'],$MySQL['password']);
mysql_select_db($MySQL['datebase']);
$username = mysql_real_escape_string($_POST['username']);
$password = sha1($_POST['password']);
$loginquery = mysql_query("SELECT * FROM users WHERE username='".$username."' AND passwort='".$password."'");
$result = $loginquery;
if ($result > 0) {
echo 'Herzlich willkommen '. $username;
} else {
echo 'Falsches Passwort oder Username!';
}
?>register.html
PHP
<html>
<head>
<title>Registrieren</title>
</head>
<body>
<form action="register.php" method="POST">
<input type="text" name="username" placeholder="Username" />
<input type="password" name="passwort" placeholder="Passwort" />
<input type="submit" name="submit" value="Registrieren" />
</form>
</body>
</html>register.php
PHP
<?php
$MySQL['host'] = 'localhost';
$MySQL['username'] = 'root';
$MySQL['password'] = 'root';
$MySQL['datebase'] = 'projekt';
mysql_connect($MySQL['host'],$MySQL['username'],$MySQL['password']);
mysql_select_db($MySQL['datebase']);
$username = mysql_real_escape_string($_POST['username']);
$password = sha1($_POST['password']);
$submit = $_POST['submit'];
$register = mysql_query("INSERT INTO `users`(`username`, `passwort`) VALUES ('".$username."','".$password."')");
$result = $register;
if ($submit == true) {
echo 'Du hast dich Registriert';
} else {
echo 'Fehler!';
}
?>users.sql
SQL
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`passwort` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
Viel Spaß,
rE-b0ot
