Cподелям: Логин система за PHP - писана от мен

by **hARDCORE** Чет Апр 21, 2011 4:55 am

Системката ще работи с база данни (разбира се) за това създаваме database.sql

CREATE TABLE IF NOT EXISTS `users`(
`id` INT NOT NULL AUTO_INCREMENT,
`username` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY(`id`)
) ENGINE=MyISAM DEFAULT CHARSET utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT = 1;

config.php

mysql_connect("хост","потребител","парола");
mysql_select_db("база данни.");
?>

index.php
[codesession_start();
include_once "config.php";
if (isset($_SESSION['username']))
{
echo "hello $_SESSION[username]";
}
else
{
echo "login ";
echo "register ";
}
?>
]

login.php

session_start();
include_once "config.php";
if (isset($_SESSION['username']))
{
echo "hello $_SESSION[username]";
}
else
{
echo "
";
echo "Username:
";
echo "Password:
";
echo "";
echo "
";
if (isset($_POST['submit']))
{
$username = htmlspecialchars($_POST['username']);
$password = htmlspecialchars($_POST['password']);
$a = mysql_query("SELECT * FROM users WHERE username='$username' and password='$password'") or die(mysql_error());
$b = mysql_num_rows($a);
if ($b > 0)
{
$_SESSION['username'] = $username;
echo "Vie vlqzohte uspeshno. Nachalo";
}
else
{
echo "Gresno ime ili parola.";
}
}
}
?>

register.php

session_start();
include_once "config.php";
if (isset($_SESSION['username']))
{
echo "hello $_SESSION[username]";
}
else
{
echo "
";
echo "Username:
";
echo "Password:
";
echo "";
echo "
";
if (isset($_POST['submit']))
{
$username = htmlspecialchars($_POST['username']);
$password = htmlspecialchars($_POST['password']);
if (!empty($username) and !empty($password))
{
mysql_query("INSERT INTO users (username,password) VALUES ('$username','$password')") or die(mysql_error());
echo "Vie se registrirahte uspeshno. Vleznete v akaunta si.";
}
else
{
echo "Ne ste populnili vsichki poleta.";
}
}
}
?>