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

This package is auto-updated.

Last update: 2024-03-23 06:41:42 UTC


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)