Works great! Thanks for the insight. On Sun, Jun 26, 2011 at 9:33 PM, Stephen Woodbridge <wood...@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@postgis.**refractions.net<postgis-users@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@postgis.**refractions.net<postgis-users@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users