"; // affichage du tableau $requete = "SELECT map_projection_id, map_projection_name FROM map_projections ORDER BY map_projection_name "; $res = pmb_mysql_query($requete, $dbh); $nbr = pmb_mysql_num_rows($res); $parity=1; for($i=0;$i<$nbr;$i++) { $row=pmb_mysql_fetch_object($res); if ($parity % 2) $pair_impair = "even";else $pair_impair = "odd"; $parity += 1; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='./admin.php?categ=notices&sub=map_projection&action=modif&id=$row->map_projection_id';\" "; print "
".htmlentities($row->map_projection_name,ENT_QUOTES, $charset)."
"; print "
"; } print "
"; } function map_projection_form($nom="", $id=0) { global $msg; global $admin_map_projection_form; global $charset; $admin_map_projection_form = str_replace('!!id!!', $id, $admin_map_projection_form); if(!$id) $admin_map_projection_form = str_replace('!!form_title!!', $msg[admin_noti_map_projection_ajout], $admin_map_projection_form); else $admin_map_projection_form = str_replace('!!form_title!!', $msg[admin_noti_map_projection_modification], $admin_map_projection_form); $admin_map_projection_form = str_replace('!!nom!!', htmlentities($nom,ENT_QUOTES, $charset), $admin_map_projection_form); $admin_map_projection_form = str_replace('!!nom_suppr!!', addslashes($nom), $admin_map_projection_form); print confirmation_delete("./admin.php?categ=notices&sub=map_projection&action=del&id="); print $admin_map_projection_form; } switch($action) { case 'update': if(!empty($form_nom)) { if($id) { $requete = "UPDATE map_projections SET map_projection_name='$form_nom' WHERE map_projection_id='$id' "; $res = pmb_mysql_query($requete, $dbh); } else { $requete = "SELECT count(1) FROM map_projections WHERE map_projection_name='$form_nom' LIMIT 1 "; $res = pmb_mysql_query($requete, $dbh); $nbr = pmb_mysql_result($res, 0, 0); if($nbr == 0){ $requete = "INSERT INTO map_projections (map_projection_name) VALUES ('$form_nom') "; $res = pmb_mysql_query($requete, $dbh); } } } show_map_projection(); break; case 'add': if(empty($form_nom)) map_projection_form(); else show_map_projection(); break; case 'modif': if($id){ $requete = "SELECT map_projection_name FROM map_projections WHERE map_projection_id='$id' "; $res = pmb_mysql_query($requete, $dbh); if(pmb_mysql_num_rows($res)) { $row=pmb_mysql_fetch_object($res); map_projection_form($row->map_projection_name, $id); } else { show_map_projection(); } } else { show_map_projection(); } break; case 'del': if ($id) { $requete = "DELETE FROM map_projections WHERE map_projection_id='$id' "; $res = pmb_mysql_query($requete, $dbh); $requete = "OPTIMIZE TABLE map_projections "; $res = pmb_mysql_query($requete, $dbh); show_map_projection(); } break; default: show_map_projection(); break; }