Quick way to turn single-value array into variable in PHP?

Question

Say I have an array which fetched a single row from my database via the PDO::FETCH_ASSOC method, which I would then assign to a variable like so:

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

$result now holds an array equal to the following:

Array ( 
  [id] => 42
)

So, to assign the value 'id' to a variable by itself, I then have to go:

$id = $result['id'];

Is there a quicker way to do this, or even better, to make sure the query result from my database is a variable rather than an array directly, assuming the query is always guaranteed to return 1 result?

php.net/manual/en/pdostatement.fetchcolumn.php

Mark Baker
– Mark Baker

2013-08-19 09:04:23 +00:00
Commented Aug 19, 2013 at 9:04 — Mark Baker
– Mark Baker, Commented Aug 19, 2013 at 9:04

Joe Minichino · Accepted Answer · 2013-08-19 09:05:25Z

1

This should do the trick

$result = $stmt->fetchColumn();

Docs here (just noticed Mark Baker also put it in his comment).

answered Aug 19, 2013 at 9:05

Joe Minichino

2,76524 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

michi · Accepted Answer · 2013-08-19 09:03:35Z

1

in PHP >= 5.4, try

$result = $stmt->fetch(PDO::FETCH_ASSOC)[0];

this is a guess, though, you have to test it.

answered Aug 19, 2013 at 9:03

michi

6,6255 gold badges35 silver badges56 bronze badges

Collectives™ on Stack Overflow

Quick way to turn single-value array into variable in PHP?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related