如何使用foreach将多个字段放入表中

Question

How can I use the foreach loop to get the values for each field (brand_id & brand_name) and have them inserted into the table 'pa_list_brands'?

if I use this code:

  $query = db_insert('pa_list_brands')->fields(array('brand_id', 'brand_name'));
  foreach ($data as $record) {
    $query->values($record);
  }
  $query->execute();

I get the ERROR: "Catchable fatal error: Argument 1 passed to InsertQuery::values() must be an array, string given"

So I tried this code to see what was being returned with $record:

 $query = db_insert('pa_list_brands')->fields(array('brand_id', 'brand_name'));
  foreach ($data as $record) {
    print_r($record);
  }
  $query->execute();

And I get ARRAY RESULT:

11Array
(
    [0] => stdClass Object
        (
            [brand_id] => 1
            [brand_name] => Gildan
        )

    [1] => stdClass Object
        (
            [brand_id] => 2
            [brand_name] => American Apparel
        )

    [2] => stdClass Object
        (
            [brand_id] => 3
            [brand_name] => Rabbit Skins
        )

    [3] => stdClass Object
        (
            [brand_id] => 4
            [brand_name] => Anvil
        )
)

Thank you, Aaron

Answer 1

You should try this below code.Below codes assign data as an array to "values" function for $query object class.

$query = db_insert('pa_list_brands')->fields(array('brand_id','brand_name'));

foreach ($data as $key=>$record) {

   $values[] = $record->brand_id;
   $values[] = $record->brand_name;
   $query->values($values);
   $values=null;
}
$query->execute();

Let me know if anything.

If link provided in my comment doesn't helps then try this below code. You need to convert your object into array for "values" function to be work.

function objToArray($obj) {
    if(!is_array($obj) && !is_object($obj)) 
        return $obj;
    if(is_object($obj)) 
        $obj = get_object_vars($obj);
    return 
        array_map(__FUNCTION__, $obj);
}
$resultarr=objToArray($data);
if(is_array($resultarr))
  $resultarr=$resultarr[0];

 $query = db_insert('pa_list_brands')->fields(array('brand_id', 'brand_name'));
 foreach ($resultarr as $record) {
   $query->values($record);
 }
 $query->execute();