Radius Search Results function in php -

-

i have search function on site takes city state , zip , searches radius , displays results found have tested breaks @ line of coding:

if ($origin_id[0] != -1)         $sql .= " , " . $prefix . ".originlocationid in (" . implode(",", $origin_id) . ") ";

the globals defined , display correctly... if not put in radius display results city.. radius inputted breaks...

i have included radius function well...

function getlocationsearchcriteria(&$sql, &$urlappend, $prefix)     {         $origin_id = location::getlocationid($globals["originstate"], $globals["origincity"], $globals["originzip"]);          if (!is_array($origin_id))         {             $o = $origin_id;             $origin_id = array();             $origin_id[0] = $o;         }          if (!empty($globals["originradius"]))         {             $origin = new location($origin_id[0]); ----------->>>>>>   $origin_id = $origin->getradiuslocations($globals["originradius"]);             $urlappend .= "&originradius=" . $globals["originradius"];         }          // build query         if ($origin_id[0] != -1)             $sql .= " , " . $prefix . ".originlocationid in (" . implode(",", $origin_id) . ") ";     }      function getradiuslocations($radius)         {             $sql = "select locationid                      locations                      (pow((69.1*(longitude\"" . $this->longitude . "\")*" . cos($this->latitude/57.3) . "),\"2\")+pow((69.1*(latitude-\"" . $this->latitude . "\")),\"2\"))<(" . $radius * $radius . ") ";              $conn = &$globals["dbsettings"]->getconnection();             $rs = &$conn->execute($sql);             if ($rs === false)                 return -1;             $location_ids = array();             while (!$rs->eof)             {                 array_push($location_ids, $rs->fields[0]);                 $rs->movenext();             }             return $location_ids;         }

found solution... missing - after longitude in equation...

it should

(pow((69.1*(longitude-\"" . $this->longitude . "\")" . cos($this->latitude/57.3) . "),\"2\")+pow((69.1(latitude-\"" . $this->latitude . "\")),\"2\"))<(" . $radius * $radius . ") ";


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more