Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I use a postgres db, geoserver and openlayers to display a map with a wfs-t Layer that displays the geometry column of my table. Now I use control select to call a popup which contains a form to edit the other attribute-columns, e.g.:

    //add Popup
var select = new OpenLayers.Control.SelectFeature(garden);
        map.addControl(select);
        select.activate();

garden.events.on({
   featureselected: function(event) {
    var feature = event.feature;
    feature.popup = new OpenLayers.Popup.FramedCloud
    ("pop",
    feature.geometry.getBounds().getCenterLonLat(),
    null, 
    <form action="myphp.php" method="post">
    <div class="label"> Crop:</div><input name="crop" type="text" value=+feature.attributes.crop+>
    <input type="submit" name="write">
    </form>);
 map.addPopup(feature.popup);  
},

In my php-script I wrote:

$crop= $_POST['crop'];

and:

$res = pg_query ("UPDATE $tabelle SET crop = '".pg_escape_string ($crop)."' WHERE id = 6;");

This works fine, editing a specific line, in this case the line where the "id=6".

My Question: What is the php-Code for sth. like "where the id= selected feature id". How can I replace the "WHERE id = 6"-part with a variable that says: always update the attributes of the selected polygon"?

Thanks for your help!

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

My guess is you that first need to get the selected id of the feature using OpenLayers. Then in the HTML form you can put that value into an hidden field, something like :

                 <input type="hidden" name="myhiddenfield" value="feature.id" />

You'll be able to retrieve It in PHP after using $_POST['myhiddenfield']

Hope that helps, Gallien L.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.