php - Multiple Address from a database in Google Maps API -

-

i have bunch of addresses in database , trying figure out how put multiple addresses in map. addresses dependent on user searches such city or number of bedrooms changes depending on search. far have manage have 1 address on map. way can combine 2 show addresses searched along points on map or modify code have?

here google maps api code

            var geocoder;             var map;             function initialize() {               geocoder = new google.maps.geocoder();               var latlng = new google.maps.latlng(49.2505, -123.1119);               var mapoptions = {                 zoom: 15,                 center: latlng,                 maptypeid: google.maps.maptypeid.roadmap               }               map = new google.maps.map(document.getelementbyid('map-canvas'), mapoptions);             }              function codeaddress() {               var address = '<?php echo json_encode($varstreetaddress);?> <?php echo json_encode($varcity);?>, bc';               geocoder.geocode( { 'address': address}, function(results, status) {                 if (status == google.maps.geocoderstatus.ok) {                   map.setcenter(results[0].geometry.location);                   var marker = new google.maps.marker({                       map: map,                       position: results[0].geometry.location                   });                 } else {                   alert('geocode not successful following reason: ' + status);                 }               });             }              google.maps.event.adddomlistener(window, 'load', initialize);

here code searching database

<?php     $mysqli = new mysqli("localhost","root","", "");         if ($mysqli->connect_errno) {             echo "failed connect mysql: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;         } ///////////set search variables $property = $_post['property']; $bedroom = $_post['bedroomnumber']; $bathroom = $_post['bathroomnumber']; $pricemin = $_post['pricemin']; $pricemax = $_post['pricemax']; $termlease = $_post['termlease']; //////////search if(isset($_post['utilities']) && is_array($_post['utilities'])) {     foreach($_post['utilities'] $check) {              //echoes value set in html form each checked checkbox.                          //so, if check 1, 3, , 5 echo value 1, value 3, value 5.                          //in case, echo whatever $row['report id'] equivalent to.     } }   $sql = $mysqli->query("select * propertyinfo property '%$property%' , numbed '%$bedroom%' , numbath '%$bathroom%' , price >= '$pricemin' , price <= '$pricemax' , utilities '%$check%' , termlease '%$termlease%'");   if($sql === false) {     die(mysql_error()); // todo: better error handling  }  if($sql->num_rows){     while ($row = $sql->fetch_array(mysqli_assoc)){         echo '<div id="listing">                     <div id="propertyimage">                          <img src="uploadimages/'.$row['imagename1'].'" width="200" height="150" alt=""/>                      </div>                      <div id="basicinfo">                     <h2>$'.$row['price'].'</h2>                     <p style="font-size: 18px;"># '.$row['streetaddress'].', '.$row['city'].', bc</p>                     <p>'.$row['numbed'].' bedrooms | '.$row['numbath'].' bathrooms | '.$row['property'].'</p>                     <br>                     <p><a href="output2.php?record_id='.$row['id'].'" class="link2" target="_blank">view full details</a> | <a href="" class="link2">get directions</a>                      </div>                 </div>';      } } else { echo '<h2>0 search results</h2>'; }?>

it nice see important part of html. dynamic page user add listings in database?

the problem found (in similiar project have) when use "and", seems user needs check boxes (or select options, etc). nothing can left alone, otherwise creates false search. results query, may not right result. have discovered people use jquery, collecting boxes - checked, , comparing database. user may check boxes, of time, boxes left unchecked, , means in category good, not none. instance, don't check 2 or 3 or 4 baths. means properties far bath concerned.


Comments

Post a Comment

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more

asp.net mvc - breakpoint on javascript in CSHTML? -

-
i have .cshtml file has javascript tag. within script tag have few lines of javascript. first line of javascript refers property in @viewbag. other javascript lines plain script without mvc related references. observation: can place breakpoints (visual studio 2015) on each of these javascript lines. however, breakpoints has white dot in center of breakpoint symbol (red circle) except line @viewbag reference (this particular line not have white dot in center). it seems breakpoint without white dot hit during run-time. question: can explain going on here? white dot mean? why plain red breakpoint line line hitting breakpoint? the visual studio debugger expecting debug actual server-side code within .cshtml file opposed client-side javascript within it. iirc, visual studio allow debug javascript code expected in internet explorer (and possibly edge), other browsers want use either third-party tool or developer tools (f12) within browser. an easy approach take advant...
Read more