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
please help me... my password gets encrypted but not able to get in database
hai guys,
please help me... in the following function my password gets encrypted but no
Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website
Undefined index: username HELP NEWBIE
I am trying a simple login/logout for my website. It works well with checking if the username exists
How to refresh a parent page from a modal popup
Hi,I have a modal popup in which I need to upload a file and store in the database should give a mes
PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi
Help with echo()
I'm having some problems with this code:
Code: echo '
<A HREF="jav
what does this mean? +=
is anyone able to explain what this code is saying?
i had it written for me awhile back and n
Wrong Info sent Using $get in form
Hi i have this code that i tried to make to send some info from one page to aother with lots of ppls
Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice
what business processes?
Hi,
A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)
