Changeset 336 for trunk/admin/modules/Elezioni/ele_desc_fasce.php

Timestamp:

Sep 23, 2020, 11:32:27 AM (4 years ago)

Author:

roby

Message:

Admin: prime modifiche per compatibilità con php 7.4

File:

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

trunk/admin/modules/Elezioni/ele_desc_fasce.php

@@ -13 +13 @@
 if (isset($_GET['fascia'])) $fasciacom=intval($_GET['fascia']);  else $fasciacom=0;
 include("../../config.php");
-                $dbi=mysql_connect($dbhost, $dbuname, $dbpass) or die("Connessione non riuscita: " . mysql_error());
-                mysql_select_db($dbname)or die("Connessione non riuscita:" . mysql_error());
-        mysql_query("SET NAMES 'utf8'", $dbi);
-                        $rescomu = mysql_query("SELECT id_fascia,abitanti from ".$prefix."_ele_fasce where id_conf='$id_conf'", $dbi);
-                
-                echo "<select name=\"idfascia\">";
-                echo "<option value=\"0\"> ";
-                $inffascia=0;
-                while(list($id,$abitanti)=mysql_fetch_row($rescomu)){
-                        $sel='';
-                        if ($id == $fasciacom) $sel="selected"; elseif ($id==1) $sel="selected";
-                        echo "<option value=\"$id\" $sel>$inffascia - $abitanti";
-                        $inffascia=$abitanti;
-                }
-                echo "</select>";
+        try{
+        $dbi = new PDO("mysql:host=$dbhost;charset=latin1", $dbuname, $dbpass, array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); 
+        $sql = "use $dbname";
+        $dbi->exec($sql);
+        }
+        catch(PDOException $e)
+        {
+            echo $sql . "<br>" . $e->getMessage();
+        }                                                                                               
+        $sql="SELECT id_fascia,abitanti from ".$prefix."_ele_fasce where id_conf='$id_conf'";
+        $sth = $dbi->prepare("$sql");
+        $sth->execute();                        
+        echo "<select name=\"idfascia\">";
+        echo "<option value=\"0\"> ";
+        $inffascia=0;
+        while(list($id,$abitanti)=$sth->fetch(PDO::FETCH_NUM)){
+                $sel='';
+                if ($id == $fasciacom) $sel="selected"; elseif ($id==1) $sel="selected";
+                echo "<option value=\"$id\" $sel>$inffascia - $abitanti";
+                $inffascia=$abitanti;
+        }
+        echo "</select>";
 
 ?>