我試圖列出然后從這個數組插入到 SQL 表中：SQL表：id time average_position search_visibility_index click_potential 數據是：Array( [name] => average_position [series] => Array ( [0] => Array ( [0] => 2020-03-18 [1] => 36.27 ) [1] => Array ( [0] => 2020-03-19 [1] => 36.23 ) [2] => Array ( [0] => 2020-03-20 [1] => 36.18 ) [3] => Array ( [0] => 2020-03-21 [1] => 36.07 ) [4] => Array ( [0] => 2020-03-22 [1] => 36.53 ) [5] => Array ( [0] => 2020-03-23 [1] => 36.65 ) [6] => Array ( [0] => 2020-03-24 [1] => 36.21 ) 問題是如何使用單個 mysql 查詢保存這些數據，因為有多個數組。但所有這些都是基于固定日期時間查詢。foreach($contents_series as $avg_array){DB::table('data_series')->insert( ['time' =>$avg_array[0],'average_position' =>$avg_array[0]['url_series'][0]['series'][1]]);
1 回答
MMMHUHU
TA貢獻1834條經驗 獲得超8個贊
您需要將數組轉換為示例中的格式。如果日期存在并且所有數組都相同，則任務非常簡單 - 日期的每個條目必須包含三個條目 - 'average_position'、'search_visibility_index' 和 'click_potential' 以及相應的值。
這意味著您必須遍歷每個數組，從元素 #0 中獲取日期，將其用作鍵，并在元素 1 下添加相應的數組鍵及其值。
<?php
$yourFirstArray = ['name' => 'average_position', 'series' => [['2020-03-18', 36.27], ['2020-03-19', 36.23]];
$yourSecondArray = ['name' => 'search_visibility_index', 'series' => [['2020-03-18', 5.14], ['2020-03-19', 5.14]];
$yourThirdArray = ['name' => 'click_potential', 'series' => [['2020-03-18', 70.73], ['2020-03-19', 70.74]];
$average_position_series = $yourFirstArray['series'];
$search_visibility_index_series = $yourSecondArray['series'];
$click_potential_series = $yourThirdArray['series'];
$data = [];
foreach($average_position_series as list($date, $value)) {
$data[$date]['average_position'] = $value;
}
foreach($search_visibility_index_series as list($date, $value)) {
$data[$date]['search_visibility_index'] = $value;
}
foreach($click_potential_series as list($date, $value)) {
$data[$date]['click_potential'] = $value;
}
DB::table('mytable')->insert($data);
- 1 回答
- 0 關注
- 74 瀏覽
添加回答
舉報
0/150
提交
取消