我有這個(gè)錯(cuò)誤:致命錯(cuò)誤:未捕獲的錯(cuò)誤:在第 15 行拋出的距離()#1 {main} 中的布爾值調(diào)用成員函數(shù) fetch()我需要計(jì)算的是表中所有位置之間的距離,每個(gè)位置都是唯一的lat,并且long我定義了一個(gè)位置并對(duì)其進(jìn)行排序 DESC 并獲取照片和標(biāo)題:id | Country | photo | p_latitude | p_longtitude1 japan 1.jpg 32.125 35.1232 Chian 2.jpg 56.125 50.1233 USA 3.jpg 42.125 90.123 function distance() { global $con; $lat1= 36.2048; $lang1= 138.2529; $query = 'SELECT *, CASE WHEN '. $lat1 .' = `p_latitude` && '. $lang1 .' = `p_longtitude` THEN 0 ELSE DEGREES(ACOS(SIN(RADIANS(`p_latitude`)) * SIN(RADIANS('. $lat1 .')) +COS(RADIANS(`lat`)) * COS(RADIANS('. $lat1 .')) * COS(RADIANS(`p_longtitude`-'. $lang1 .'))))* 69.09 END as distance FROM `posts` ORDER BY distance desc'; $resd = $con->query($query); while($row_ratessada= $resd->fetch()){ $post_rate= $row_ratessada['post_title']; echo "this is the title"." ".$post_rate; } }
使用計(jì)算進(jìn)行查詢排序
BIG陽(yáng)
2022-07-16 16:01:41