Questions tagged [php]
PHP is a Server-Side Scripting language designed initially for web programming, but is also used as a general-purpose programming language.
308
questions
0
votes
0answers
36 views
Using PHP on Webservers and PostgreSQL
I'm creating a general webapp that is displaying data from a Postgres database hosted on Digital Ocean.
My problem is that I can't get the PHP script to run on my webserver(hosted by Hostgator) to ...
0
votes
1answer
42 views
Use PHP form to insert geometry from WKT into SQL Server 2017
I have a PHP 7.3 form that asks the user for a Name, a WKT and an SRID. I would like to upload the WKT and SRID to SQL Server 2017 so that it creates a geometric object in Upload_WKT_Test using ...
1
vote
1answer
48 views
Openlayers: Using PHP and npm
I've got a rather large MySQL database containing polygons (coordinates) and their additional properties (e. g. text labels in different languages). I would like to use PHP to connect to my database ...
1
vote
1answer
35 views
On change filter Leaflet
I want to make dynamic filter on Leaflet, but I got a little problem.
so first this my dropdown:
<select id="selc">
<option value="baik">baik</option>
<option value="sedang">...
1
vote
0answers
27 views
Count points that are within certain radius within a polygon
I have 4 table, I want to count police that are within 5km of a point (dam), schools and clinics within 3km same dam. So far I do get the results if I'm focusing on one table
$str = pg_query($conn, "...
1
vote
0answers
51 views
Problem with loading big data (GeoJSON) via PHP
I have a problem with loading (big) data via PHP from a spatial database. I let run this project on a localhost Apache Server.
From a data count of about 30.000 edges I get an error
VM885:1 Uncaught ...
1
vote
0answers
34 views
Display all trajectories location along with dummy location
I'm trying to display the all trajectory location on Google map along with dummy location. I have tried to display dummy locations with sample location and it works fine, but when I try to connect to ...
1
vote
1answer
141 views
Leaflet Foreach point in GeoJSON check Distanceto
So I was wondering how I can get the points from the
GeoJSON located here.
and then for each of them separately check if the distance of Markers is within 5 meters range of these. I have tried but ...
0
votes
0answers
37 views
ArcGIS map with basemap toggle and simplemarker pointer
I am using ArcGIS map which gives me an error:
Below is my function which i am using to implementing the map on my
application:
function handlerForVariableB (latt, longt, complaintid)
{
// ...
2
votes
1answer
150 views
Show points (layer) from PostgreSQL database on OpenLayers map
I have this code, I want to load a collection of points stored in a table in PostgreSQL database, I retreive the GeoJSON format succesfully, but the points never show up on the map!
The three files ...
0
votes
0answers
52 views
How to setup my Tileserver-php
I have downloaded "xampp-windows-x64-7.3.6-3-VC15-installer.exe" and installed only Apache and PHP. My Apache server is running.
I have download "tileserver-php-master" and paste the folder in path ...
1
vote
1answer
215 views
ArcGIS Feature layer data update using API in PHP
I'm facing an issue with update data on the ArcGIS feature layer using API in PHP. Data is updating on the feature layer as expected, But data on the map is not representing. Every time when I'm ...
0
votes
0answers
135 views
MySQL Query for Getting Records within Radius
Coordinates in the table are stored in 3 separate columns x, y and zone and are formatted in UTM.
Here is the idea: I get the current position of the user (in lat long but I can convert it to UTM if ...
0
votes
0answers
49 views
Generating random locations nearby my location in PHP and MySQL
I'm using a method to generate a random locations around my location with given the initial position(lat,long) and radius this method is used From the reference post here, but unfortunately the ...
0
votes
0answers
82 views
Submit form in leaflet popup makes blank page
I have a problem with a leaflet popup. I made a form in it and when I try to send form with jquery & AJAX to postgis, data inserts correctly but blank page loads. How to update popup with response ...
1
vote
2answers
106 views
MySQL, geoPHP, select sites near the current site
I'm working with archaeological sites, stored as polygons in a MariaDB 10.3 table, and I have PHP 7.2 with GEOS and geoPHP available. I'm creating a page that displays all the related information for ...
0
votes
0answers
72 views
Creating GeoServer layers from GeoJSON generated by PHP script
I have few layers on my map rendered with ol.format.GeoJSON. I generated GeoJSON from pgsql database with PHP scripts. The size of layers ranges from 1MB to 5MB so to speed up the process I want to ...
1
vote
1answer
59 views
phpmapscript on Debian Stretch
I installed MapServer 7 and I need phpmapscript.
Is there any binary package for phpmapscript for Debian Stretch? I could install PHP 5.6 from binaries (https://stackoverflow.com/questions/46378017/...
0
votes
0answers
315 views
How to save marker and polyline in database?
I want to store marker and polyline in the database. In this script, I have 3 functions, that is to draw a polyline, marker and the point of destination.
Can anyone fix my script below?
var map;
var ...
0
votes
0answers
306 views
Query and display MySQL DB data from HTML
I want to link MySQL DB to the HTML and get the data according to the query below.
SELECT * FROM feature1 WHERE place = 'feature2'
php seems one of the way to do this, since I am one day old with ...
0
votes
0answers
31 views
Remove tolerance in PostGIS requests
I just read the problems similar to mine on this forum, but no solution helped me.
To put it simply, I use ST_Touches in an algo in PHP that allows me to test if two points touch.
Here is the query:
...
2
votes
1answer
47 views
Get values from shapeObj MapScript
I'm using Mapserver 7.4.0-dev and MapScript PHP.
In previous versions of MapServer and MapScript (https://mapserver.org/mapscript/php/index-5.6.html#shapeobj), I could query a shapeObj after its ...
1
vote
0answers
261 views
GeoServer returns 401 unauthorized when requesting data via openlayers
When using the line crossOrigin: 'anonymous',, it returns 401 unauthorized response.
When commenting out that line it works, but I have to be log in to the GeoServer.
Update:
I have changed the ...
0
votes
0answers
127 views
Converting NZTM2000 projection to Lat-Long system using PHP
Is there a way to convert coordinates from New Zealand Transverse Mercator to Google compatible longitude and latitude using PHP? I have tried PHP-COORD library, but it does not have the NZTM option.
0
votes
0answers
45 views
How do I load geojson using php into postgres
Translated
I am new to coding and for one of my classes I have to make a map with markers. I have a database but I can not make it a geojson code to be able to display this data on my map. When I ...
0
votes
0answers
43 views
Sending parameters to ArcGIS script through web interface
I have written a simple script in ArcGIS environment and I want to run the script through a PHP program.
At present, I am trying this within localhost. In my script, I have defined two parameters. My ...
4
votes
1answer
370 views
Add Line Layer from PostGIS to Leaflet
I have a line layer in PostGIS that I would like to add to a Leaflet map. I have the PHP setup, but I can't seem to get the Javascript correct. I know my issue is converting the line to geoJSON.
The ...
0
votes
0answers
46 views
Leaflet var to php
I have a function when I click on the marker:
function onMarkerClick (e) {
id1 = "something";
$ .post ("content.php", {id_a: id1}, function (result) {
alert (result);
...
0
votes
1answer
35 views
Why is this happening? I show GeoJSON some coordinates with OpenLayers by request Ajax
I want to display a GeoJSON on OpenLayers with a request from Ajax from the database:
I store in the geojson variable all the information and I icercated in two ways:
1. Directly from the already ...
0
votes
1answer
74 views
PHP MapScript - Query GDB Geodatabase?
I'm trying to use/learn some PHP MapScript on a GDB file and cannot get anything from it.
The PHP below works great if I use countries.sqllite (via countries.map) file I have and shows me an array of ...
0
votes
0answers
674 views
How to convert geometry in the GeoJSON from PHP and insert polygon in PostGIS
I'm a beginner in PostGIS and GeoJSON.
I need to extract every geometry from GeoJSON and store them in the PostGIS database as polygons.
For each entry in GeoJSON I would like to be able to store ...
3
votes
1answer
681 views
How to compile/install php-mapscript with PHP7
So, this PR opens up mapscript support for PHP7. Since there is no ducomentation I gave it a try based on How compile/install php-mapscript on Ubuntu 16.04 (although I'm doing it in Debian 9 if that's ...
0
votes
0answers
236 views
Create a valid shapefile with phpmyadmin/Shapefile lib
I'm trying to create a shapefile with the PhpMyAdmin\ShapeFile library.
I followed the example in the Github project repository, but I would like to create a shapefile within polygon elements, not ...
1
vote
1answer
661 views
Editing PostGIS layer in Lizmap?
I've got a freshly Lizmap 3.2 installation. I can display PG-Layers but I cannot edit them. My setting is:
Ubuntu Server 18.04.1
PostgreSQL 10.6
Apache2
Lizmap 3.2
PHP 7.2
I followed this ...
-1
votes
1answer
168 views
Get some sample coordinates inside an area using its KML file [closed]
I have a KML file which defines an area. I want to get coordinates of some points inside that area using my KML file.
I googled a lot, but I only found codes to check if a point is inside. My issue ...
0
votes
1answer
828 views
Automatically refresh Leaflet Markers from MySQL
I have a leaflet map that loads marker details from a MySQL database. I have a timer that clears and reloads the layers (and therefore markers); however; it doesn't seem to be refreshing the data. ...
1
vote
0answers
49 views
Which polygons intersect rectangle in PHP/Linux GDAL?
I'm developing a website where I want to test which polygons from a shapefile intersect a given rectangle. Using PHP, I thought about using exec() function, calling a GDAL program, like ogrinfo. ...
0
votes
1answer
282 views
Uploading shapefile to PostGIS database using PHP
I want to insert a shapefile into a PostGIS database using PHP. I go through the examples and I tried the following:
$command = 'shp2pgsql -s 2100 -d /D:\CHECK DATA-group\2016\Ayomi\JULY\...
1
vote
1answer
1k views
Multiple markers on Google Maps using JavaScript, PHP and SQL
I am trying to query the MySQL database that has a table with firstname, longitude, latitude in it.
I want to get the longitude and latitude and display them as multiple markers with the firstname as ...
1
vote
0answers
655 views
Google Maps API - Multiple Polygons
I'll be generating my JSON file using PHP and SQL for displaying around 200 polygons, on a map. I've managed to test the concept with two polygons but still struggling.
I'm not experienced with JS or ...
0
votes
1answer
238 views
Spatial functions with MySQL, XAMPP, and Wordpress
I am trying to figure out how to using the ST_AsGeoJSON function in MySQL, but I keep getting an error that says that this function does not exist. I have found in the MySQL documentation that this ...
1
vote
0answers
316 views
openlayers-automatically adding the layers on clicking dynamic checkboxes without actually specifying all the published layers attributes
My tryonly.php looks like following
I also have categories.php to add layers with a common category or create a new in the database
There is no error in the code below, where i have been using ...
0
votes
1answer
392 views
Creating point with geometry to insert in database
I have a PostGIS table of points. With my php code and pdo, I want to add a point in it. I have the coordinates, I want to get the geometry, with ST_GeomFromText. Here is the code :
$x = $_POST['x'];
...
1
vote
0answers
118 views
Which approach is faster for getting all POIs from MySQL/MariaDB with PHP/Laravel [closed]
Correct me if I'm wrong.
There are three approaches to get the nearest homes, users have created in my website:
To create a table with two columns(latitude, longitude) that both of them are float ...
1
vote
0answers
180 views
Unable to upload shapefile using geoserver REST API and php
I am not able to upload shapefile and create a store in Geoserver using its rest api and Php. below is my php code
<?php
// Open log file
$logfh = fopen("GeoserverPHP.log", 'w') or die("can't ...
0
votes
1answer
232 views
TurfJS + PHP + MySQL
I have a PHP endpoint/service that receives Lat/Long data from a 3rd party. The data is then processed in PHP code and saved into a MySQL database. This process works fine without any issues.
I need ...
1
vote
0answers
757 views
Response not working in AJAX/PHP
I am working on Google Maps API, where I have made a dynamic marker popup. Now I want to take the user information from the popup and save it to my MySQL database without reloading the page. So I am ...
-1
votes
1answer
947 views
Add coordinates after click into form
I would like to add the coordinates as a click to the map as a form entry, I do not know how the function structure should look like
map.on('click', function(e) {
var lat = e.latlng.lat;
});
<...
1
vote
0answers
1k views
Parsing GeoJSON in PHP?
i am trying to parse GeoJson from database with php but somehow i got an error and i cannot found any error in my script. here my script
$id = 1;
$db = new mysqli("localhost","root","","skriboo");
$...
3
votes
1answer
710 views
Find if lat/long point is inside an area
I have got data using OpenStreetMaps Ways of many areas. I would now like to write a function which would return "true or false" if an single latitude/longitude point is found in that area or not.
I ...
