php循环使用相同的键的多个数组

问题描述：

How can I go about getting these results to insert into a database as one record for each key name? These 2 arrays will always have the same number of records and key names.

[size_chart_data] =Array (
    [Width] =Array (
        [Small] =18
        [Medium] =20
        [Large] =22
        [X-Large] =24
        [2X-Large] =26
        [3X-Large] =28
        [4X-Large] =30
        [5X-Large] =32
    )
    [Height] =Array (
        [Small] =28
        [Medium] =29
        [Large] =30
        [X-Large] =31
        [2X-Large] =32
        [3X-Large] =33
        [4X-Large] =34
        [5X-Large] =35
    )
)

I am using the following sql to insert into the database:

$chartData = db_insert('pa_size_chart_data')
    ->fields(array(
      'width',
      'height',
    ));

Thank you so much for your time. Please let me know if anything needs clarification. Aaron

答

This is the answer. Very special thank you to @u_mulder and @blackandorangecat for all of your helpful thoughts!!! In the question I only included width and height. But I felt it could be more helpful for others if I included a 3rd level. So the answer includes width, height, & sleeve.

  $size_chart_data = array();
  foreach ($size_chart_data['Width'] as $key => $value) {
      // floatval() is changing string results to float
      $value = floatval($value);

      if (!empty($size_chart_data['Height']) && !empty($size_chart_data['Sleeve'])) {
        // floatval() is changing string results to float
        $size_chart_data['Height'][$key] = floatval($size_chart_data['Height'][$key]);
        $size_chart_data['Sleeve'][$key] = floatval($size_chart_data['Sleeve'][$key]);
        $db_data = array(
            'width' => $value,                             // this is width 
            'height' => $size_chart_data['Height'][$key],  // this is height
            'sleeve' => $size_chart_data['Sleeve'][$key],  // this is the sleeve
        );
      } elseif (!empty($size_chart_data['Height'])) {
        $size_chart_data['Height'][$key] = floatval($size_chart_data['Height'][$key]);
        $db_data = array(
            'width' => $value,                             // this is width 
            'height' => $size_chart_data['Height'][$key],  // this is height
            'sleeve' => null,                              // this is the sleeve
        );  
      } elseif (!empty($size_chart_data['Width'])){
        $db_data = array(
            'width' => $value,  // this is width 
            'height' => null,   // this is height
            'sleeve' => null,   // this is the sleeve
        );
      }            
        $sizeArr = array($db_data);
        $chartData = db_insert('pa_size_chart_data')
          ->fields(array(
            'width',
            'height',
            'sleeve',
          ));
        foreach ($sizeArr as $sizeRec) {
          $chartData->values($sizeRec);
        }
        $chartData->execute();
   }

答

I suppose you should do this:

$size_chart_data = array();
foreach ($size_chart_data['Width'] as $key => $value) {
    $db_data = array();
    if (!empty($size_chart_data['Height'][$key])) {
        $db_data = array(
            'size_id' => $key,                             // this is size_id
            'width' => $value,                             // this is width 
            'height' => $size_chart_data['Height'][$key],  // this is height
        );
        // check what you've got
        print_r($db_data);
        // add $db_data to database, I suppose it's like
        $chartData = db_insert('pa_size_chart_data')
            ->fields($db_data);
    }
}

php循环使用相同的键的多个数组

相关推荐