Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options not deleted
user 12606
MySQL is an open-source, relational database management system. Place you question on MySQL Spatial Extensions here.
2
votes
How to know if a point is inside a rectangle on the map?
The bounding box query for SQL is(Using PDO)
$sql ="SELECT bussid FROM tablename WHERE(latitude BETWEEN ? AND ? )AND (longitude BETWEEN ? AND ?)";
$stmt = $dbh->prepare($sql);
// Assign parameters
…
- 156
2
votes
Accepted
Vincenty's formulae to calculate in MySQL and PHP
With points as close as these we can ignore what type of spheroid the earth is and use the eqirectangular projection Pythagoras formula is all that is required.
The following two functions are in PHP …
- 156