PHP + MySql

[Szotyori]

Salut

Am creat un login prin PHP + MySql (cu un tutorial)

am facut totul cum trebe dar cand vreau sa logez zice ca invalid login

daca cineva poate sa ajuta ... :D

index

Code: Select all

<div id="loginform">
		<form method="post" action="checklogin.php" name="form1">
			<ul>
				<li>
					<label for="username">Username:</label>
					<input type="text" name="myusername" id="username" />
				</li>
				<li>
					<label for="password">Password:</label>
					<input type="text" name="mypassword" id="password" />
				</li>
			</ul>
			<div id="buttons">
				<center><input name="submit" id="submit" type="submit" value="Login" /></center>

Code: Select all

<?
$host = "localhost";
$username = "";
$password = "";
$db_name = "log";
$tbl_name = "members";

mysql_connect($host, $username, $password) or die("Can't Connect");
mysql_select_db ($db_name) or die(mysql_error());

$myusername = $_POST['myusername'];
$mypassword = $_POST['mypassword'];

$sql = "SELECT * FROM $tbl_name WHERE username='$myusername' and password='mypassword'";
$result = mysql_query($sql);

$count = mysql_num_rows($result);

if($count==1) {
  session_register("myusername");
  session_register("mypassword");
  header("location:login_succes.php");
  }
  else {
    echo "Wrong Username and Password";
	}
?>

Pareri?

am scris bine user si pass :P

[IsTw]

Crezi ca asa ar functiona ? :-?

Code: Select all

$sql = "SELECT * FROM $tbl_name WHERE username='$myusername' and password='mypassword'";
$result = mysql_query($sql);

$count = mysql_num_rows($result);

if($myusername===$count['user_line'] AND $myusername===$count['pass_line']) {
  session_register("myusername");
  session_register("mypassword");
  header("location:login_succes.php");
  }
  else {
    echo "Wrong Username and Password";
   }

edit... totusi trebuia sa lucrezi cu sesiuni cand sa extragi datele din formular

[Awakening]

$sql = "SELECT * FROM $tbl_name WHERE username='$myusername' and password='mypassword'";

Ai inteles?