PHP code example of rebing0512 / geohashs
1. Go to this page and download the library: Download rebing0512/geohashs library. Choose the download type require. 2. Extract the ZIP file and open the index.php. 3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
rebing0512 / geohashs example snippets
use Rebing0512\Geohashs;
$length = 6;
$geohash = new Geohash();
$hash = substr($geohash->encode('latitude','longitude'), 0, $length);
$box = $geohash->neighbors($hash);
$box[] = $hash;
$in_str = "'".implode("','", $box)."'";
// PHP
// $sql = "SELECT FROM `table` WHERE LEFT(geohash, {$length}) IN ($in_str)";
// echo $sql;
// OUTPUT
// SELECT FROM `table` WHERE LEFT(geohash, 6) IN ('xxxxxx','aaaaaa', ......)