質問編集履歴

改修コードの貼り付け

2018/03/16 02:42

投稿

ShujiYamagami

スコア7

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -153,3 +153,99 @@
 ご教示お願いできますでしょうか。
 よろしくお願い致します。
+【追記】
+変更後コード
+```php
+$select_sql = 'select cate01.parent_category_ids as cate1, cate02.parent_category_ids as cate2, t_salon.salon_cate02, t_salon.id, t_salon.salon_name, t_salon.salon_address, t_salon.salon_tel, t_salon.salon_latitude, t_salon.salon_longitude,
+(6371 * ACOS(
+  COS(RADIANS(:lat))
+  * COS(RADIANS(salon_latitude))
+  * COS(RADIANS(`salon_longitude`) - RADIANS(:lng))
+  + SIN(RADIANS(:lat))
+  * SIN(RADIANS(salon_latitude))
+)) AS distance
+from t_salon
+left join t_parent_category as cate01 on t_salon.salon_cate01 = cate01.id
+left join t_parent_category as cate02 on t_salon.salon_cate02 = cate02.id
+where cate01.parent_category_face = :treatment_id
+having
+  distance <= :radius_val
+order by
+  distance';
+  try {
+    $data = $pdo->prepare($select_sql);
+    # bind処理
+    $data->bindParam(':lat', $lat, PDO::PARAM_DECIMAL);
+    $data->bindParam(':lng', $long, PDO::PARAM_DECIMAL);
+    $data->bindParam(':treatment_id', $treatment_id, PDO::PARAM_STR);
+    $data->bindParam(':radius_val', $radius_val, PDO::PARAM_STR);
+    $data->execute();
+    if(!$data) {
+      echo "\nPDO::errorInfo():\n";
+      print_r($pdo->errorInfo());
+      exit;
+      return false;
+    }
+    $array = [];
+    while($row = $data -> fetch(PDO::FETCH_ASSOC)) {
+      $array[] = $row;
+    }
+    return $array;
+  } catch (PDOException $e) {
+    exit('データベースエラー : '.$e->getMessage());
+  }
+```