Databases
StackOverflow2013
Postsdbo
POgoogle map refresh after submit form
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POgoogle map refresh after submit form
    primarykey
    data
    text
    <p>i want to make my map re-initialize after submit a form. my form has a drop down menu, the drop down is use to choose a region that will be shown in map. i want to when form is submit, the page is still in there, but the map refresh and shown the mark. sorry for my bad english. there is the code : </p> <pre><code>&lt;script type="text/javascript"&gt; function initialize(){ var peta; var gambar_tanda; gambar_tanda = 'assets/images/enseval.jpg'; var x = new Array(); var y = new Array(); var customer_name = new Array(); // posisi default peta saat diload var lokasibaru = new google.maps.LatLng(-6,107); var petaoption = { zoom: 6, center: lokasibaru, mapTypeId: google.maps.MapTypeId.ROADMAP }; peta = new google.maps.Map(document.getElementById("map_canvas"),petaoption); var infowindow = new google.maps.InfoWindow({ content: '&lt;div class=new&gt;""&lt;/div&gt;' }); // memanggil function ambilpeta() untuk menampilkan koordinat url = "json.php"; $.ajax({ url: url, dataType: 'json', cache: false, success: function(msg){ for(i=0;i&lt;msg.enseval.customer.length;i++){ x[i] = msg.enseval.customer[i].x; y[i] = msg.enseval.customer[i].y; customer_name[i] = msg.enseval.customer[i].nama_customer; var point = new google.maps.LatLng(parseFloat(msg.enseval.customer[i].x),parseFloat(msg.enseval.customer[i].y)); tanda = new google.maps.Marker({ position: point, map: peta, icon: gambar_tanda, clickable: true }); bindInfoWindow(tanda, peta, infowindow, msg.enseval.customer[i].nama_customer); } } }); } google.maps.event.addDomListener(window, 'load', initialize); function bindInfoWindow(tanda, peta, infowindow, data) { google.maps.event.addListener(tanda, 'click', function() { infowindow.setContent(data); infowindow.open(peta, tanda); }); } function reload(form){ var val=form.org_id.options[form.org_id.options.selectedIndex].value; self.location='index.php?cabang=' + val ; } &lt;/script&gt; &lt;/head&gt; &lt;body&gt; &lt;div id="map_canvas" style=" align: left; width:1000px; height:500px"&gt;&lt;/div&gt; &lt;?php require ('config.php'); @$cabang=$_GET['cabang']; /*if(strlen($cabang) &gt; 0 and !is_numeric($cabang)){ echo "Data Error"; exit; }*/ $quer2=pg_query("SELECT DISTINCT org_id FROM gis order by org_id"); if(isset($cabang) and strlen($cabang)){ $quer=pg_query("SELECT DISTINCT cp_rayon_name FROM gis where org_id=$cabang order by cp_rayon_name"); } //else{$quer=pg_query("SELECT DISTINCT cp_rayon_name FROM gis order by cp_rayon_name"); } echo "&lt;form method=post name=f1 action='' onSubmit='\"initialize()\'&gt;"; echo "&lt;select name='org_id' onchange=\"reload(this.form)\"&gt;&lt;option value=''&gt;Select one&lt;/option&gt;"; while($noticia2 = pg_fetch_array($quer2)) { if($noticia2['org_id']==@$cabang){echo "&lt;option selected value='$noticia2[org_id]'&gt;$noticia2[org_id]&lt;/option&gt;"."&lt;BR&gt;";} else{echo "&lt;option value='$noticia2[org_id]'&gt;$noticia2[org_id]&lt;/option&gt;";} } echo "&lt;/select&gt;"; echo "&lt;select name='rayon'&gt;&lt;option value=''&gt;Select one&lt;/option&gt;"; while($noticia = pg_fetch_array($quer)) { echo "&lt;option value='$noticia[cp_rayon_name]'&gt;$noticia[cp_rayon_name]&lt;/option&gt;"; } echo "&lt;/select&gt;"; echo "&lt;input type=submit value=Submit&gt;"; echo "&lt;/form&gt;"; include ('json.php'); ?&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <hr> <pre><code> &lt;?php require ('config.php'); $rayon = $_POST['rayon']; $cabang = $_POST['org_id']; //echo "$rayon, $cabang"; $sql = "SELECT distinct org_id, customer_name, attribute16, attribute17 FROM gis where cp_rayon_name = '$RAYON'"; $data = pg_query($sql); $json = '{"enseval": {'; $json .= '"customer":[ '; while($x = pg_fetch_array($data)){ $json .= '{'; $json .= '"id_customer":"'.$x['org_id'].'", "nama_customer":"'.htmlspecialchars($x['customer_name']).'", "x":"'.$x['attribute17'].'", "y":"'.$x['attribute16'].'" },'; } $json = substr($json,0,strlen($json)-1); $json .= ']'; $json .= '}}'; //echo $json; ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKrichevskoy
    1. USKrichevskoy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POgoogle map refresh after submit form
      1. USKrichevskoy
      1. VTFavorite
    2. VO
      singulars
      1. POgoogle map refresh after submit form
      1. This table or related slice is empty.
      1. VTUpMod
    1. COdo you need panTo(latLng:LatLng) from [Google Maps API](https://developers.google.com/maps/documentation/javascript/3.exp/reference?hl=en#Map)?
      singulars
      1. POgoogle map refresh after submit form
      1. USvladkras
    2. COwhat do you mean? sorry i'am still newbie. first code is using to select latlong that will be show in the map, the process is doing in second code, but how make the map shown the marker after the process? i miss that thing.
      singulars
      1. POgoogle map refresh after submit form
      1. USKrichevskoy
    3. COplease, paste your html code with this select here
      singulars
      1. POgoogle map refresh after submit form
      1. USvladkras
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload