dongzhan7909
2016-07-02 15:15
浏览 33
已采纳

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

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • drcomwc134525 2016-07-04 14:23
    已采纳

    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();
       }
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报
  • douke3007 2016-07-02 15:27

    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);
        }
    }
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题