PHP PDO Undefined Index

Question

I've had a look round on google and a couple of other sites, but I can't figure out why this isn't working.

I'm working on a uni assignment, and run the following code:

$db = connect();
$testname = 'chunk';
 try {
        $stmt = $db->prepare('SELECT * FROM TreasureHunt.Player WHERE name = ?');
        $stmt->execute(array($testname));
        $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $stmt->closeCursor();
        } 
    catch (PDOException $e) { 
    print "Error checking login: " . $e->getMessage(); 
}

$count = $stmt->rowCount();
echo 'Row count: ', $count, '<br>';
var_dump($result);
echo '<br>Result: ', $result['name'], ' pw: ', $result["password"], '<br>';
print_r($result);

However this results in the following errorm:

Notice: Undefined index: name in /.automount/net/ufiler2/u2/cs3/dbes2376/lib/html/th/index.php on line 30

Now I know that means, that in my $result variable the index 'name' must not exist. But this confuses me because it does exist, checked by looking in: var_dump($result) var_dump($result) gives me:

array(1) { [0]=> array(5) { ["name"]=> string(5) "chunk" ["password"]=> string(7) "truffle" ["pw_salt"]=> string(8) "g#m#g#m#" ["gender"]=> string(1) "m" ["addr"]=> string(10) "Goon Docks" } }

and print_r($result) gives me:

Array ( [0] => Array ( [name] => chunk [password] => truffle [pw_salt] => g#m#g#m# [gender] => m [addr] => Goon Docks ) )

So why can I not refer to them as $result['name'] ? Or how do I actually refer to it?

Thanks. Sorry if this is a basic question.

As you can see from the output of `var_dump($result)` , it's an array with another array in it. — Ofir Baruch, May 27 '13 at 13:08
Wow, that's a lot of unexplained downvotes, especially for a question that's actually fairly well written. Downvoters, kindly comment too? — Craig Ringer, May 27 '13 at 13:36

score 3 · Accepted Answer · edited May 27 '13 at 13:11

3

You should be using $result[0]['name'];

edited May 27 '13 at 13:11

Sirko

72,589
19
149
183

answered May 27 '13 at 13:07

Shane Armstrong

54
2

3

a little explanation wouldn't hurt, if it would help other users with the same problem.. – reikyoushin May 27 '13 at 13:26
Agreed, I will post more information in future. – Shane Armstrong May 27 '13 at 13:31

score 2 · Answer 2 · answered May 27 '13 at 13:07

2

fetchAll() returns an array of arrays. So in your case access

$result[0]['name']

instead of

$result['name']

Another option would be to use just fetch() in order to get only the one row of the result each time.

answered May 27 '13 at 13:07

Sirko

72,589
19
149
183

Ahh.. so its a multidimensional array. Thank you. – Max May 27 '13 at 13:10

Phil Cross · Answer 3 · 2013-05-27T14:00:24.163

0

You have several errors in your code. I have rewritten it to hopefully remove them, and get it working as expected:

$db = connect();
$testname = 'chunk';

try {
    $stmt = $db->prepare('SELECT * FROM TreasureHunt.Player WHERE name = ?');
    $stmt->execute(array($testname));

    foreach($stmt->fetchAll(PDO::FETCH_ASSOC) as $row){
        echo 'Result: ' . $result['name'] . ' pw: ' . $result['password'] . '<br />';
    }
} catch (PDOException $e) { 
    print "Error checking login: " . $e->getMessage(); 
}

$count = $stmt->rowCount();
echo 'Row count: ' . $count .  '<br>';

edited May 27 '13 at 14:00

answered May 27 '13 at 13:14

Phil Cross

9,017
12
50
84

-1 for using exception to print error out... and still many errors left – Your Common Sense May 27 '13 at 13:21
@YourCommonSense I only added the exception error because it was in the original code example. Not really a reason for downvoting. – Phil Cross May 27 '13 at 13:23
@YourCommonSense ah, just seen the mistakes with the last echo, corrected them, thanks – Phil Cross May 27 '13 at 14:00
1

It weren't a mistake but rather correct syntax :) – Your Common Sense May 27 '13 at 14:19

score 0 · Answer 4 · edited May 23 '17 at 11:57

You have several errors in your code. I have rewritten it to hopefully remove them, and get it working as expected. You have to also connect as described in the tag wiki

$db = connect();
$testname = 'chunk';
$stmt = $db->prepare('SELECT * FROM TreasureHunt.Player WHERE name = ?');
$stmt->execute(array($testname));
$row = $stmt->fetch();

$count = $stmt->rowCount();
echo 'Row count: ', $count, '<br>';
echo '<br>Result: ', $row['name'], ' pw: ', $row["password"], '<br>';

PHP PDO Undefined Index

4 Answers4