phpfacile / geocoding-db-zend
Service mainly aimed at storing in database (using zend-db) a location retrieved thanks to phpfacile/geocoding
1.0.4
2018-11-22 18:14 UTC
Requires
- php: >=7.0.0
- crazycodr/standard-exceptions: ^2.3
- phpfacile/openstreetmap: ^1.0.1
- zendframework/zend-db: ^2.5
Requires (Dev)
- phpunit/phpunit: ^6.2
- squizlabs/php_codesniffer: 3.*
README
This service store in database (using zend-db) a location retrieved using phpfacile/geocoding (Cf. https://github.com/phpfacile/geocoding).
Installation
At the root of your project type
composer require phpfacile/geocoding-db-zend
Or add "phpfacile/geocoding-db-zend": "^1.0" to the "require" part of your composer.json file
"require": {
"phpfacile/geocoding-db-zend": "^1.0"
}
Usage
Step 1 : Adapter instanciation
Instanciate a Zend Adapter to allow a connexion to a database.
Example with SQLite (for test purpose only)
$config = [ 'driver' => 'Pdo_Sqlite', 'database' => 'my_database.sqlite', ]; $adapter = new Zend\Db\Adapter\Adapter($config);
Example with MySQL
$config = [ 'driver' => 'Pdo_Mysql', 'host' => 'localhost' 'dbname' => 'my_database', 'user' => 'my_username', 'password' => 'my_password', ]; $adapter = new Zend\Db\Adapter\Adapter($config);
Step 2 : LocationService instanciation
use PHPFacile\Geocoding\Db\Service\LocationService; $locationService = new LocationService($adapter);
Step 3 : Store a location and/or get it's id if already in database
Assuming you've got a $location StdClass retrieved from a previous phpfacile/geocoding query:
$id = $locationService->getIdOfStdClassLocationAfterInsertIfNeeded($location)