質問編集履歴
3
誤記
test
CHANGED
File without changes
|
test
CHANGED
@@ -70,9 +70,9 @@
|
|
70
70
|
|
71
71
|
```
|
72
72
|
|
73
|
-
$areainfo_lat = "35.6
|
73
|
+
$areainfo_lat = "35.6746700";
|
74
74
|
|
75
|
-
$areainfo_lnt = "139.7
|
75
|
+
$areainfo_lnt = "139.7885380";
|
76
76
|
|
77
77
|
$result = $wpdb->get_results("
|
78
78
|
|
@@ -128,4 +128,4 @@
|
|
128
128
|
|
129
129
|
上記の出力結果はこんな感じです。
|
130
130
|
|
131
|
-
|
131
|
+
Array ( [0] => stdClass Object ( [post_title] => ソフィアタワー勝どき [id] => 562 [_lat] => 35.6584463 [_lnt] => 139.7735894 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき3丁目12-12";s:3:"lat";s:10:"35.6584463";s:3:"lng";s:11:"139.7735894";} [distance] => 2.2534462617295463 ) [1] => stdClass Object ( [post_title] => クレストレジデンス [id] => 561 [_lat] => 35.6571881 [_lnt] => 139.7719590 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき5丁目5-14 ";s:3:"lat";s:10:"35.6571881";s:3:"lng";s:18:"139.77195900000004";} [distance] => 2.453954933727737 ) )
|
2
追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -66,7 +66,7 @@
|
|
66
66
|
|
67
67
|
|
68
68
|
|
69
|
-
###試したSQL文:追記版
|
69
|
+
###試したSQL文:追記版
|
70
70
|
|
71
71
|
```
|
72
72
|
|
@@ -125,3 +125,7 @@
|
|
125
125
|
");
|
126
126
|
|
127
127
|
```
|
128
|
+
|
129
|
+
上記の出力結果はこんな感じです。
|
130
|
+
|
131
|
+
35.6746700139.7885380Array ( [0] => stdClass Object ( [post_title] => ソフィアタワー勝どき [id] => 562 [_lat] => 35.6584463 [_lnt] => 139.7735894 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき3丁目12-12";s:3:"lat";s:10:"35.6584463";s:3:"lng";s:11:"139.7735894";} [distance] => 2.2534462617295463 ) [1] => stdClass Object ( [post_title] => クレストレジデンス [id] => 561 [_lat] => 35.6571881 [_lnt] => 139.7719590 [googlemap] => a:3:{s:7:"address";s:41:"東京都中央区勝どき5丁目5-14 ";s:3:"lat";s:10:"35.6571881";s:3:"lng";s:18:"139.77195900000004";} [distance] => 2.453954933727737 ) )
|
1
変更
test
CHANGED
File without changes
|
test
CHANGED
@@ -66,7 +66,7 @@
|
|
66
66
|
|
67
67
|
|
68
68
|
|
69
|
-
###試したSQL文
|
69
|
+
###試したSQL文:追記版()
|
70
70
|
|
71
71
|
```
|
72
72
|
|
@@ -82,13 +82,13 @@
|
|
82
82
|
|
83
83
|
COS(RADIANS($areainfo_lat))
|
84
84
|
|
85
|
-
* COS(RADIANS(_l
|
85
|
+
* COS(RADIANS(m1.meta_value))
|
86
86
|
|
87
|
-
* COS(RADIANS(_l
|
87
|
+
* COS(RADIANS(m2.meta_value) - RADIANS($areainfo_lnt))
|
88
88
|
|
89
89
|
+ SIN(RADIANS($areainfo_lat))
|
90
90
|
|
91
|
-
* SIN(RADIANS(_l
|
91
|
+
* SIN(RADIANS(m1.meta_value))
|
92
92
|
|
93
93
|
)) AS distance
|
94
94
|
|
@@ -116,7 +116,7 @@
|
|
116
116
|
|
117
117
|
AND m3.meta_key = 'googlemap'
|
118
118
|
|
119
|
-
HAVING distance
|
119
|
+
HAVING distance
|
120
120
|
|
121
121
|
ORDER BY distance
|
122
122
|
|