[postgis-users] PHP & PostGIS.

[Eric Sepich]

Works great! Thanks for the insight.

On Sun, Jun 26, 2011 at 9:33 PM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:

> On 6/27/2011 12:31 AM, Stephen Woodbridge wrote:
>
>> On 6/27/2011 12:28 AM, Eric Sepich wrote:
>>
>>> <?php
>>> $dbconn = pg_connect("host=localhost port=5432 dbname=postgismethane
>>> user=root password=excedrin413");
>>>
>>> $query = "SELECT * FROM polygons WHERE gid = 1";
>>> $result = pg_exec($dbconn, $query);
>>> if (!$result) {printf ("ERROR"); exit;}
>>> $numrows = pg_numrows($result);
>>> ?>
>>>
>>> I get one row returned but I just don't seem to have any kind of
>>> documentation on what to do with it. I want to list the coordinates of
>>> the polygon returned by my query. Does anyone know how to do that?
>>>
>>
>> Try something like this:
>>
>>
>> <?php
>> $dbconn = pg_connect("host=localhost port=5432 dbname=postgismethane
>> user=root password=excedrin413");
>>
>> $query = "SELECT * FROM polygons WHERE gid = 1";
>>
>
> Ooops, meant to change this to:
>
>  $query = "SELECT *, astext(the_geom) FROM polygons WHERE gid = 1";
>
>
>  $r = pg_exec($dbconn, $query);
>> if (!$r) {printf ("ERROR"); exit;}
>>
>> $n = pg_num_rows($r);
>> for ($i=0; $i<$n; $i++) {
>> printf("----- Row: %d -------\n", $i);
>> $row = pg_fetch_assoc($r);
>> pg_free_result($r);
>> foreach ($row as $k=>$v)
>> printf("%20s = %s\n", $k, $v);
>> }
>> pg_close($dbh);
>> ?>
>> ______________________________**_________________
>> postgis-users mailing list
>> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>>
>
> ______________________________**_________________
> postgis-users mailing list
> postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110626/d628da1b/attachment.html>