Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require 'dataload.php';
- function get_objects($where,$name=false) {
- global $epsg, $cnt_array;
- $db = Dataload::getDB();
- $columns="osm_id, ST_AsGeoJSON(ST_Transform(way,4326)) as way2, name, ward, "healthcare:speciality", information, description, social_facility, "social_facility:for", capacity, operator, official_name, official_status, phone, website, "addr:full", "addr:city", "addr:district", "addr:postcode", opening_hours, "addr:hamlet", "addr:street", fax, email, allhuman, adulthuman, childhuman, "healthcare:heart", "healthcare:mind", "healthcare:maternity_light", "healthcare:maternity_hard", "healthcare:dtp", "ward:speciality_gynaecology", "ward:speciality_maternity", "ward:speciality_infectious_diseases", "ward:speciality_neurology", "ward:speciality_paediatrics", "ward:speciality_general", "ward:speciality_surgery", "internet_access:operator", "internet_access:speed", "wifi_access:ssid"";
- $query="select ".$columns." from test_point where ".$where;
- $result = pg_query($query);
- if (!$result) {
- echo "Problem with query " . $query . "<br/>";
- echo pg_last_error();
- exit();
- }
- $geojson = array(
- 'type' => 'FeatureCollection',
- 'features' => array(),
- 'crs' => array(
- 'type' => 'EPSG',
- 'properties' => array('code' => '4326')
- )
- );
- while($myrow = pg_fetch_assoc($result)) {
- $gos18_work = array();
- if($name=="gos18") {
- $query_gos18_work = "select * from gos18_work where obj=".$myrow["osm_id"];
- $result_gos18_work = pg_query($query_gos18_work);
- if (!$result_gos18_work) {
- echo "Problem with query " . $query_gos18_work . "<br/>";
- echo pg_last_error();
- exit();
- }
- while($myrow_gos18 = pg_fetch_assoc($result_gos18_work)) {
- $gos18_work[] = array(
- blah=>blah
- );
- }
- }
- $feature = array(
- 'type' => 'Feature',
- 'id' => $myrow["osm_id"],
- 'layer' => $epsg,
- 'geometry' => json_decode($myrow["way2"], true),
- 'geometry_name' => 'way',
- 'properties' => array(
- 'name' => $myrow["name"],
- )
- );
- // Add feature array to feature collection array
- array_push($geojson['features'], $feature);
- }
- // Close database connection
- pg_close($db);
- }
- if(blah) ......get_objects($where);....
- public static function getDB() {
- return pg_connect('host=notlocalhost port=5432 user=user password=password dbname=dbname')
- or die("not connect".pg_last_error());
- }
- Warning: pg_close() expects parameter 1 to be resource, boolean given in my.php on line....
Add Comment
Please, Sign In to add comment