ashucool83
-
Posts
9 -
Joined
-
Last visited
Never
ashucool83's Achievements
Newbie (1/5)
0
Reputation
-
Thanks ... will read about that and if more questions will post it over here!!! ;D
-
Now that I can go to my home.php page .... do I need to write a cookie to keep my session only for user'A' and not user 'B' cause currently if I type http://localhost/MyLibrary/home.php I can still reach the page without the authentication. How do you guys suggest fixing this ? Thanks
-
[code] <?php $db = mysql_connect("localhost", "root", "apurva"); if (!$db) { die('Could not connect: ' . mysql_error()); } else { //echo 'Connected successfully'; } mysql_select_db("sharelib",$db); $varUser = $_POST["username"]; $varPass = $_POST["password"]; $result = mysql_query("SELECT * FROM user_table where email = '".$varUser."' and password =PASSWORD('".$varPass."')",$db); if($result) { if($myrow = mysql_fetch_row($result)) { //print "Authenticated Successfully"; $URL="http://localhost/MyLibrary/home.php"; //header ('Location: $URL'); //header ('Location: http://localhost/MyLibrary/home.php'); header ("Location: $URL"); } else { // print "you dont exist"; //Trying to redirect to Login Page //print "Authentication Failure"; $URL="http://localhost/MyLibrary/login.php"; //header ("Location: $URL"); //header ('Location: http://localhost/MyLibrary/login.php'); header ("Location: $URL"); exit; } } else { print "Oooops DB Syntax Problem!!!"; } mysql_close($db); ?> [/code] Working Code!!! Very weird!!! Thanks folks :D
-
hahah ... I copied your code and editted back to what I needed. Works like a baby!!! I still have no clue ???
-
You mean the EXACT same code works in your system ??? ??? Does it redirect to those pages -- home.php if succesful or login.php if failed ? Code1: Login.php Code2: Authenticate.php Based on Code2 it is supposed to redirect to login.php or home.php.
-
[code]<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="shortcut icon" href="" /> </head> <body> <table width="100%" border="0"> <tr> <td><div align="left"><img src="images/myDesiBook_new_2.jpg" width="481" height="100"></div></td> </tr> </table> <table width="100%" border="1"> <td width="50%"> </td> <td width="50%"> <form action="authenticate.php" method="post" name="login" id="login"> <p align="left"><em><strong>Please login using your account</strong></em></p> <p>Username: <input type="text" name="username"> <br> Password: <input type="password" name="password"> <br> <input type="submit" value="Login"> <br> If new user please <a href="register.php">Register</a>. </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> </form> </td> </table> </body> </html> [/code] [code] <?php $db = mysql_connect("localhost", "root", "apurva"); if (!$db) { die('Could not connect: ' . mysql_error()); } else { //echo 'Connected successfully'; } mysql_select_db("sharelib",$db); $varUser = $_POST["username"]; $varPass = $_POST["password"]; $result = mysql_query("SELECT * FROM user_table where email = '".$varUser."' and password =PASSWORD('".$varPass."')",$db); if($result) { if($myrow = mysql_fetch_row($result)) { //print "Authenticated Successfully"; $URL="http://localhost/MyLibrary/home.php"; //header ('Location: $URL'); //header ('Location: http://localhost/MyLibrary/home.php'); header ("Location: $URL"); } else { // print "you dont exist"; //Trying to redirect to Login Page //print "Authentication Failure"; $URL="http://localhost/MyLibrary/login.php"; //header ("Location: $URL"); //header ('Location: http://localhost/MyLibrary/login.php'); header ("Location: $URL"); exit; } } else { print "Oooops DB Syntax Problem!!!"; } mysql_close($db); ?> [/code]
-
I tried this before, as well again after you mentioned it. Still doesnt work :( I read some place that HEADER should be the first thing .... but as I am a newbie, didn't quite understand how to do that before performing the authentication logic ???
-
Yeah, it does print those messages. I ahve also tried commenting the print statements and just have the headers, it still does not redirect. I just see a blank page instead. :(
-
[code] <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="shortcut icon" href="" /> </head> <body> <table width="100%" border="0"> <tr> <td><div align="left"><img src="images/myDesiBook_new_2.jpg" width="481" height="100"></div></td> </tr> </table> <table width="100%" border="1"> <td width="50%"> </td> <td width="50%"> <form action="authenticate.php" method="post" name="login" id="login"> <p align="left"><em><strong>Please login using your account</strong></em></p> <p>Username: <input type="text" name="username"> <br> Password: <input type="password" name="password"> <br> <input type="submit" value="Login"> <br> If new user please <a href="register.php">Register</a>. </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> </form> </td> </table> </body> </html> [/code] [code] <html> <head> <title>Library | Login </title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php $db = mysql_connect("localhost", "root", "apurva"); if (!$db) { die('Could not connect: ' . mysql_error()); } else { //echo 'Connected successfully'; } mysql_select_db("sharelib",$db); $varUser = $_POST["username"]; $varPass = $_POST["password"]; $result = mysql_query("SELECT * FROM user_table where email = '".$varUser."' and password =PASSWORD('".$varPass."')",$db); if($result) { if($myrow = mysql_fetch_row($result)) { print "Authenticated Successfully"; //$URL="http://localhost/MyLibrary/home.php"; //header ('Location: $URL'); //header ('Location: http://localhost/MyLibrary/home.php'); } else { // print "you dont exist"; //Trying to redirect to Login Page print "Authentication Failure"; $URL="http://localhost/MyLibrary/login.php"; header ("Location: $URL"); exit; } } else { print "Oooops DB Syntax Problem!!!"; } mysql_close($db); ?> </body> </html> [/code] In the above code, I am trying to authenticate the user from the userTable inside a mySQL DB. I sucessfully able to authenticate the user, but it does not redirect to the desired page after authenticating the user. For Wrong Password --> "Login.php" Correct Password --> "Home.php" Please help me.