How can I get all id's from a database column into one single array?

Question

How can I fetch all the values from columns (like an id column) and put them into an array?

I'm using PDO API and I tried with other code, but it's not working for me.

$STH = $DBH->query('SELECT Tid  from Playlist ');
$STH->setFetchMode(PDO::FETCH_OBJ);
$result = $STH->fetch();

while($result = mysql_fetch_array($result)) {
    $ids_array[] = $result['Tid'];
}

yes i just tried with this way :p i don't have more idea about mysql i just tried to use this code — badr aldeen
– badr aldeen, Commented May 16, 2015 at 6:37

Dalek · Accepted Answer · 2018-03-22 17:28:31Z

8

You can directly return an id array by specifying the PDO::FETCH_COLUMN.

$stmt = $DBH->query("SELECT Tid from Playlist");
$ids_array = $stmt->fetchAll(PDO::FETCH_COLUMN);

answered Mar 22, 2018 at 17:28

Dalek

1151 silver badge4 bronze badges

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

Comments

Rizier123 · Accepted Answer · 2015-05-16 06:40:03Z

3

You are mixing mysql_* and PDO, which is obviously not going to work.

Just fetchAll() your results and then just merge all rows into one array by simply looping through all rows with array_map() and returning the id, e.g.

$stmt = $DBH->query("SELECT Tid  from Playlist");
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
$ids = array_map(function($v){
    return $v->Tid;
}, $result);

print_r($ids);

answered May 16, 2015 at 6:40

Rizier123

59.8k17 gold badges106 silver badges167 bronze badges

2 Comments

badr aldeen Over a year ago

thanks , but there is a syntax error in your code . it's not working and i have no idea about array map to solve it by my self

Rizier123 Over a year ago

@user44444 Just reload the page again. Just missed a curly bracket.

Collectives™ on Stack Overflow

How can I get all id's from a database column into one single array?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related