Getting array in different format from data fetched using SQL

Question

After executing a prepared SQL statement in PHP, I've doing a fetchAll(). This results in the following array:

Array
(

    [0] => Array
    (
        [ID] => 2
        [0] => 2
        [latitude] => 38.44560000
        [1] => 38.44560000
        [longitude] => -99.99999999
        [2] => -99.99999999
    )
    [1] => Array
    (
        [ID] => 4
        [0] => 4
        [latitude] => 38.44560000
        [1] => 38.44560000
        [longitude] => -99.99999999
        [2] => -99.99999999
    )
)

I would like my array to look like this:

Array
(

    [0] => array('2','otheritem1details....','38.44560000','-99.99999999'),
    [1] => array('4','otheritem1details....','38.44560000','-99.99999999')
)

Do I have to take the data from the source array and manually compile it into a new array in the correct format? Or is there a way to fetch the data initially in the correct format?

Many thanks.

possible duplicate of PDO::FETCH_ASSOC What is about PDO::FETCH_ARRAY? — Rimas
– Rimas, Commented Sep 1, 2014 at 19:39
It's not quite the same - my desired output is different, see below for more info. Thanks. — user1744974
– user1744974, Commented Sep 1, 2014 at 19:44

Community · Accepted Answer · 2023-11-17 20:33:26Z

3

fetchAll() takes a fetch style as an optional first parameter. This defaults to PDO::FETCH_BOTH.

From the manual:

PDO::FETCH_BOTH (default): returns an array indexed by both column name and 0-indexed column number as returned in your result set

What you want is PDO::FETCH_NUM:

PDO::FETCH_NUM: returns an array indexed by column number as returned in your result set, starting at column 0

So your call to fetchAll would look something like $sth->fetchAll(PDO::FETCH_NUM)

edited Nov 17, 2023 at 20:33

CommunityBot

11 silver badge

answered Sep 1, 2014 at 19:33

user3942918

26.5k13 gold badges57 silver badges68 bronze badges

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

2 Comments

user1744974 Over a year ago

Thanks. Doesn't quite do it though. It comes out like this: Array ( [0] => Array ( [0] => 2 [1] => 38.44560000 [2] => -99.99999999 ) It's a bit neater, but not the same.

user1744974 Over a year ago

Think I was just a little confused by the output of print_r to debug in my browser. One way or another, it's now fixed. So thanks, your answer really helped.

Collectives™ on Stack Overflow

Getting array in different format from data fetched using SQL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related