<?php
/*
 $Id: wkt_point.php 709 2011-09-15 16:23:16Z fmichon $
Transfert du point en cours de saisie au format wkt
*/
include ("../obj/utils.class.php");
$f = new utils ('nohtml');
$f->disableLog();
if (isset ($_GET['idx'])){
   $idx=$_GET['idx'];
}else{
   $idx=0;
}
if (isset ($_GET['obj'])){
   $obj=$_GET['obj'];
}else{
   $obj='';
}
if (isset ($_GET['table'])){
   $table=$_GET['table'];
}else{
   $table='';
}
if (isset ($_GET['champ'])){
   $champ=$_GET['champ'];
}else{
   $champ='';
}


if(is_numeric($idx))
    $sql = "select astext(".$champ.") as geom from ".DB_PREFIXE.$table." where ".$table."=".$idx."";
else
    $sql = "select astext(".$champ.") as geom from ".DB_PREFIXE.$table." where ".$table."='".$idx."'";

$res = $f -> db -> query($sql);
if (DB :: isError($res)){
	die($res->getMessage()."erreur ".$sql);
}else{
	$wkt = 'GEOMETRYCOLLECTION(';
	while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){
	     if($row["geom"]!='')
		$wkt.= $row["geom"].",";
	}
}
$wkt=substr($wkt,0, strlen($wkt)-1);
$wkt.= ")";
echo $wkt;
?>