[Users] display php& postgresql queries in openlayers via Geojson format

[javad sadidi]

I am using openstreet maps OSM as the background for my projects and I
am doing pgrouting to find the best route. it works fine.my database for
routing is inside the postgresql .
now I have added a field in my table in postgresql , this field is the
status of the streets , I mean some records of this field are CLOSE and
the rest are OPEN.
I want to show the CLOSE records from the Status field in the browser
with Geojson format. for sure I have to do a query like , select * from
mytable WHERE status='CLOSE;
I use php for server side dealing . my database projection is in
geographic 4326 and the OSM streets in the browser is in mercator
900913.
how can I display the result of the query as a line vector layer in the
browser ?
I know that I have ti cerate a layer in openlayer and write php codes to
do the query , but it doesnt work. who can help me in more details or
show an example exception pgrouting workshop 2010.
sinecerly
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.geoext.org/pipermail/users/attachments/20110812/52f2c84b/attachment.htm