Insert results from SQL query into php array

Question

I trying to insert SQL query results to PHP array:

$sql= $conn -> prepare("SELECT top(10) code, name, SUM(minutes)as total  FROM db_name group by code, name ORDER BY total desc");
$sql -> execute();

$combinedResults = array();
while ($row = $sql -> fetch(PDO::FETCH_ASSOC)) {
    $combinedResults[$row['code']][] = array( 
    'Name' => $row['name'],
    'Total' => $row['total']    );
};
echo($combinedResults['code'][0]['Total']);
?>

and script return Undefined index: code in echo row

result of print_r($combinedResults) and $row ?

demenvil
– demenvil

2014-12-08 11:01:17 +00:00
Commented Dec 8, 2014 at 11:01 — demenvil
– demenvil, Commented Dec 8, 2014 at 11:01

Pupil · Accepted Answer · 2014-12-08 11:03:11Z

1

Typo:

Change

$combinedResults[$row['code']][] = array(

to

$combinedResults['code'][$row['code']] = array(

answered Dec 8, 2014 at 11:03

Pupil

24k6 gold badges49 silver badges71 bronze badges

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

3 Comments

Daan Over a year ago

I don't think its a typo.

Klapsius Over a year ago

Working now but return only one column name: print_r($combinedResults['code'][0]'Total']); return 135 but print_r($combinedResults['code'][0]['Name']['Total']); return only one letter of record

ymas Over a year ago

@Klapsius When you are developing, please set display_errors to on and error_reporting to E_ALL (or -1). You will have noticed that the index does not exist. PHP will issue warnings and notices. It will also treat ['Total]` as [0] and only display the first character of $combinedResults['code'][0]['Name']. You need to do: print_r($combinedResults['code'][0]['Total']); to see the Total

airtwister · Accepted Answer · 2014-12-08 11:08:20Z

0

Here your "code" index must be value from the database. That's why there is no such index in associative array. Or, if you need "code" index, you need to rewrite like this (if I've understood correctly):

while ($row = $sql -> fetch(PDO::FETCH_ASSOC)) {
   $combinedResults['code'][] = array( 
   'Name' => $row['name'],
   'Total' => $row['total']    );
};

answered Dec 8, 2014 at 11:08

airtwister

362 bronze badges

Collectives™ on Stack Overflow

Insert results from SQL query into php array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related