Verify

[dnirvine]

I am having trouble writting a code that will verify a user and store all the info in the table to sessions so it can be displayed in certain areas of the members area.

My table name is dnidesign_clients.

Can anyone write a correct code for this. Thanks.

[drawmack]

all you have to store in the session variable is the unique id from the table then you can retrieve the data whenever it is needed. This is better because you don't have to manually update the session with your update routines or worry about an admin changing someone's info while they are on and that info not getting forwarded to their sessions.

[dnirvine]

I have this code....

<? 
/* Check User Script */ 
session_start();  // Start Session 

include 'clientarea/config.php'; 
// Conver to simple variables 
$username = $_POST['account']; 
$password = $_POST['password']; 

if((!$username) || (!$password)){ 
    echo "Please enter ALL of the information! <br />"; 
    include 'login_form.php'; 
    exit(); 
} 

// Convert password to md5 hash 
// $password = md5($password); 

// check if the user info validates the db 
$sql = mysql_query("SELECT * FROM dnidesign_clients WHERE username='$username' AND password='$password'"); 
$login_check = mysql_num_rows($sql); 

if($login_check > 0){ 
    while($row = mysql_fetch_array($sql)){ 
    foreach( $row AS $key => $val ){ 
        $$key = stripslashes( $val ); 
    } 
        // Register some session variables! 
        session_register('firstname'); 
        $_SESSION['firstname'] = $first_name; 
        session_register('lastname'); 
        $_SESSION['lastname'] = $last_name; 
        session_register('email'); 
        $_SESSION['email'] = $email_address; 

    header("Location: login_success.php"); 
} 
} else { 
    echo "You could not be logged in! Either the username and password do not match or you have not validated your membership!<br /> 
    Please try again!<br /> $username $password"; 
    include 'login_form.php'; 
} 
?> 

However this doesn't seem to work. It always returns the "You could not be logged in!" Why?

[dnirvine]

Anyone know?

[ultraslacker]

Originally posted by dnirvine
Anyone know?

Do you have no debugging?

How are you checking if you are making a connection to the database?

[dnirvine]

Another script I had on a page using the same config file connected just find and showed some some information.