mercredi 19 avril 2017

I am Trying to call info from a MYSQL Database with PHP

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'>&times;</a></div>";

    }

     mysqli_close($conn);

?>




Aucun commentaire:

Enregistrer un commentaire