Changeset 257 for trunk/admin/modules/Elezioni/ele_collegi.php

Timestamp:

Feb 9, 2019, 8:45:24 PM (6 years ago)

Author:

roby

Message:

 

File:

• trunk/admin/modules/Elezioni/ele_collegi.php (modified) (4 diffs)

trunk/admin/modules/Elezioni/ele_collegi.php

@@ -41 +41 @@
 
         OpenTable();    
-        $resmod = mysql_query("SELECT t1.id_collegio, t1.descrizione, t2.descrizione FROM ".$prefix."_ele_collegi as t1, ".$prefix."_ele_consultazione as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen=$id_cons_gen order by t1.descrizione asc", $dbi);
+        $sql = "SELECT t1.id_collegio, t1.descrizione, t2.descrizione FROM ".$prefix."_ele_collegi as t1, ".$prefix."_ele_consultazione as t2 where t1.id_cons_gen=t2.id_cons_gen and t2.id_cons_gen=$id_cons_gen order by t1.descrizione asc";
+        $resmod = $dbi->prepare("$sql");
+        $resmod->execute();     
         echo "<table><tr ALIGN=\"CENTER\">";
         echo "<td bgcolor=\"$bgcolor1\"><b>"._CONSULTA."</b></td>";
@@ -50 +52 @@
         echo "<input type=\"hidden\" name=\"id_collegio\" value=\"$id_collegio\">";
         echo "<tr align=\"center\">";
-        $ressede = mysql_query("SELECT descrizione from ".$prefix."_ele_consultazione where id_cons_gen='$id_cons_gen'", $dbi);
-        list($descr_cons)=mysql_fetch_row($ressede);
+        $sql = "SELECT descrizione from ".$prefix."_ele_consultazione where id_cons_gen='$id_cons_gen'";
+        $ressede = $dbi->prepare("$sql");
+        $ressede->execute();    
+        list($descr_cons)=$ressede->fetch(PDO::FETCH_NUM);
         echo "<td>$descr_cons</td>";
         echo "<td  align=\"center\" width=\"32\"><input name=\"desc\" value=\"$desc\"></td>";
@@ -64 +68 @@
         }
         $i=0;
-        while (list($id_collegio2,$desc,$descr_cons) = mysql_fetch_row($resmod)){ //elenco dei modelli inseriti
+        while (list($id_collegio2,$desc,$descr_cons) = $resmod->fetch(PDO::FETCH_NUM)){ //elenco dei modelli inseriti
                 $i++;
                 $bgcolor1=($bgcolor1==$_SESSION['bgcolor1'])?$_SESSION['bgcolor2']:$_SESSION['bgcolor1'];
@@ -97 +101 @@
                                 die();
                         }else{
-                                $result = mysql_query("delete from ".$prefix."_ele_collegi where id_collegio='$id_collegio'", $dbi);
-                                if (!$result) return;
+                                $sql = "delete from ".$prefix."_ele_collegi where id_collegio='$id_collegio'";
+                                $result = $dbi->prepare("$sql");
+                                $result->execute();     
+                    if (!$result->rowCount()) return;
                                 Header("Location: admin.php?op=inscollegi&id_cons_gen=$id_cons_gen");
                         }
                 }
                 if ($do == "add") {
-                        $result = mysql_query("insert into ".$prefix."_ele_collegi(id_cons_gen,descrizione) values ('$id_cons_gen','$desc')", $dbi) || die("Impossibile inserire il collegio! ".mysql_error());
+                        $sql = "insert into ".$prefix."_ele_collegi(id_cons_gen,descrizione) values ('$id_cons_gen','$desc')";
+                        $result = $dbi->prepare("$sql");
+                        $result->execute();     
                 }
                 if ($do == "update") {
-                        $result = mysql_query("update  ".$prefix."_ele_collegi set descrizione='$desc' , id_cons_gen='$id_cons_gen' where id_collegio='$id_collegio'", $dbi);
-                if (!$result) return;
-#                       echo "update  ".$prefix."_ele_collegi set descrizione='$desc' , id_cons_gen='$id_cons_gen' where id_collegio='$id_collegio'";
-                        Header("Location: admin.php?op=inscollegi&id_cons_gen=$id_cons_gen&id_collegio=$id_collegio");
+                $sql= "update  ".$prefix."_ele_collegi set descrizione='$desc' , id_cons_gen='$id_cons_gen' where id_collegio='$id_collegio'";
+                        $result = $dbi->prepare("$sql");
+                        $result->execute();     
+                if (!$result->rowCount()) return;
+                        Header("Location: admin.php?op=inscollegi&id_cons_gen=$id_cons_gen&id_collegio=$id_collegio");
                 }
         }