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)."'"; |
} |
} |
} |