This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| declare(strict_types=1); | |
| namespace ApiPlatform\Workflow\PathResolver; | |
| use ApiPlatform\Core\PathResolver\OperationPathResolverInterface; | |
| final class OperationPathResolver implements OperationPathResolverInterface | |
| { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SET | |
| @orig_latitude = 32.867073, | |
| @orig_longitude = -96.769410, | |
| @radius = 10 | |
| ; | |
| SELECT * | |
| FROM ( | |
| SELECT | |
| `geonameid`, `name`, |
To be able to use PHP5 PDO with MS Access mdb files the following is required
(the same applies for the PHP4 style of using odbc_X except for the
obviously PDO specific requirements):
In Linux this is achieved by intalling the php5-odbc package:
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE FUNCTION `lat_lng_distance` (lat1 FLOAT, lng1 FLOAT, lat2 FLOAT, lng2 FLOAT) | |
| RETURNS FLOAT | |
| DETERMINISTIC | |
| BEGIN | |
| RETURN 6371 * 2 * ASIN(SQRT( | |
| POWER(SIN((lat1 - abs(lat2)) * pi()/180 / 2), | |
| 2) + COS(lat1 * pi()/180 ) * COS(abs(lat2) * | |
| pi()/180) * POWER(SIN((lng1 - lng2) * | |
| pi()/180 / 2), 2) )); | |
| END |