Login using PDO - Php

Question

I am implementing a simple user login using PDO. But it is giving me a warning message :

Notice: Undefined index: id in login.php on line 39.

Code:

<?php
if($_POST)
{

    $query = $db->prepare('SELECT * FROM users 
                           WHERE email = :email and password = :pass');

    $query->execute(array(':email' => $_POST['email'], 
                  ':pass'  => $_POST['password'])); 

    $count  = $query->rowCount();

    if($count==1)
    {
        $result         = $query->fetchAll();

        $_SESSION['user']   = $result['id'];

        header("location:index.php");   
        exit;   
    }
    else
    {
        $_SESSION['message']='Invalid login details.';
        header("location:login.php");   
        exit;   
    }
}
?>

What am I missing here?

possible duplicate of [PHP: "Notice: Undefined variable" and "Notice: Undefined index"](http://stackoverflow.com/questions/4261133/php-notice-undefined-variable-and-notice-undefined-index) — Gajus, Apr 15 '14 at 12:12

score 2 · Accepted Answer · answered Apr 15 '14 at 12:16

2

Assuming you store unique usernames. You don't need to use fetchAll() here. You can use fetch();

$result = $query->fetch(PDO::FETCH_ASSOC);
echo $result['id'];

answered Apr 15 '14 at 12:16

Jay Bhatt

5,601
5
40
62

score 0 · Answer 2 · answered Apr 15 '14 at 12:14

0

fetchAll returns an array: http://www.php.net/manual/en/pdostatement.fetchall.php

So you'll need $result[0]['id']

answered Apr 15 '14 at 12:14

Luceos

6,629
1
35
65

Login using PDO - Php

2 Answers2