PHP Pdo no column names in array

Question

I have the following query in PHP:

$stmt = $conn->prepare('SELECT 
        date, 
        avg(sells) as sells
FROM `table` WHERE product_id = :id group by date having count(id) > 1');
$stmt->execute(array('id' => $product));
$res = $stmt->fetchAll(PDO::FETCH_ASSOC);

As expected this returns me:

array(2) { 
    [0]=> array(2) { 
        ["date"]=> "2013-1-11" ["sells"]=> "73.5000" 
    } 
    [1]=> array(2) { 
        ["date"]=> "2013-1-11" ["sells"]=> "77.0000" 
    }
}

Anyway I can get the following output without looping with php?

array(2) { 
    [0]=> array(2) { 
        "2013-1-11",
        "73.5000" 
    } 
    [1]=> array(2) { 
        "2013-1-11",
        "77.0000" 
    }
}

I want to output the result as JSON directly. For that I need to drop the columns names — jribeiro
– jribeiro, Commented Jan 14, 2013 at 4:07
Why do you need to drop the column names for output to JSON? It makes it easier to work with to have column names even in JSON. — deceze
– deceze ♦, Commented Jan 14, 2013 at 4:08
@jribeiro That doesn't make much sense. What's wrong with JSON objects with named properties? — Phil
– Phil, Commented Jan 14, 2013 at 4:08

deceze · Accepted Answer · 2013-01-14 04:07:39Z

8

Instead of PDO::FETCH_ASSOC use PDO::FETCH_NUM.

answered Jan 14, 2013 at 4:07

deceze♦

525k89 gold badges806 silver badges954 bronze badges

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

Comments

Robert · Accepted Answer · 2013-01-14 04:09:33Z

1

Since you stated that you are wanting to use JSON, try something along the following:

$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($result);

This will give you a valid JSON structure based off of the data returned.

answered Jan 14, 2013 at 4:09

Robert

8,7672 gold badges29 silver badges34 bronze badges

2 Comments

jribeiro Over a year ago

Yeah but that will output the column names as well.

Robert Over a year ago

Correct, I'm not sure why you would not want to reference the string:value structure for your data.

Collectives™ on Stack Overflow

PHP Pdo no column names in 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