I'm trying to install Spatialite (4.3.0a) on Ubuntu (14.94.2 LTS) ..... I'd like to use it with PHP (5.5.9-1) ....
Following this post
https://faimsproject.atlassian.net/wiki/display/FAIMS/Installing+Spatialite+4+on+Ubuntu
(obviously using the updated versions of the packages involved....), I've now installed:
export "LD_LIBRARY_PATH=/usr/local/lib"It seems that SQLITE 3 and Spatialite are working fine ...
sqlite3 myDBSQLite version 3.9.2 2015-11-02 18:31:45Enter ".help" for usage hints.sqlite> SELECT load_extension('mod_spatialite');sqlite> SELECT sqlite_version();3.9.2sqlite> SELECT spatialite_version();4.3.0asqlite> SELECT proj4_version();Rel. 4.9.2, 08 September 2015sqlite> SELECT geos_version();3.5.0-CAPI-1.9.0 r4084sqlite> .quitBut if I try to execute this simple PHP file
Testing SpatiaLite on PHP testing SpatiaLite on PHP
Following this post
https://faimsproject.atlassian.net/wiki/display/FAIMS/Installing+Spatialite+4+on+Ubuntu
(obviously using the updated versions of the packages involved....), I've now installed:
- PHP 5.5.9-1
- SQLite 3.9.2
- Proj4 4.9.2
- Geos 3.5.0
- Freexl 1.0.2
- Spatialite 4.3.0a
export "LD_LIBRARY_PATH=/usr/local/lib"It seems that SQLITE 3 and Spatialite are working fine ...
sqlite3 myDBSQLite version 3.9.2 2015-11-02 18:31:45Enter ".help" for usage hints.sqlite> SELECT load_extension('mod_spatialite');sqlite> SELECT sqlite_version();3.9.2sqlite> SELECT spatialite_version();4.3.0asqlite> SELECT proj4_version();Rel. 4.9.2, 08 September 2015sqlite> SELECT geos_version();3.5.0-CAPI-1.9.0 r4084sqlite> .quitBut if I try to execute this simple PHP file
Testing SpatiaLite on PHP testing SpatiaLite on PHP