ashucool83 Posted August 5, 2006 Share Posted August 5, 2006 [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. Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/ Share on other sites More sharing options...
ronverdonk Posted August 5, 2006 Share Posted August 5, 2006 Does it print the Authenticated Successfully message? If not, how do you know that authentication is succcesful? If so you won't redirect because your header statement is commented out and when you uncomment it, you won't be redirected because headers have already been sent via the print. Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69916 Share on other sites More sharing options...
ashucool83 Posted August 5, 2006 Author Share Posted August 5, 2006 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. :( Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69917 Share on other sites More sharing options...
ronverdonk Posted August 5, 2006 Share Posted August 5, 2006 The $url in the header vstatement is within single quotes. That doesn't work. If you want to do it like this the header statement must be within double quotes or the url must be concatenated. Like this:[code]header ("Location: $URL");orheader ('Location: '. $URL);[/code] Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69921 Share on other sites More sharing options...
ashucool83 Posted August 5, 2006 Author Share Posted August 5, 2006 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 ??? Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69923 Share on other sites More sharing options...
ronverdonk Posted August 5, 2006 Share Posted August 5, 2006 It is almost certainly because of the HTML stuff before your PHP code (the META stuff and so on). Take that out. If that doesnot work you better show your code as it is now(!) and not working. Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69926 Share on other sites More sharing options...
ashucool83 Posted August 5, 2006 Author Share Posted August 5, 2006 [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] Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69928 Share on other sites More sharing options...
redarrow Posted August 5, 2006 Share Posted August 5, 2006 [code]<?phpheader("location: folder/script.php"); // if a folder is one up to scriptorheader("location: script.php"); // if script is already in folder?>[/code] Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69929 Share on other sites More sharing options...
ronverdonk Posted August 5, 2006 Share Posted August 5, 2006 I am sorry for you, but it works on my system. All 3 cases work: successful, not successful and db error. Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69931 Share on other sites More sharing options...
ashucool83 Posted August 5, 2006 Author Share Posted August 5, 2006 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.phpCode2: Authenticate.phpBased on Code2 it is supposed to redirect to login.php or home.php. Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69933 Share on other sites More sharing options...
ronverdonk Posted August 5, 2006 Share Posted August 5, 2006 Yes, I'll post the code exactly as I used it. I onlu changed the db parms and userid/password and I did not use the PASSWORD attrib for the select.[code]<?php $db = mysql_connect("localhost", "ronverdonk", "ronnie09"); if (!$db) { die('Could not connect: ' . mysql_error()); } else { //echo 'Connected successfully'; } mysql_select_db("vwso",$db); $varUser = "ronverdonk"; $varPass = "ronnie09"; $result = mysql_query("SELECT * FROM authorized_users where userid = '".$varUser."' and passwd='".$varPass."'"); 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] Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69936 Share on other sites More sharing options...
ashucool83 Posted August 5, 2006 Author Share Posted August 5, 2006 hahah ... I copied your code and editted back to what I needed. Works like a baby!!! I still have no clue ??? Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69939 Share on other sites More sharing options...
redarrow Posted August 5, 2006 Share Posted August 5, 2006 your database is this as posted from the first post have you seleted it sharelib Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69943 Share on other sites More sharing options...
ronverdonk Posted August 5, 2006 Share Posted August 5, 2006 You can see what I took out. Did you still use the PASSWORD(pw) in the select statement? Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69944 Share on other sites More sharing options...
ashucool83 Posted August 5, 2006 Author Share Posted August 5, 2006 [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 Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69945 Share on other sites More sharing options...
ashucool83 Posted August 5, 2006 Author Share Posted August 5, 2006 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 typehttp://localhost/MyLibrary/home.phpI can still reach the page without the authentication. How do you guys suggest fixing this ?Thanks Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69947 Share on other sites More sharing options...
ronverdonk Posted August 5, 2006 Share Posted August 5, 2006 That is a different story. After authentication you need to save your session in the $_SESSION array. At each page (after the session_start) you verify that the $_SESSION variables are still intact. If not, redirect visitor to the login.php page. Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69948 Share on other sites More sharing options...
ashucool83 Posted August 5, 2006 Author Share Posted August 5, 2006 Thanks ... will read about that and if more questions will post it over here!!! ;D Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69952 Share on other sites More sharing options...
ronverdonk Posted August 5, 2006 Share Posted August 5, 2006 See the tutorial about session handling at the zend website: [url=http://www.zend.com/zend/tut/session.php]http://www.zend.com/zend/tut/session.php[/url] Link to comment https://forums.phpfreaks.com/topic/16658-how-to-redirect-after-authentication/#findComment-69953 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.