Untitled

// REGISTER.PHP //

<?php

$Host = Insert Host Name [DB]
$User = Insert User Name [DB]
$Pass = Insert Pass Name [DB]

mysql_connect("$Host", "$User", "$Pass") or die(mysql_error("Can't connect to database"));
mysql_select_db("Website") or die(mysql_error("Can't connect to database"));

$query = (INSERT INTO `members` WHERE `login, password` VALUES `$_POST['Username'], $_POST['Password']`)

$ucheck = (SELECT * FROM `members WHERE `login` = `$_POST['Username']`)
if($ucheck == NULL){
echo "Account name already exists!";
} else {
     mysql_query($query)
}

?>

// LOGIN.HTML //

<html>
<body>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Member Login </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="Username" type="text" id="Username"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input name="Password" type="text" id="Password"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</body>
</html>

// LOGINCHECK.PHP //

<?php
$host="localhost"
$username="root"
$password="ascent"
$db_name="website"
$tbl_name="members"

mysql_connect("$host", "$username", "$password")or die("Can't connect to DB");
mysql_select_db("$db_name")or die("Can't connect to DB");

$Username= $_POST['Username'];
$Password= $_POST['Password'];

$Username = stripslashes($Username);
$Password = stripslashes($Password);
$Username = mysql_real_escape_string($Username);
$Password = mysql_real_escape_string($Password);

$sql= (SELECT * FROM $tbl_name WHERE username='$Username' and password='$Password');
$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($count==1){

session_register("Username");
session_register("Password");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>

// LOGINSUCCES.PHP //

<?php
session_start();
if(!session_is_registered(Username)){
header("location:main_login.php");
}
?>

<html>
<body>
Login Successful
</body>
</html>

// LOGOUT.PHP //

<?php
session_start("Username");
session_destroy("Username");
?>

<html>
<body>
Succesfully logged out
</body>
</html>