Set a Value from a SQL table select statement to a local variable

Question

I'm trying to take the CustomerID from the SQL select statement and then assign it to a $_SESSION variable i can use later on during the session.

MY CODE:

session_start();  
    $Username = $request->getParam('Username');
    $PassW = $request->getParam('PassW');


    $sql = "SELECT CustomerID FROM login WHERE Username= '$Username' AND PassW='$PassW' LIMIT 1";


    try{
        $db = new db();
        $db = $db->connect();

        $stmt = $db->query($sql);
        $stmt->execute();
        $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

        if(count($result) == 1){  
        $_SESSION['Username'] = $Username;
        $_SESSION['CustomerID'] = '****CUSTOMER ID FROM TABLE****';

I'm new to this so any help is appreciated :)

Possible duplicate of [Set variable from SELECT PHP](https://stackoverflow.com/questions/4930961/set-variable-from-select-php) — Lalit, Apr 05 '18 at 23:42

score -1 · Answer 1 · answered Apr 05 '18 at 23:57

-1

Sovled it.

$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

needed to be

$result = $stmt->fetchColumn();

answered Apr 05 '18 at 23:57

early237

25
1
7

Set a Value from a SQL table select statement to a local variable

1 Answers1