Cartographie fine

Outils en cours de développement.
$value) { $$name = $value; } // Si les variables passées en POST ne sont pas vides, alors insertion dans la base if ($code && $lattitude && $longitude) { if (is_numeric($lattitude) && is_numeric($longitude) && is_string($code)) { if ($lattitude < -85 || $lattitude > 85 || $longitude < -180 || $longitude > 180) { print "Vous avez entré une valeur incorrecte"; exit; } $code = addslashes(substr($code,0,200)); //$sql = eval(DoStrAdd()); $sql = "insert into CorGarMap values ( null , 0, $lattitude, $longitude, '$code', $dateobs, '$observateur', '$statut', '$remarque')"; $result = mysql_query($sql,$DBH) or DBError("LINE: " .__LINE__. " $sql"); print "Enregistrement de l'observation en cours ...
"; exit; } } // Définistion des points par javascript apres insertion $jsPointsArray = getPointsJS(); $pageHTML = <<

Saisie des observations de Rollier 2008
Attention : Une OBSERVATION correspond a : UN oiseau (avec un statut unique au moment donné) UN lieu UNE date Table de données Patrick Mayet pour le Groupe de Travail Rollier (04/2008)	EOH; $pageHTML2=<<

EOJ; print $pageHTML; print DoForm('',"SELECT * FROM CorGarMap"); print $pageHTML2; ///////////////////////////// Functions /////////////////////////////////////// function getPointsJS() { global $DBH; $sql = "select * from CorGarMap WHERE del=0"; $result = mysql_query($sql,$DBH) or DBError("LINE: " .__LINE__. " $sql"); $nRows = mysql_num_rows($result); $javaScript = ''; if ($nRows) { while ($row = mysql_fetch_assoc($result)) { $row{'description'} = addslashes($row{'description'}); $row{'description'} = str_replace(';',',',$row{'description'}); $javaScript .= "mArray.push('{$row{'lattitude'}};{$row{'longitude'}};{$row{'dateobs'}};{$row{'code'}};{$row{'id'}};{$row{'dateobs'}};{$row{'observateur'}}')\n"; } //print "$nRows enregisrements séléctionnés.\n"; } else { print "Pas d'observations dans la base.\n"; } return $javaScript; } function assertTable() { global $DBH; // Create table, if it does not already exist $createTableSQL = <<\n"; print "$sql\n"; print "

---

\n"; exit; } function DB_Connect() { global $CONFIG; $DBH = mysql_connect($CONFIG{'hostname'}, $CONFIG{'user'}, $CONFIG{'password'}) or DBError("LINE: " .__LINE__. " Connect");; $sql = "create database IF NOT EXISTS {$CONFIG{'db'}}"; $result = mysql_query($sql,$DBH) or DBError("LINE: " .__LINE__. " $sql"); mysql_select_db($CONFIG{'db'}, $DBH) or DBError("LINE: " .__LINE__. " Select DB");; return $DBH; } //Création dynamique du formulaire function DoForm($title,$sql){ global $DBH; $HTML = ''; $result = mysql_query($sql,$DBH) or DBError($sql); $colCount = mysql_num_fields($result); $rowCount = mysql_num_rows($result); $HTML .= "\n"; $fields = mysql_list_fields("mayetp", "CorGarMap", $DBH); $columns = mysql_num_fields($fields); for ($i = 2; $i < $columns; $i++) { $pair = $i % 2; $HTML .= ""; if ($pair == 1) { $HTML .= "\n"; } } $HTML .= "\n"; $HTML .= "

"; $HTML .= mysql_field_name($fields, $i); $HTML .= "

\n"; $HTML .= "
\n"; return $HTML; } //Création dynamique de la chaine SQL d'ajout de données function DoStrAdd(){ global $DBH; $DoStrAddsql="SELECT * FROM CorGarMap"; $result = mysql_query($DoStrAddsql,$DBH) or DBError($DoStrAddsql); $colCount = mysql_num_fields($result); $rowCount = mysql_num_rows($result); $fields = mysql_list_fields("mayetp", "CorGarMap", $DBH); $columns = mysql_num_fields($fields); $StrSqlAdd = "$sql = \"insert into CorGarMap values (NULL, 0"; for ($i = 2; $i < $columns; $i++) { $StrSqlAdd .= ", "; if (mysql_field_type($fields, $i)=="string") { $StrSqlAdd .= "'"; } $StrSqlAdd .= "\$" + mysql_field_name($fields, $i) ; if (mysql_field_type($fields, $i)=="string") { $StrSqlAdd .= "'"; } } $StrSqlAdd .=")\";"; echo ($StrSqlAdd); //return $StrSqlAdd; } ?>

---