php login system
Jeg har code en login system til en ven men. jeg kan ikke lige se den fejl den må have siden jeg ikke kan få folk til at loginNr 1: checklogin.php
[code]
$host="host"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="Database"; // Database name
$tbl_name="members"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form
$myusername=$_POST['first_name'];
$mylastname=$_POST['last_name'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mylastname = stripslashes($last_name);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mylastname = mysql_real_escape_string($last_name);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and mylastname='$last_name' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mylastname");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
[/code]
Den anden : login_success.php
[code]
session_start();
if(!session_is_registered(myusername)){
header("location:main_login.php");
}
<html>
<body>
Login Successful
</body>
</html>
[/code]
den trede : Logout.php
[code]
session_start();
session_destroy();
[/code]
Og den sidste er main_login.php
[code]
<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">First name</td>
<td width="6">:</td>
<td width="294"><input name="myusername" type="text" id="myusername"></td>
</tr>
<tr>
<td width="78">Last name</td>
<td width="6">:</td>
<td width="294"><input name="mylastname" type="text" id="mylastname"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input name="mypassword" type="text" id="mypassword"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
[/code]
Jeg kan ikke fåstå at den ikke giver mig lov til at log in. Jeg har før kørt med denne her der var der ingen problemmer.
men den siger stadig "Wrong Username or Password" selv om at user og last og password er rigtig.
