$value) { $multipoint .= '('; $multipoint .= $value["pos"]["x"]; $multipoint .= ' '; $multipoint .= $value["pos"]["y"]; $multipoint .= '),'; } $multipoint = 'MULTIPOINT (' . rtrim($multipoint, ',') . ')'; // var_dump($point_pos);die; // die('
' . print_r($multipoint, 1) . '
'); $targetProjSricCode = intval($targetProj["srsProjNumber"]); $currentProjSricCode = intval($currentProj["srsProjNumber"]); $sql = "SELECT ST_AsGeoJson(ST_Transform(ST_GeomFromText($1,$2),$3::int)) As target_geom"; $v = array($multipoint, intval($targetProjSricCode), intval($currentProjSricCode)); $t = array('s', 'i', 'i'); $res = db_prep_query($sql, $v, $t); db_fetch_row($res); $geom = db_result($res, 0, 'target_geom'); // @TODO: Test the sql // die('
' . print_r($geom, 1) . '
'); echo($geom); // $geom = json_decode(db_result($res, 0, 'geom')); // $feat->geometry = $geom; // transform point json to wkt MULTIPOINT } catch (Exception $e) { echo($e); die; }