poly_small.php

<?php
require_once 'common.php';

$docs = array();
$query =  trim($_GET['query']);
$function = $_GET['function'];
$geodesic = $_GET['geodesic'];
$indexes = 'geodemo';
$geodist = '';
$where = array();

if($function=='') {
    $function = 'geopoly2d';
}
if($geodesic =='') {
    $geodesic = 'false';
} 
if($query == '') {
    $query = 'stadium';
}
$poldeg = array();
$poldeg[] = array(40.95164274496,-76.88583678218);
$poldeg[] = array(41.188446201688,-73.203723511772);
$poldeg[] = array(39.900666261352, -74.171833538046);
$poldeg[] = array(40.059260979044, -76.301076056469);
foreach($poldeg as $c) {
    foreach($c as $p) {
        $polrad[] = $p;
    }
}
// we need to add the first point for gmaps to show the complete polygon
foreach($poldeg as $c) {
    $polstr[] .='['.$c[0].','.$c[1].']';
}
$polstr = '['.implode(',',$polstr).',['.$poldeg[0][0].','.$poldeg[0][1].']'.']';
$where[] = "MATCH('$query')";

$geodist = ', CONTAINS('.$function.'('.implode(',',$polrad).'),latitude_deg,longitude_deg) as distance ';
$where[] = ' distance =1';

$sql = "SELECT *".$geodist." FROM ".$indexes." WHERE ".implode(' AND ',$where)."  ".$order." LIMIT 0,100";

$results = $ln_sph->query($sql);
foreach($results as $r){
    $docs[] = $r;
}


$latitude = deg2rad(40.267874912251);
$longitude = deg2rad(-74.777925053894);
$maxdistance = 400000;

$meta = $ln_sph->query("SHOW META LIKE 'total_found'")->fetch();
$total_found = $meta['Value'];
$meta = $ln_sph->query("SHOW META LIKE 'time'")->fetch();
$total_time = $meta['Value'];

?>
<?php
$title = 'GEOPOLY2D/POLY2D on small polygon';
include 'template/header.php';
?>
<div id="map"></div>
<div class="container">

	<div class="row">
		<div class="span2">
			<div class="sitebar-nav offset1"></div>
		</div>
		<div class="">
			<div class="container">
				<ul class="nav nav-pills">
					<li><a href="index.php">Default Geo distance using havesine</a></li>
                    <li><a href="poly_large.php">Search inside large polygon</a></li>
                    <li  class="active"><a href="poly_small.php">Search inside small polygon</a></li>
                    <li><a href="polar.php">Geo distance with Polar flat-Earth</a></li>
                    <li><a href="newgeodist.php">New GEODIST() options (2.2+)</a></li>
				</ul>
				<header>
					<h1>GEOPOLY2D/POLY2D on small polygon</h1>
				</header>
				<div class="row">
					<div class="span9">

						<div class="well form-search">
							<form method="GET" action="" id="search_form"
								class="form-horizontal">
								<div class="control-group">
									<label class="control-label" for="query">Text Search</label>
									<div class="controls">
										<input type="text" class="input-large" name="query" id="query"
											autocomplete="off"
											value="<?=isset($_GET['query'])?htmlentities($_GET['query']):'stadium'?>">
									</div>
								</div>

								<div class="control-group">
									<label class="control-label" for="function">Poly function</label>
									<div class="controls">
										<select name="function" id="function">
											<?php 
											$options = array('geopoly2d' => 'geopoly2d',
                                                             'poly2d' => 'poly2d'
										                    );
              
										?>
											<?php foreach($options as $value=>$option):?>
											<option value="<?=$value?>"
											<?=($value==$function)?'selected="selected"':'';?>>
												<?=$option?>
											</option>
											<?php endforeach;?>
										</select>

									</div>
								</div>
								<div class="control-group">
									<label class="control-label" for="geodesic">geodesic on gmaps</label>
									<div class="controls">
						            <select name="geodesic" id="geodesic">
											<?php 
											$options = array('true' => 'true',
                                                             'false' => 'false'
										                    );
              
										?>
											<?php foreach($options as $value=>$option):?>
											<option value="<?=$value?>"
											<?=($value==$geodesic)?'selected="selected"':'';?>>
												<?=$option?>
											</option>
											<?php endforeach;?>
										</select>
									
									</div>
								</div>
								<div class="control-group">
									<div class="controls">
										<input type="submit" class="btn btn-primary" id="send"
											name="send" value="Submit">
										<button type="reset" class="btn " value="Reset">Reset</button>
									</div>
								</div>

							</form>
						</div>
					</div>
				</div>

				<div class="row">
					<?php if(isset($sql)):?>
					<div class="alert alert-success">
						<?=$sql?>
					<hr>
						Query time: <?=$total_time?>; Total found: <?=$total_found?>
					</div>
					<?php endif;?>

				</div>

				<?php 
				include 'template/footer_poly.php';
				?>