CODEWITHSUNDEEP
phpmysqlsession
LeviZoesch
LeviZoesch

Reputation: 1621

Query table from Session value

I am using $_SESSION['']; to get values from a user after they have logged in. This data is coming from the users table.

I am then trying to SELECT * FROM roster table by doing a query and assigning a var for each value when the users API=$API 

error_reporting(E_ALL);
    include ('database_connection.php');

        $DOCSIGNEDBYIP = $_SERVER['REMOTE_ADDR'];
        $API = $_SESSION['API'];
        $FirstName = $_SESSION['firstname'];
        $LastName = $_SESSION['lastname'];
        $Email = $_SESSION['email'];
        $ExecutionDate = date();

     $query = "SELECT * FROM roster WHERE API='$API'";
          $result = mysqli_query($dbc, $query);  
          $address = $result['address'];

database_connection.php

$dbc = @mysqli_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD,
 DATABASE_NAME);

I am not getting anything. No errors.

Upvotes: 0

Views: 38

Answers (1)

BryanLavinParmenter
BryanLavinParmenter

Reputation: 416

You have to use mysqli_fetch_array() or mysqli_fetch_assoc() or similar function to return values from your mysqli_query() query. See below:

$query = "SELECT * FROM roster WHERE API='$API'";
$result = mysqli_fetch_array(mysqli_query($dbc, $query));
$address = $result['address'];

Upvotes: 1

Related Questions