Looping through results of a sql query

Question

I have a query that returns multiple rows. I can't seem to find a way to store the rows in the $params array. Is there a way to loop throw and store each row in the $params variable

$aResult = $db->exec_sql($sql);  
$params = array(
  // where $aResult[o]'' would be row 1 [1] row 2 etc. //
  'store_id' => $aResult[]['iStoreID'],
  'user_id' => $aResult[]['iUserID'],
  'store_name' => $aResult[]['cStoreName'],
  'store_url' => $aResult[]['cStoreURL'],
  'rid' => $aResult[]['cRID'],
  'affiliate_id' => $aResult[]['iAffiliateID'],
  'team_id' => $aResult[]['iTeamID'],
  'bizOP' => $aResult[]['cDefaultBizOpp'],
  'showBizOPp' => $aResult[]['iShowBizOppDropdown'],
  'boPosting' => $aResult[]['iEnableBOPosting'],
  'brandinglevel' => $aResult[]['iBrandingLevel']
);

thank you for your help

40=[Array containing 4 elements] 0=[Array containing 14 elements] iInvoice="" yAmt="" cNameF="" cNameL="" cEmail="" ... That is the dump of what the sql is doing . . . obvoiusly there are more columns and data has been removed but i think it has what is necessary. Thank you — user2101459
– user2101459, Commented Jun 14, 2013 at 21:51
To make it easier for people to read you can use the Edit and update it with the dump. — Prix
– Prix, Commented Jun 14, 2013 at 23:13

dev-null-dweller · Accepted Answer · 2013-06-14 21:45:30Z

2

As simple as that:

$params = array();
foreach($aResult as $row) {
    $params[] = array(
        'store_id' => $row['iStoreID'],
        'user_id' => $row['iUserID'],
        'store_name' => $row['cStoreName'],
        'store_url' => $row['cStoreURL'],
        'rid' => $row['cRID'],
        'affiliate_id' => $row['iAffiliateID'],
        'team_id' => $row['iTeamID'],
        'bizOP' => $row['cDefaultBizOpp'],
        'showBizOPp' => $row['iShowBizOppDropdown'],
        'boPosting' => $row['iEnableBOPosting'],
        'brandinglevel' => $row['iBrandingLevel']
    );
}

answered Jun 14, 2013 at 21:45

dev-null-dweller

29.5k3 gold badges68 silver badges87 bronze badges

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

Comments

regexp · Accepted Answer · 2013-06-14 21:43:36Z

0

Without knowing the exact structure of the result array i guess you need something like this:

<?php

$params  = array();
$mapping = array(
    'store_id' => 'iStoredID',
    'user_id'  => 'iUserID',
// and so on...
);

foreach ($aResult as $row) {
   $tempRow = array();
   foreach ($row as $key => $value) {
       $paramKey           = isset($mapping[$key]) ? $mapping[$key] : $key;
       $tempRow[$paramKey] = $value;
   }
   $params[] = $tempRow;
}

answered Jun 14, 2013 at 21:43

regexp

7664 silver badges15 bronze badges

Comments

kilkadg · Accepted Answer · 2013-06-14 21:37:20Z

-1

I use it like this

$aResult = mysql_query($sql);

while($data = mysql_fetch_array($result)) {
     'store_id' = $aResult['iStoreID'];
}

At least that is the idea

answered Jun 14, 2013 at 21:37

kilkadg

2,4075 gold badges19 silver badges21 bronze badges

1 Comment

Lepidosteus Over a year ago

Stop using mysql_* functions. This extension is deprecated, and will be soon removed from php. Use mysqli instead or pdo.

Collectives™ on Stack Overflow

Looping through results of a sql query

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related