Auto fill-in data (input field) from MySQL Database in PHP (PDO)

Question

This post contains:

3 PHP pages
MySQL table picture
Picture of the form

As the title says, I need to extract some information from my database.

So far I have the following:

Index page <-- You need to login here with a personal code. (this is where I get the 'Session username' from that already works at the contact page)
Config page <-- Used for database access and all
Contact page <-- In here I would like to auto fill-in the users data.

Database table consists of:

username; email; realName (and some other stuff I don't need here)

So in the contact page I would like to see the following:

Card number = username (this already works)
Auto fill-in: realName and email according to the username.

Maybe it is possible to extract the info when logging in and storing these in the POST variable already? But how?

Database:

Table I need to use: 'members'

The info given by the user himself/herself = username

The info I need to auto fill-in = realName and email

Picture of the form.

The email should be in the SESSION statement, so I can send a confirmation email to the person, and the realName should be entered from the database.

These are the files currently running:

config.php:

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

} catch(PDOException $e) {
//show error
echo ''.$e->getMessage().'';
exit;
}

//include the user class, pass in the database connection
include('classes/user.php');
include('classes/phpmailer/mail.php');
$user = new User($db);
?>

contact form:

is_logged_in()){ header('Location: index.php'); } 
?>


    *****
    
    
    
    
    
    
 



    

        
            

                
                    
                        
                            Menu
                            
                                Current Project
                                Next Projects
                                Previous Projects
                                Who are we?
                            
                        
                        contact
                        Logout
                    
                
            

        
            
                *****
                Slogan.
                
                    Current Project
                    Next Projects
                    Previous Projects
                    Who are we?
                    contact
                
            

        




            
                
"; } 

if(!empty($error_msg))
{ 
//Een van de velden werd niet goed ingevuld 
echo "Your message can't be send due to the following reason:    

"; 
echo $error_msg; 
echo "
Click on Go back and  provide us with your name.

"; 
}
else 
{ 
$recipient = "*****"; 
$subject = "******"; 
$header = "From: " . $_POST['uwemail'] . "
"; 
$mail_body = "Contact script werd op " . date("d-m-Y") . " om " . date("H:i") . " uur uitgevoerd.
"; 
$mail_body .= "*****:

"; 
$mail_body .= "Naam: " . $_POST['name2'] . "
"; 
$mail_body .= "Met als kaartnummer: " . $_POST['card2'] . "
"; 
$mail_body .= "******: " .  $_POST['current2'] . "
"; 
$mail_body .= "******: " .  $_POST['next2'] . "
"; 
$mail_body .= "Voor een totaal van: " . $_POST['total2'] . " EUR.";   
$mail_body .= "

 -- ****** --"; 
mail($recipient, $subject, $mail_body, $header); 
print "IMPORTANT!";
print "

*****.";
print "

***** ";
print $_POST['total2'];
print " *****";
print "

******.";
print "

******";
}
} 
else 
{ 
?>      
        
                        
                            
                            Your personal card number
                                
                            
                            
                            Please enter your name. (mandatory)
                                
                            
                        
                        
                            
                            Current Project - Smile
                                
                            
                            
                            Next Project - Sand
                                
                            
                        
                        
                            
                                
                            
                            
                                
                            
                        
                                        
                                            
                                        
                        
                        Total price.(In EUR)
                                
                            
                        

                        
                            
                                
                                    
                                
                            
                        
                    


 

                
            


        
            

                
                    © *****. All rights reserved.

Index page (where they have to login)

login($username,$password)){ 
    $_SESSION['username'] = $username;
    header('Location: home.php');
    exit;

} else {
    $error[] = 'Wrong username or password or your account has not been activated.';
}

}//end if submit


?>






    ******
    
    
    
    
    
    
    



    
        

            
                
                    

                        *****
                        Coming soon.







    
        
            Please Login

            

            '.$error.'';
                }
            }

            if(isset($_GET['action'])){

                //check the action
                switch ($_GET['action']) {
                    case 'active':
                        echo "Your account is now active you may now log in.";
                        break;
                    case 'reset':
                        echo "Please contact us for a new card.";
                        break;
                    case 'resetAccount':
                        echo "Password changed, you may now login.";
                        break;
                }

            }


            ?>

            
                
            

            
                
            




            
                
            

                
                
                     Lost your card? Contact us.
                
            

        
    









                    

                

            
                
                    
                        © ******

J. DKYSR · Accepted Answer

I fixed the problem.

In the user.php file I had everything prepared already, but I just didn't understand why it didn't work.

Turned out to be a simple error XD

_db = $db;
}
private function get_user_hash($username){
    try {
        $stmt = $this->_db->prepare('SELECT password, username, memberID, realName, email FROM members WHERE username = :username AND active="Yes" ');
        $stmt->execute(array('username' => $username));
        return $stmt->fetch();
    } catch(PDOException $e) {
        echo ''.$e->getMessage().'';
    }
}
public function login($username,$password){
    $row = $this->get_user_hash($username);
    if($this->password_verify($password,$row['password']) == 1){
        $_SESSION['loggedin'] = true;
        $_SESSION['username'] = $row['username'];
        $_SESSION['memberID'] = $row['memberID'];
        $_SESSION['realName'] = $row['realName']; 
        $_SESSION['email'] = $row['email'];  
        return true;
    }
}

public function logout(){
    session_destroy();
}

public function is_logged_in(){
    if(isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true)    {
        return true;
    }
}
}
?>

I forgot to add the realName and email to this line: (idiot me :D)

$stmt = $this->_db->prepare('SELECT password, username, memberID, realName, email FROM members WHERE username = :username AND active="Yes" ');

Auto fill-in data (input field) from MySQL Database in PHP (PDO)

Answers (2)

Related Questions