我有一個(gè)名為的表schools，我在那里有一個(gè)列l(wèi)at，long我將它定義為空，因?yàn)槲蚁Ｍ院笫褂霉雀璧乩砭幋a填充坐標(biāo)。現(xiàn)在我已經(jīng)為谷歌地理編碼設(shè)置了我的 api 并獲得了坐標(biāo)。我想使用 geocode api 和 querybuilder更新列l(wèi)at和我的數(shù)據(jù)庫(kù)。long我使用了 foreach 查詢，但是當(dāng)我這樣做時(shí)，dd它會(huì)打印最后一個(gè)數(shù)據(jù)。有人可以告訴我應(yīng)該如何更新它們嗎？謝謝。數(shù)據(jù)庫(kù)結(jié)構(gòu)+---------------------------------------------+---------------------------+-------------+-----+-----+| school_name | address | postal_code | lat | lng |+---------------------------------------------+---------------------------+-------------+-----+-----+| NGEE ANN SECONDARY SCHOOL | 1 TAMPINES STREET 32 | 529283 | | || SINGAPORE SPORTS SCHOOL | 1 CHAMPIONS WAY | 737913 | | || NUS HIGH SCHOOL OF MATHEMATICS AND SCIENCE | 20 CLEMENTI AVENUE 1 | 129957 | | || SCHOOL OF THE ARTS, SINGAPORE | 1 ZUBIR SAID DRIVE | 227968 | | || NORTHLIGHT SCHOOL | 151 TOWNER ROAD | 327830 | | || ASSUMPTION PATHWAY SCHOOL | 30 CASHEW ROAD | 679697 | | || SCHOOL OF SCIENCE AND TECHNOLOGY, SINGAPORE | 1 TECHNOLOGY DRIVE | 138572 | | || CREST SECONDARY SCHOOL | 561 JURONG EAST STREET 24 | 609561 | | || SPECTRA SECONDARY SCHOOL | 1 WOODLANDS DRIVE 64 | 737758 | | |+---------------------------------------------+---------------------------+-------------+-----+-----+響應(yīng)來自最后一個(gè)郵政數(shù)據(jù)737758
3 回答
搖曳的薔薇
TA貢獻(xiàn)1793條經(jīng)驗(yàn) 獲得超6個(gè)贊
dd()返回最后一個(gè)數(shù)據(jù)，因?yàn)槟诿總€(gè)循環(huán)中都將值設(shè)置為地址，所以最后一個(gè)地址返回最后一個(gè)值。
如果你想更新它，你可以這樣做：
foreach ($postals as $postal){
$address = $geocoder->getCoordinatesForAddress($postal->postal_code);
DB::table('schools')
->where('postal', $postal->postal_code)
->update(['lat' => $address['lat'], 'lng' => $address['lng']]);
}
holdtom
TA貢獻(xiàn)1805條經(jīng)驗(yàn) 獲得超10個(gè)贊
將變量聲明$address為數(shù)組并嘗試
foreach ($postals as $postal){
$address[] = $geocoder->getCoordinatesForAddress($postal->postal_code);
}
米脂
TA貢獻(xiàn)1836條經(jīng)驗(yàn) 獲得超3個(gè)贊
好吧，您知道您查詢的地址的郵政編碼，并且您有相應(yīng)的 lat/lng 值。
現(xiàn)在您必須從答案中提取值并構(gòu)建 UPDATE 查詢文本。對(duì)于顯示的答案是
UPDATE schoools
SET lat = 1.4364557 /* $address->lat */
, lng = 103.8043789 /* $address->lng */
WHERE postal_code = 737758; /* $postal->postal_code */
然后你必須執(zhí)行它。foreach ($postals as $postal)對(duì)每個(gè)郵政編碼在同一周期內(nèi)執(zhí)行此操作。
您還可以更新該address字段（或插入該字段formatted_address并更新它）。
- 3 回答
- 0 關(guān)注
- 174 瀏覽
添加回答
舉報(bào)
0/150
提交
取消