Exemplo n.º 1
0
     show_codstat($dbh);
     break;
 case 'add':
     if (empty($form_libelle) && empty($form_pret)) {
         codstat_form();
     } else {
         show_codstat($dbh);
     }
     break;
 case 'modif':
     if ($id) {
         $requete = "SELECT codestat_libelle, statisdoc_codage_import, statisdoc_owner FROM docs_codestat WHERE idcode={$id} ";
         $res = mysql_query($requete, $dbh);
         if (mysql_num_rows($res)) {
             $row = mysql_fetch_object($res);
             codstat_form($row->codestat_libelle, $row->statisdoc_codage_import, $row->statisdoc_owner, $id);
         } else {
             show_codstat($dbh);
         }
     } else {
         show_codstat($dbh);
     }
     break;
 case 'del':
     if ($id) {
         $total = mysql_result(mysql_query("select count(1) from exemplaires where expl_codestat ='" . $id . "' ", $dbh), 0, 0);
         if ($total == 0) {
             $requete = "DELETE FROM docs_codestat WHERE idcode={$id} ";
             $res = mysql_query($requete, $dbh);
             show_codstat($dbh);
         } else {
Exemplo n.º 2
0
     show_codstat($dbh);
     break;
 case 'add':
     if (empty($form_libelle)) {
         codstat_form();
     } else {
         show_codstat($dbh);
     }
     break;
 case 'modif':
     if ($id) {
         $requete = "SELECT libelle FROM empr_codestat WHERE idcode={$id} LIMIT 1;";
         $res = mysql_query($requete, $dbh);
         if (mysql_num_rows($res)) {
             $row = mysql_fetch_row($res);
             codstat_form($row[0], $id);
         } else {
             show_codstat($dbh);
         }
     } else {
         show_codstat($dbh);
     }
     break;
 case 'del':
     if ($id) {
         $total = 0;
         $total = mysql_result(mysql_query("select count(1) from empr where empr_codestat ='" . $id . "' ", $dbh), 0, 0);
         if ($total == 0) {
             $requete = "DELETE FROM empr_codestat WHERE idcode={$id} ;";
             $res = mysql_query($requete, $dbh);
             $requete = "OPTIMIZE TABLE empr_codestat ";