CREATE TABLE `Users` (
`id` int(11) NOT NULL auto_increment,
`ML_First` varchar(250) NULL DEFAULT NULL,
`ML_Last` varchar(250) NULL DEFAULT NULL,
`ML_Username` varchar(250) NULL DEFAULT NULL,
`ML_Password` varchar(250) NULL DEFAULT NULL,
`ML_Email` varchar(250) NULL DEFAULT NULL,
`ip` varchar(250) NULL DEFAULT NULL,
`todae` varchar(250) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
)
<?php function login()
{
global $_POST;
global $_SESSION;
global $_GET;
if (isset($_GET["a"]) && ($_GET["a"] == 'logout')) $_SESSION["logged_in"] = false;
if (!isset($_SESSION["logged_in"])) $_SESSION["logged_in"] = false;
if (!$_SESSION["logged_in"]) {
$login = "";
$password = "";
if (isset($_POST["login"])) $login = @$_POST["login"];
if (isset($_POST["password"])) $password = @$_POST["password"];
if (($login != "") && ($password != "")) {
$conn = mysql_connect("localhost", "", "");
mysql_select_db("");
$sql = "select ML_Password from Users where ML_Username='$login'";
$res = mysql_query($sql, $conn) or die(mysql_error());
$row = mysql_fetch_assoc($res) or $row = array(0 => "");;
if (isset($row)) reset($row);
if (isset($password) && ($password == trim(current($row)))) {
$_SESSION["logged_in"] = true;
}
else {
?>