mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 Like this: <div id="wb_Shape2" style="position:absolute;left:54px;top:170px;width:793px;height:412px;z-index:10" align="center"> <img src="/Images/body_img.jpg" id="Shape2" align="top" alt="" title="" border="0" width="793" height="412"></div> <?php if(isset($_POST['login'])){ $_SESSION['myusername'] = $_POST['myusername']; $username = $_SESSION['myusername']; ?> <div id="wb_Text1" style="position:absolute;left:684px;top:55px;width:151px;height:14px;z-index:7" align="right"> <font style="font-size:13px" color="#FFFFFF" face="Arial">You are logged in as:</font><br> <font style="font-size:15px" color="#FF0000" face="Arial"> <?php echo ucwords(strtolower($username)); ?> </font></div> <?php } else { ?> Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883332 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 this always shows the login form both logged in and not logged in: <?php if(isset($_POST['Login'])){ $_SESSION['myusername'] = $_POST['myusername']; $username = $_SESSION['myusername']; echo ucwords(strtolower($username)); ?> <div id="wb_Text1" style="position:absolute;left:684px;top:55px;width:151px;height:14px;z-index:7" align="right"> <font style="font-size:13px" color="#FFFFFF" face="Arial">You are logged in as:</font><br> <font style="font-size:15px" color="#FF0000" face="Arial"> </font></div> <?php } else { ?> <form name="form1" method="post" action="checklogin.php"> <input type="text" id="myusername" style="position:absolute;left:651px;top:59px;width:174px;font-family:Arial;font-size:13px;z-index:4" size="29" name="myusername" value="" title="username"> <input type="password" id="mypassword" style="position:absolute;left:651px;top:86px;width:174px;font-family:Arial;font-size:13px;z-index:5" size="29" name="mypassword" value="" tabindex="password" title="password"> <input type="checkbox" id="Checkbox1" name="Checkbox1" value="on" style="position:absolute;left:648px;top:113px;font-family:Arial;font-size:13px;z-index:6"> <input type="submit" id="Button1" name="Login" value="Login" style="position:absolute;left:778px;top:117px;width:50px;height:43px;font-family:Arial;font-size:13px;z-index:8" title="Login"> </form> <div id="wb_Text7" style="position:absolute;left:584px;top:66px;width:47px;height:16px;z-index:22" align="left"> <font style="font-size:13px" color="#FFFFFF" face="Arial">Username:</font></div> <div id="wb_Text8" style="position:absolute;left:586px;top:91px;width:65px;height:16px;z-index:23" align="left"> <font style="font-size:13px" color="#FFFFFF" face="Arial">Password:</font></div> <div id="wb_Text2" style="position:absolute;left:669px;top:116px;width:111px;height:14px;z-index:7" align="left"> <font style="font-size:11px" color="#FFFFFF" face="Arial">Remember Me</font></div> <div id="wb_Text3" style="position:absolute;left:651px;top:134px;width:122px;height:14px;z-index:9" align="left"> <font style="font-size:11px" color="#FFFFFF" face="Arial">Forgot your password?</font></div> <?php } ?> Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883341 Share on other sites More sharing options...
mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 Can you post the code for checklogin.php Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883344 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name=""; // 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"); if(isset($_POST['Login'])){ // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $_SESSION['myusername']=$dbusername; $sql="SELECT * FROM $tbl_name WHERE username='$myusername' 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 "profile.php" session_register("myusername"); session_register("mypassword"); header("location:profile.php"); } else { header("location: http://www.squiblo.com/retrylogin.php"); } } ?> Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883347 Share on other sites More sharing options...
mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name=""; // 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"); if(isset($_POST['Login'])){ // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $_SESSION['myusername']=$dbusername; $sql="SELECT * FROM $tbl_name WHERE username='$myusername' 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 "profile.php" session_register("myusername"); session_register("mypassword"); header("location:profile.php"); } else { header("location: http://www.squiblo.com/retrylogin.php"); } } ?> From where this $dbusername is coming? $_SESSION['myusername']=$dbusername; Why not this and whats the point for storing pass in session. $_SESSION['myusername']; instead of this: session_register("myusername"); session_register("mypassword"); Now to next script. <?php if(isset($_POST['Login'])){ ?> echo<div id="wb_Text1" style="position:absolute;left:684px;top:55px;width:151px;height:14px;z-index:7" align="right"> <font style="font-size:13px" color="#FFFFFF" face="Arial">You are logged in as:</font><br> <font style="font-size:15px" color="#FF0000" face="Arial"> </font></div> <?php ucwords(strtolower($_SESSION['myusername'])); } else { ?> <form name="form1" method="post" action="checklogin.php"> <input type="text" id="myusername" style="position:absolute;left:651px;top:59px;width:174px;font-family:Arial;font-size:13px;z-index:4" size="29" name="myusername" value="" title="username"> <input type="password" id="mypassword" style="position:absolute;left:651px;top:86px;width:174px;font-family:Arial;font-size:13px;z-index:5" size="29" name="mypassword" value="" tabindex="password" title="password"> <input type="checkbox" id="Checkbox1" name="Checkbox1" value="on" style="position:absolute;left:648px;top:113px;font-family:Arial;font-size:13px;z-index:6"> <input type="submit" id="Button1" name="Login" value="Login" style="position:absolute;left:778px;top:117px;width:50px;height:43px;font-family:Arial;font-size:13px;z-index:8" title="Login"> </form> <div id="wb_Text7" style="position:absolute;left:584px;top:66px;width:47px;height:16px;z-index:22" align="left"> <font style="font-size:13px" color="#FFFFFF" face="Arial">Username:</font></div> <div id="wb_Text8" style="position:absolute;left:586px;top:91px;width:65px;height:16px;z-index:23" align="left"> <font style="font-size:13px" color="#FFFFFF" face="Arial">Password:</font></div> <div id="wb_Text2" style="position:absolute;left:669px;top:116px;width:111px;height:14px;z-index:7" align="left"> <font style="font-size:11px" color="#FFFFFF" face="Arial">Remember Me</font></div> <div id="wb_Text3" style="position:absolute;left:651px;top:134px;width:122px;height:14px;z-index:9" align="left"> <font style="font-size:11px" color="#FFFFFF" face="Arial">Forgot your password?</font></div> <?php } ?> Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883352 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 after changing the checklogin.php and putting in: $_SESSION['myusername']; i cant loggin. Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883358 Share on other sites More sharing options...
mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 $_SESSION['myusername'] = $myusername; Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883359 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 after changing check login to: $_SESSION['myusername'] = $myusername; i can login just like normal but on the about.php page the login form is still visable on the page if logged in or logged out, maybe going about it a different way and using include may help, although ive never used include Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883363 Share on other sites More sharing options...
mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 Post both about.php and checklogin.php updated code. Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883366 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 checklogin.php: <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name=""; // 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"); if(isset($_POST['Login'])){ // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $_SESSION['myusername']=$dbusername; $sql="SELECT * FROM $tbl_name WHERE username='$myusername' 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 "profile.php" $_SESSION['myusername'] = $myusername; header("location:profile.php"); } else { header("location: http://www.squiblo.com/retrylogin.php"); } } ?> about.php: <?php session_start(); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Squiblo - About Us!</title> <style type="text/css"> div#container { width: 900px; position: relative; margin-top: 0px; margin-left: auto; margin-right: auto; text-align: left; } body { text-align: center; margin: 0; } </style> </head> <body bgcolor="#E6E6E6" text="#000000"> <div id="container"> <div id="wb_Shape1" style="position:absolute;left:55px;top:41px;width:792px;height:125px;z-index:2" align="center"> <img src="/Images/header_img.jpg" id="Shape1" align="top" alt="" title="" border="0" width="792" height="125"></div> <div id="wb_Text1" style="position:absolute;left:60px;top:85px;width:325px;height:72px;z-index:3" align="left"> <font style="font-size:70px" color="#FFFFFF" face="impact"><a href="/index.php" style="text-decoration:none"> <font color="#FFFFFF">SQUIBLO</a></font></font></div> <div id="wb_Shape2" style="position:absolute;left:54px;top:170px;width:793px;height:412px;z-index:10" align="center"> <img src="/Images/body_img.jpg" id="Shape2" align="top" alt="" title="" border="0" width="793" height="412"></div> <?php if(isset($_POST['Login'])){ ?> echo<div id="wb_Text1" style="position:absolute;left:684px;top:55px;width:151px;height:14px;z-index:7" align="right"> <font style="font-size:13px" color="#FFFFFF" face="Arial">You are logged in as:</font><br> <font style="font-size:15px" color="#FF0000" face="Arial"> </font></div> <?php ucwords(strtolower($_SESSION['myusername'])); } else { ?> <form name="form1" method="post" action="checklogin.php"> <input type="text" id="myusername" style="position:absolute;left:651px;top:59px;width:174px;font-family:Arial;font-size:13px;z-index:4" size="29" name="myusername" value="" title="username"> <input type="password" id="mypassword" style="position:absolute;left:651px;top:86px;width:174px;font-family:Arial;font-size:13px;z-index:5" size="29" name="mypassword" value="" tabindex="password" title="password"> <input type="checkbox" id="Checkbox1" name="Checkbox1" value="on" style="position:absolute;left:648px;top:113px;font-family:Arial;font-size:13px;z-index:6"> <input type="submit" id="Button1" name="Login" value="Login" style="position:absolute;left:778px;top:117px;width:50px;height:43px;font-family:Arial;font-size:13px;z-index:8" title="Login"> </form> <div id="wb_Text7" style="position:absolute;left:584px;top:66px;width:47px;height:16px;z-index:22" align="left"> <font style="font-size:13px" color="#FFFFFF" face="Arial">Username:</font></div> <div id="wb_Text8" style="position:absolute;left:586px;top:91px;width:65px;height:16px;z-index:23" align="left"> <font style="font-size:13px" color="#FFFFFF" face="Arial">Password:</font></div> <div id="wb_Text2" style="position:absolute;left:669px;top:116px;width:111px;height:14px;z-index:7" align="left"> <font style="font-size:11px" color="#FFFFFF" face="Arial">Remember Me</font></div> <div id="wb_Text3" style="position:absolute;left:651px;top:134px;width:122px;height:14px;z-index:9" align="left"> <font style="font-size:11px" color="#FFFFFF" face="Arial">Forgot your password?</font></div> <?php } ?> <div id="copyright" style="position:absolute;left:55px;top:588px;width:150px;height:44px;z-index:32" align="left"> <font style="font-size:13px" color="#000000" face="Arial">Squiblo © 2009</font></div> <div id="about" style="position:absolute;left:185px;top:588px;width:150px;height:44px;z-index:33" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/about.php"><font color=#000000>About Us</font></a></font></div> <div id="terms" style="position:absolute;left:285px;top:588px;width:150px;height:44px;z-index:34" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/terms.php"><font color=#000000>Terms and Conditions</font></a></font></div> <div id="contact" style="position:absolute;left:450px;top:588px;width:150px;height:44px;z-index:35" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/contact.php"><font color=#000000>Contact Us</font></a></font></div> <div id="privacy" style="position:absolute;left:555px;top:588px;width:150px;height:44px;z-index:36" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/privacy.php"><font color=#000000>Privacy</font></a></font></div> <div id="help" style="position:absolute;left:640px;top:588px;width:150px;height:44px;z-index:36" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/help.php"><font color=#000000>Help</font></a></font></div> </div> </body> </html> Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883369 Share on other sites More sharing options...
vineld Posted July 26, 2009 Share Posted July 26, 2009 You are probably failing to follow the logic of your code. For debugging purposes now and in the future this is something you should learn doing because it will save you a LOT of time when your code is a bit more complex than this one. Try following each step in the process and figure out where things are going wrong. The best way to do this (if there are no apparent error messages) is to print PHP values in strategic places. Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883371 Share on other sites More sharing options...
mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 Not sure, why you are using this, i commented it in your code. $_SESSION['myusername']=$dbusername; <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name=""; // 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"); if(isset($_POST['Login'])){ // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); //$_SESSION['myusername']=$dbusername; $sql="SELECT * FROM $tbl_name WHERE username='$myusername' 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 "profile.php" $_SESSION['myusername'] = $myusername; header("location:profile.php"); } else { header("location: http://www.squiblo.com/retrylogin.php"); } } ?> Here you go... <?php session_start(); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Squiblo - About Us!</title> <style type="text/css"> div#container { width: 900px; position: relative; margin-top: 0px; margin-left: auto; margin-right: auto; text-align: left; } body { text-align: center; margin: 0; } </style> </head> <body bgcolor="#E6E6E6" text="#000000"> <div id="container"> <div id="wb_Shape1" style="position:absolute;left:55px;top:41px;width:792px;height:125px;z-index:2" align="center"> <img src="/Images/header_img.jpg" id="Shape1" align="top" alt="" title="" border="0" width="792" height="125"></div> <div id="wb_Text1" style="position:absolute;left:60px;top:85px;width:325px;height:72px;z-index:3" align="left"> <font style="font-size:70px" color="#FFFFFF" face="impact"><a href="/index.php" style="text-decoration:none"> <font color="#FFFFFF">SQUIBLO</a></font></font></div> <div id="wb_Shape2" style="position:absolute;left:54px;top:170px;width:793px;height:412px;z-index:10" align="center"> <img src="/Images/body_img.jpg" id="Shape2" align="top" alt="" title="" border="0" width="793" height="412"></div> <?php if($_SESSION['myusername'])){ ?> echo<div id="wb_Text1" style="position:absolute;left:684px;top:55px;width:151px;height:14px;z-index:7" align="right"> <font style="font-size:13px" color="#FFFFFF" face="Arial">You are logged in as:</font><br> <font style="font-size:15px" color="#FF0000" face="Arial"> </font></div> <?php ucwords(strtolower($_SESSION['myusername'])); } else { ?> <form name="form1" method="post" action="checklogin.php"> <input type="text" id="myusername" style="position:absolute;left:651px;top:59px;width:174px;font-family:Arial;font-size:13px;z-index:4" size="29" name="myusername" value="" title="username"> <input type="password" id="mypassword" style="position:absolute;left:651px;top:86px;width:174px;font-family:Arial;font-size:13px;z-index:5" size="29" name="mypassword" value="" tabindex="password" title="password"> <input type="checkbox" id="Checkbox1" name="Checkbox1" value="on" style="position:absolute;left:648px;top:113px;font-family:Arial;font-size:13px;z-index:6"> <input type="submit" id="Button1" name="Login" value="Login" style="position:absolute;left:778px;top:117px;width:50px;height:43px;font-family:Arial;font-size:13px;z-index:8" title="Login"> </form> <div id="wb_Text7" style="position:absolute;left:584px;top:66px;width:47px;height:16px;z-index:22" align="left"> <font style="font-size:13px" color="#FFFFFF" face="Arial">Username:</font></div> <div id="wb_Text8" style="position:absolute;left:586px;top:91px;width:65px;height:16px;z-index:23" align="left"> <font style="font-size:13px" color="#FFFFFF" face="Arial">Password:</font></div> <div id="wb_Text2" style="position:absolute;left:669px;top:116px;width:111px;height:14px;z-index:7" align="left"> <font style="font-size:11px" color="#FFFFFF" face="Arial">Remember Me</font></div> <div id="wb_Text3" style="position:absolute;left:651px;top:134px;width:122px;height:14px;z-index:9" align="left"> <font style="font-size:11px" color="#FFFFFF" face="Arial">Forgot your password?</font></div> <?php } ?> <div id="copyright" style="position:absolute;left:55px;top:588px;width:150px;height:44px;z-index:32" align="left"> <font style="font-size:13px" color="#000000" face="Arial">Squiblo © 2009</font></div> <div id="about" style="position:absolute;left:185px;top:588px;width:150px;height:44px;z-index:33" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/about.php"><font color=#000000>About Us</font></a></font></div> <div id="terms" style="position:absolute;left:285px;top:588px;width:150px;height:44px;z-index:34" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/terms.php"><font color=#000000>Terms and Conditions</font></a></font></div> <div id="contact" style="position:absolute;left:450px;top:588px;width:150px;height:44px;z-index:35" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/contact.php"><font color=#000000>Contact Us</font></a></font></div> <div id="privacy" style="position:absolute;left:555px;top:588px;width:150px;height:44px;z-index:36" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/privacy.php"><font color=#000000>Privacy</font></a></font></div> <div id="help" style="position:absolute;left:640px;top:588px;width:150px;height:44px;z-index:36" align="left"> <font style="font-size:13px" color="#000000" face="Arial"><a href="/help.php"><font color=#000000>Help</font></a></font></div> </div> </body> </html> hope this time it will work. Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883375 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 there is an error in the script, not sure what line Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883377 Share on other sites More sharing options...
mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 Oh..sori my mistake...Ahhhh its 2.30am...mind sleeping.. Change this: if($_SESSION['myusername'])){ to this: if($_SESSION['myusername']){ Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883378 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 view the page now, echo is echoed. Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883381 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 it is getting closer, when you are not logged in it show the login form, when u are logged in it shows, "you are logged in as:". but without the username from the database. Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883383 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 when i try to login, it redirects me to notloggedin.php Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883385 Share on other sites More sharing options...
mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 checklogin.php <?php session_start(); $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name=""; // 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"); if(isset($_POST['Login'])){ // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); //$_SESSION['myusername']=$dbusername; $sql="SELECT * FROM $tbl_name WHERE username='$myusername' 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 "profile.php" $_SESSION['myusername'] = $myusername; header("location:profile.php"); } else { header("location: http://www.squiblo.com/retrylogin.php"); } } ?> Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883390 Share on other sites More sharing options...
squiblo Posted July 26, 2009 Author Share Posted July 26, 2009 cant log in and it takes me to notloggedin.php Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883394 Share on other sites More sharing options...
mmarif4u Posted July 26, 2009 Share Posted July 26, 2009 From where it is redirecting you to notloggedin.php. i did not see any header to redirect you there. Plz check your code again. Mb you miss something there. I m going to bed now...mb somebody will help...but if you need further help, can PM me. Quote Link to comment https://forums.phpfreaks.com/topic/167469-solved-else-problem/page/2/#findComment-883398 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.