| 357,7 → 357,7 |
|---|
| // creation lien image |
| foreach ($info_image as $pic) { |
| |
| $query = 'INSERT INTO cel_obs_images (coi_ce_image, coi_ce_utilisateur, coi_ce_observation) VALUES ("'.$DB->escapeSimple($pic['ci_id_image']).'","'.$DB->escapeSimple($utilisateur).'", "'.$DB->escapeSimple($ordre).'") ON DUPLICATE KEY UPDATE coi_ce_image = coi_ce_image' ; |
| $query = 'INSERT INTO cel_obs_images (coi_ce_image, coi_ce_utilisateur, coi_ce_observation) VALUES ("'.$DB->escapeSimple($pic['ci_id_image']).'","'.$DB->escapeSimple($utilisateur).'", "'.$DB->escapeSimple($this->dernier_ordre).'") ON DUPLICATE KEY UPDATE coi_ce_image = coi_ce_image' ; |
| |
| //print $query; |
| |
| 411,7 → 411,12 |
|---|
| preg_match('/(.*)/',$identifiant_commune,$elements); |
| if ($elements[1]) { // commune |
| $nom_commune=$elements[1]; |
| $query="SELECT DISTINCT name, code FROM locations WHERE name = '".$DB->escapeSimple($nom_commune)."'"; |
| $nom_commune=trim($nom_commune); |
| $nom_commune=utf8_decode($nom_commune); |
| $nom_commune=cp1252_to_utf8($nom_commune); |
| $nom_commune=remove_accent($nom_commune); |
| $nom_commune=preg_replace("/ /","%",$nom_commune); |
| $query="SELECT DISTINCT name, code FROM locations WHERE name like '".$DB->escapeSimple($nom_commune)."'"; |
| } |
| } |
| } |