user validation always displaying invalid ? please help
Posted on
16th Feb 2014 07:03 pm by
admin
Hello,
I have 2 accounts and there is a field in mysql called validated it can be either "true" or "false"
I tried writing a code so when the user logs in if the user is validated meaning
$username = $_POST['username'];
$validated = true
$validation = a mysql query that selects validated from members where username = $username
$validated == $validation
and I have to accounts made
1 account username is "google" its validation is set to false
2nd account username is "jaydesigns" its validation is set to true
but when I login both come up as not validated
here is the page code:
Code: <?
include_once"config.php";
$final_report = "Please complete all the fields below..";
if(isset($_POST['login'])){
$username= trim($_POST['username']);
$password = trim($_POST['password']);
if($username == NULL OR $password == NULL){
$final_report = "Please complete all the fields below..";
}else{
$check_user_data = mysql_query("SELECT * FROM `members` WHERE `username` = '$username'") or die(mysql_error());
if(mysql_num_rows($check_user_data) == 0){
$final_report = "This username does not exist..";
}else{
$get_user_data = mysql_fetch_array($check_user_data);
if($get_user_data['password'] == $password){
$start_idsess = $_SESSION['username'] = "".$get_user_data['username']."";
$start_passsess = $_SESSION['password'] = "".$get_user_data['password']."";
$validation = mysql_query("SELECT validated FROM `members` WHERE `username` = '$username'") or die(mysql_error());
$validated = "true";
if($validation == $validated) {
$final_report ="You are now logged in $start_idsess ";
} else {
$final_report ="Your account is not validated $start_idsess,
Please Activate your account from the email you recieved from us.
If you did not recieve an email click <a href='./activate-send.php'>here</a> to resend the email
You will be logged out Now";
session_unset('username');
session_unset('password');
}
?>
<meta http-equiv="Refresh" content="0; URL=./members.php">
<?php
}}}}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Funky Vision Membership Script</title>
</head>
<body><form action="" method="post">
<table width="312" align="center">
<tr><td colspan='2'><?php echo "$final_report" ?></td></tr><tr>
<tr>
<td width="120">Username:</td>
<td width="180"><input type="text" name="username" size="30" maxlength="25"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="password" size="30" maxlength="25"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="login" value="Login" /></td>
</tr>
</table>
</form>
</body>
</html>
No comments posted yet
Your Answer:
Login to answer
209 
12 
Other forums
how to get IP address?
hey guys,
i have this code which is supposed to get me the IP address of my site visitors:Read from a text file after a specific word
Hi all.
I have a text file that looks like the one below.
I know how to open the text fi
Stats of viewers
Hello. I have a website in php and people can login. I want to make an admin control panel where u c
Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...
Code: $define_li
Saas with SAP R/3
hi experts,
Is SaaS offer available in SAP? for SAP R/3? from where i can get the info a
Uploading/Downloading files stored in MySQL database
Hey all,
This problem just came up in my website and I'm having a hard time figuring out what
need Array help
This is what I have to do.
$teamname[1] = "Red Sox"
$teamname[2] = "Gian
ALV List display - header width adjust
Hi,
I am using REUSE_ALV_LIST_DISPLAY for my ALV display.The width of the ALV varies for
Help with PHP and checkboxes
I am posting this for a friend of mine, i wrote a small script for her to process her form data to a
elseif help!
OK so I'm new to the site, as well as PHP altogether (Trying my hand at managing an online RPG) and
