Session in php. It's not redirecting to the login page when a user wrongly inputs his information in the form -
when user correctly inserts information in login form redirects home page want i'm having problem when user inputs wrong info. shows connected , database selected. stops on page checklogin.php. if doesn't read session part. please go through code. here's code register form:
<?php $con=mysql_connect("localhost","root",""); if(!$con){ die('could not connect:' .mysql_error()); } echo "connected successfully."; $database=mysql_select_db('90210store'); if(!$database){ die('<br>could not select database:' .mysql_error()); } echo "<br>database selected"; $firstname=$_post['firstname']; //to information written in form $lastname=$_post['lastname']; $emailadd=$_post['emailadd']; $check_list=$_post['check_list']; $dob=$_post['dob']; $gender=$_post['gender']; $password=$_post['password']; $first= "insert login (firstname,lastname,emailadd,newsletter,dob,gender,password) values ('$firstname','$lastname','$emailadd','$check_list','$dob','$gender','$password')"; $result=mysql_query($first); if($result){ echo('<br>data enterred successfully'); } else{ echo('<br>fail'); } if($result) { header('location: phpredirectlogin.php'); } mysql_close($con); ?>
then page redirects to(phpredirectlogin.php):
<?php echo "<script>alert('redirecting login page');</script>"; echo "<script>window.location = 'account.html';</script>"; ?>
this php page checks login(checklogin.php):
<?php $email=$_post['email']; $pwd=$_post['pwd']; $con=mysql_connect("localhost","root",""); if(!$con){ die('could not connect:' .mysql_error()); } echo "connected successfully."; $database=mysql_select_db('90210store'); if(!$database){ die('<br>could not select database:' .mysql_error()); } echo "<br>database selected"; $result = mysql_query("select * login emailadd='$email' , password='$pwd'") or die('queryfailed:'.mysql_error()); while($row=mysql_fetch_array($result)) { session_start(); $_session['id']=1234; header('location:checklogin1.php'); } mysql_close($con); ?>
then page redirects user checklogin1.php.the code is:
<?php session_start(); if(!isset($_session['id'])) { header('location:account.html'); } else { header('location:90210.html'); } ?>
there has error somewhere can't seem figure out. appreciated. thank you.
change
$result = mysql_query("select * login emailadd='$email' , password='$pwd'") or die('queryfailed:'.mysql_error()); while($row=mysql_fetch_array($result)) { session_start(); $_session['id']=1234; header('location:checklogin1.php'); }
to this
$result = mysql_query("select * login emailadd='$email' , password='$pwd' limit 1") or die('queryfailed:'.mysql_error()); if (mysql_num_rows($result) == 1 ) { $_session['id']=1234; header('location:checklogin1.php'); }
and session_start() right beginning of code.
moreover, redirect respective pages here have 1 redirect instead of 2 , rid of checklogin1.php. may edit above condition following:
if(mysql_num_rows($result) == 1) { $_session['id']=1234; header('location:90210.html'); } else { header('location:account.html'); }
Comments
Post a Comment