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:
| 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 |
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:
| SET | |
| @orig_latitude = 32.867073, | |
| @orig_longitude = -96.769410, | |
| @radius = 10 | |
| ; | |
| SELECT * | |
| FROM ( | |
| SELECT | |
| `geonameid`, `name`, |
| <?php | |
| declare(strict_types=1); | |
| namespace ApiPlatform\Workflow\PathResolver; | |
| use ApiPlatform\Core\PathResolver\OperationPathResolverInterface; | |
| final class OperationPathResolver implements OperationPathResolverInterface | |
| { |