Ashish Singh imrealashu

## php speed up tips.html
<html>
<body>
<p>Here are Webber’s points:</p>
<ul>
<li>If a method can be static, declare it static. Speed improvement is by a factor of 4.</li>
<li>echo is faster than print.(<em>* compare with list from phplens by John Lim</em>)</li>
<li>Use echo’s multiple parameters instead of string concatenation.</li>
<li>Set the maxvalue for your for-loops before and not in the loop.</li>
<li>Unset your variables to free memory, especially large arrays.</li>
<li>Avoid magic like __get, __set, __autoload</li>

## laravel_scope_st_distance_sphere.php
<?php
public function scopeClosestTo($query, $latitude, $longitude, $radius)
{
    return $query
    ->whereRaw("
        ST_DISTANCE_SPHERE(
            POINT($latitude, $longitude),
            POINT(lat, lng)) < $radius
         ");
}

## sql_sp_distance_sphere.sql
SELECT *,
ST_DISTANCE_SPHERE(
    POINT(`table_name`.`lat`, `table_name`.`lng`),
    POINT('24.2449530', '85.4870880')) as `distance`
FROM `table_name
	<html>
	<body>
	<p>Here are Webber’s points:</p>
	<ul>
	<li>If a method can be static, declare it static. Speed improvement is by a factor of 4.</li>
	<li>echo is faster than print.(<em>* compare with list from phplens by John Lim</em>)</li>
	<li>Use echo’s multiple parameters instead of string concatenation.</li>
	<li>Set the maxvalue for your for-loops before and not in the loop.</li>
	<li>Unset your variables to free memory, especially large arrays.</li>
	<li>Avoid magic like __get, __set, __autoload</li>
	<?php
	public function scopeClosestTo($query, $latitude, $longitude, $radius)
	{
	return $query
	->whereRaw("
	ST_DISTANCE_SPHERE(
	POINT($latitude, $longitude),
	POINT(lat, lng)) < $radius
	");
	}
	SELECT *,
	ST_DISTANCE_SPHERE(
	POINT(`table_name`.`lat`, `table_name`.`lng`),
	POINT('24.2449530', '85.4870880')) as `distance`
	FROM `table_name