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

Timestamp:

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

Author:

roby

Message:

 

File:

• trunk/admin/modules/Elezioni/funzionidata.php (modified) (1 diff)

trunk/admin/modules/Elezioni/funzionidata.php

@@ -95 +95 @@
 global $prefix,$dbi,$id_cons,$limite,$id_comune,$ops;
 $sqlcomu="select fascia from ".$prefix."_ele_comuni where id_comune='$id_comune'";
-$res = mysql_query($sqlcomu);
-list($fascia)=mysql_fetch_row($res);
+$res = $dbi->prepare("$sqlcomu");
+$res->execute();        
+list($fascia)=$res->fetch(PDO::FETCH_NUM);
         #voti di lista e di gruppo completamente disgiunti 
-        $result = mysql_query("select infdisgiunto, supdisgiunto from ".$prefix."_ele_conf as t2 left join ".$prefix."_ele_cons_comune as t1 on t1.id_conf=t2.id_conf where id_cons = '$id_cons' ", $dbi);
+        $sql="select infdisgiunto, supdisgiunto from ".$prefix."_ele_conf as t2 left join ".$prefix."_ele_cons_comune as t1 on t1.id_conf=t2.id_conf where id_cons = '$id_cons' ";
+        $result = $dbi->prepare("$sql");
+        $result->execute();     
         $glsep='';
-        if ($result) {
-                list($infdis,$supdis)=mysql_fetch_row($result);
+        if ($result->rowCount()) {
+                list($infdis,$supdis)=$result->fetch(PDO::FETCH_NUM);
                 if((($fascia>$limite and $supdis) or ($fascia<=$limite and $infdis)))
                         $glsep='_lista';