Changeset 265 for trunk/client/modules/Elezioni/blocchi/04_sezioni.php

Timestamp:

Apr 13, 2019, 8:05:15 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/client/modules/Elezioni/blocchi/04_sezioni.php (modified) (3 diffs)

trunk/client/modules/Elezioni/blocchi/04_sezioni.php

@@ -11 +11 @@
 }
 global  $prefix, $dbi,$id_cons_gen;
-$sql = mysql_query("select chiusa  from ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen'",$dbi);
-                list($chiusa) = mysql_fetch_row($sql);
+$sql = "select chiusa  from ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen'";
+        $res = $dbi->prepare("$sql");
+        $res->execute();
+
+                list($chiusa) = $res->fetch(PDO::FETCH_NUM);
                 
                 //if($chiusa!='1') numeri_sezione(); # se la consultazione non Ú chiusa
@@ -33 +36 @@
 
                 # numero sezioni
-                $res = mysql_query("select t1.id_sez,t1.num_sez  from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos order by t1.num_sez",$dbi);
-                $max = mysql_num_rows($res);
+                $sql="select t1.id_sez,t1.num_sez  from ".$prefix."_ele_sezioni as t1 left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t1.id_cons='$id_cons' $circos order by t1.num_sez";
+                $res = $dbi->prepare("$sql");
+                $res->execute();
+
+                $max = $res->rowCount();
                 if(!isset($html)) $html='';
                 $html = "\n<table  style=\"margin:0px auto;border:0px; width:90%\"><tr>";
                 
                 $i=0;$id_circ_old=0;$e=0;
-                while(list($sez_id, $sez_num) = mysql_fetch_row($res)) {
+                while(list($sez_id, $sez_num) = $res->fetch(PDO::FETCH_NUM)) {
                         $i++;
                         /****************************************************************/     
@@ -57 +63 @@
                         #colora la sezione
                         # verifica se la sezione Ú scrutinata
-                         $res2 = mysql_query("select *  from ".$prefix."_ele_voti_".$tab." where   id_sez='$sez_id'",$dbi);
-                         $numero=mysql_num_rows($res2); 
+                         $sql="select *  from ".$prefix."_ele_voti_".$tab." where   id_sez='$sez_id'";
+        $res2 = $dbi->prepare("$sql");
+        $res2->execute();
+
+                         $numero=$res2->rowCount(); 
                          if ($numero!=0){$e++;$bgsez="#FFFF00";}else{$bgsez="";}