delimiter $$
CREATE FUNCTION GetDistanceBetweenGeoLocations
(
lat1 float,
long1 float,
lat2 float,
long2 float
)
RETURNS float
DETERMINISTIC
BEGIN
DECLARE distance float;
DECLARE earth_radius float;
DECLARE axis float;
SET earth_radius = 6371.009;
SET axis = (SIN(RADIANS(lat2-lat1)/2) * SIN(RADIANS(lat2-lat1)/2) +
COS(RADIANS(lat1)) * COS(RADIANS(lat2)) *
SIN(RADIANS(long2-long1)/2) * SIN(RADIANS(long2-long1)/2));
SET distance = earth_radius * (2 * ATN2(SQRT(axis), SQRT(1-axis)));
RETURN ROUND(distance, 3);
END;
$$
select * from points
where GetDistanceBetweenGeoLocations(n, 55.75272901, e, 37.60548887) <= 0.1
$strings = [];
while ($res = mysql_fetch_assoc($req)) {
$strings[] = sprintf('{"id" : "%d", "sd" : "%s", "ds" : "%s"}', $res['id'], $res['sd'], $res['ds']);
};
echo implode(',', $strings) . ';';
server {
listen 80;
server_name point.local;
root /home/kulikov/www/point.local/httpdocs/;
try_files $uri /index.php?$args;
location ~ \.php$ {
fastcgi_pass unix:/var/run/php5-fpm.sock;
fastcgi_split_path_info ^(.+\.php)(/.*)$;
include fastcgi_params;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_param HTTPS off;
}
location ~* \.(jpg|jpeg|gif|png|ico|css|zip|tgz|gz|rar|bz2|doc|xls|exe|pdf|ppt|txt|tar|mid|midi|wav|bmp|rtf|js|swf|flv|avi|djvu|mp3|mp4|ogv|3gp)$ {
root /home/kulikov/www/point.local/httpdocs;
}
error_log /home/kulikov/www/point.local/logs/nginx_error.log;
access_log /home/kulikov/www/point.local/logs/nginx_access.log;
}
<?php
$a = require 'var_a.php';
$b = '2';
$c = '3';
<?php
return '1';
file_put_contents("var_a.php", "<?php return '4';");
$doc = new DomDocument('1.0', 'utf-8');
$doc->loadXML('<body>'.$txt.'</body>');
$xp = new DomXPath($doc);
foreach ($xp->query('//a') as $anode) {
echo $anode->nodeValue;
};
foreach ($xp->query('//span[@class="date"]') as $date_node) {
list($date, $time) = explode(' - ', $date_node->nodeValue);
};
$iterator = new RegexIterator(
new DirectoryIterator(
$dir2,
FilesystemIterator::KEY_AS_PATHNAME
| FilesystemIterator::CURRENT_AS_FILEINFO
| FilesystemIterator::SKIP_DOTS
),
'~[^a-d]~'
);
foreach ($iterator as $file_info) {
$filename = $file_info->getBasename();
};