Changeset 265 for trunk/client/modules/Elezioni/blocchi/off_Votanti.php

Timestamp:

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

Author:

roby

Message:

 

File:

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

trunk/client/modules/Elezioni/blocchi/off_Votanti.php

@@ -22 +22 @@
 #       $numero=mysql_num_rows($res);
 #       $res = mysql_query("select *  from ".$prefix."_ele_sezioni where id_cons='$id_cons'",$dbi);
-        $res = mysql_query("select t3.*  from ".$prefix."_ele_voti_".$tab." as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons' $circos  group by t3.id_sez ",$dbi);
-        $numero=mysql_num_rows($res);
-        $res = mysql_query("select t1.*  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",$dbi);
-        $sezioni=mysql_num_rows($res);
+        $sql="select t3.*  from ".$prefix."_ele_voti_".$tab." as t3 left join ".$prefix."_ele_sezioni as t1 on t3.id_sez=t1.id_sez left join ".$prefix."_ele_sede as t2 on t1.id_sede=t2.id_sede where t3.id_cons='$id_cons' $circos  group by t3.id_sez ";
+        $res = $dbi->prepare("$sql");
+        $res->execute();
+
+        $numero=$res->rowCount();
+        $sql="select t1.*  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";
+        $res = $dbi->prepare("$sql");
+        $res->execute();
+
+        $sezioni=$res->rowCount();
         
         if ($numero!=0){
@@ -36 +42 @@
 
 
-        $res1 = mysql_query("SELECT sum(t1.maschi+t1.femmine) 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",$dbi);
-        list($tot_aventi)  = mysql_fetch_row($res1);
+        $sql="SELECT sum(t1.maschi+t1.femmine) 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";
+        $resl = $dbi->prepare("$sql");
+        $resl->execute();
+
+        list($tot_aventi)  = $res1->fetch(PDO::FETCH_NUM);
         if ($genere!=0) {
 
-                $res1 = mysql_query("SELECT sum(t1.validi+t1.nulli+t1.bianchi+t1.contestati) as tot,
+                $sql="SELECT sum(t1.validi+t1.nulli+t1.bianchi+t1.contestati) as tot,
                 sum(t1.validi),sum(t1.nulli),sum(t1.bianchi),sum(t1.contestati), '0'
-                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 having tot>0",$dbi);
+                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 having tot>0";
+        $resl = $dbi->prepare("$sql");
+        $resl->execute();
+
         }else{
-                $res1 = mysql_query("SELECT sum(validi+nulli+bianchi+contestati) as tot,
+                $sql="SELECT sum(validi+nulli+bianchi+contestati) as tot,
                 sum(validi),sum(nulli),sum(bianchi),sum(contestati), id_gruppo
-                from ".$prefix."_ele_voti_ref  where id_cons=$id_cons group by id_gruppo having tot>0",$dbi);
+                from ".$prefix."_ele_voti_ref  where id_cons=$id_cons group by id_gruppo having tot>0";
+        $resl = $dbi->prepare("$sql");
+        $resl->execute();
+
         }
 
-        while  (list($tot_votanti,$validi,$nulli,$bianchi,$contestati,$id)  = mysql_fetch_row($res1)){
+        while  (list($tot_votanti,$validi,$nulli,$bianchi,$contestati,$id)  = $res1->fetch(PDO::FETCH_NUM)){
                 $tot_votanti=$validi+$bianchi+$nulli+$contestati;
                 $perc_validi=number_format($validi*100/$tot_votanti,2);
@@ -60 +75 @@
 
                 if ($genere==0) {
-                        $res = mysql_query("SELECT num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo=$id",$dbi);
-                        list($num_gruppo,$descr_gruppo)  = mysql_fetch_row($res);
+                        $sql="SELECT num_gruppo,descrizione from ".$prefix."_ele_gruppo where id_gruppo=$id";
+        $res = $dbi->prepare("$sql");
+        $res->execute();
+
+                        list($num_gruppo,$descr_gruppo)  = $res->fetch(PDO::FETCH_NUM);
                 }