Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You could use HTML5's new geolocation. Example : <a href="http://html5demos.com/geo" rel="nofollow">http://html5demos.com/geo</a></p> <p>(taken from link above)</p> <p>Code:</p> <pre><code>&lt;script&gt; function success(position) { var s = document.querySelector('#status'); if (s.className == 'success') { // not sure why we're hitting this twice in FF, I think it's to do with a cached result coming back return; } s.innerHTML = "found you!"; s.className = 'success'; var mapcanvas = document.createElement('div'); mapcanvas.id = 'mapcanvas'; mapcanvas.style.height = '400px'; mapcanvas.style.width = '560px'; document.querySelector('article').appendChild(mapcanvas); var latlng = new google.maps.LatLng(position.coords.latitude, position.coords.longitude); var myOptions = { zoom: 15, center: latlng, mapTypeControl: false, navigationControlOptions: {style: google.maps.NavigationControlStyle.SMALL}, mapTypeId: google.maps.MapTypeId.ROADMAP }; var map = new google.maps.Map(document.getElementById("mapcanvas"), myOptions); var marker = new google.maps.Marker({ position: latlng, map: map, title:"You are here!" }); } function error(msg) { var s = document.querySelector('#status'); s.innerHTML = typeof msg == 'string' ? msg : "failed"; s.className = 'fail'; // console.log(arguments); } if (navigator.geolocation) { navigator.geolocation.getCurrentPosition(success, error); } else { error('not supported'); } &lt;/script&gt; </code></pre> <p>As for databases, I've been down that road, there isn't a perfect solution all the databases will only give you around 50 mile accuracy.</p> <p>With this you could use Ajax to push the location data to your server.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to determine remote computer location , given its IP (without paying)?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USPatrick Lorio
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO-This is nice example . But notice that it is only accurate for connections throw WIFI. I have lan in my house , and a Wifi. When i was connected by the lan , it spotted me 25 miles away , in other city. But , when i was connected to my Wifi it was super accurate. My explation is that google has been mapping around all the world Wifis and access points and according to your signal strengh it can determine where you are located. If you better explation enlighten me :)
      singulars
      1. PO
      1. USRanZilber
    2. COIt works by the browser. HTML is client side, basically the browser uses methods: "GPS, WLAN AP-based location, IP location". Here is more : http://stackoverflow.com/questions/2641948/how-html5-geolocation-feature-works I don't think you'll get any better accuracy then 25 miles away by using a database.
      singulars
      1. PO
      1. USPatrick Lorio
    3. COI know I wouldn't get that accurate. Thats why im looking for new ideas. The problem with this HTML-5 method is that it aint accurate either. I've been testing it with some examples with LAN and it was poor . And as i said before- using this tool with WLAN is super accurate, but I'm mainly intersted in LAN users.
      singulars
      1. PO
      1. USRanZilber
 

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