I am new here but I am trying to get my profile page load data from the profiles database.
I am getting no errors but I am not getting the data either.
<?php
include('connection.php');
if( isset( $_POST['Search'] ) ) {
// build a function to validate data
function validateFormData( $formData ) {
$formData = trim( stripslashes( htmlspecialchars( $formData ) ) );
return $formData;
}
$formEmail = validateFormData( $_POST['email'] );
$query = "SELECT first_name, last_name, email, card_number, pc_type FROM profiles WHERE email ='$formEmail'";
$result = mysqli_query( $conn, $query );
// verify if result is returned
if( mysqli_num_rows($result) > 0 ) {
// store basic user data in variables
while( $row = mysqli_fetch_assoc($result) ) {
$firstname = $row['first_name'];
$lastname = $row['last_name'];
$email = $row['email'];
$cardnumber = $row['card_number'];
$pctype = $row['pc_type'];
}
} else {
$searchError = "<div class='alert alert-danger'>invalid request</div>";
}
if( $formEmail == 'email') {
// correct login details!
// start the session
//session_start();
// store data in SESSION variables
$_SESSION['email'] = $email;
header("Location: profile-page2.php");
}
} else { // there are no results in database
$loginError = "<div class='alert alert-danger'>No such user in database. Please try again. <a class='close' data-dismiss='alert'>×</a></div>";
}
mysqli_close($conn);
?>
Aucun commentaire:
Enregistrer un commentaire