Changeset 282 for trunk/client/temi/spectral/index.php

Timestamp:

Apr 21, 2019, 9:46:30 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/client/temi/spectral/index.php (modified) (2 diffs)

trunk/client/temi/spectral/index.php

@@ -15 +15 @@
 global $tema,$file,$sitename,$blocco,$dbi,$prefix,$id_comune,$descr_cons,$op;
 
-$res = mysql_query("SELECT descrizione,simbolo FROM ".$prefix."_ele_comuni where id_comune='$id_comune' ", $dbi);
-        list($descr_com,$simbolo) = mysql_fetch_row($res);
+$sql="SELECT descrizione,simbolo FROM ".$prefix."_ele_comuni where id_comune='$id_comune' ";
+$res = $dbi->prepare("$sql");
+$res->execute();
+
+        list($descr_com,$simbolo) = $res->fetch(PDO::FETCH_NUM);
         $descr_com =stripslashes($descr_com); 
 
@@ -148 +151 @@
         if($pos=="dx") $p=0; elseif($pos=="sx")$p=1;else $p='';
         
-        $resblk = mysql_query("SELECT * FROM ".$prefix."_ele_widget where pos_or='$p' and attivo='1' order by pos_ver asc", $dbi);
-        if($resblk){
+        $sql="SELECT * FROM ".$prefix."_ele_widget where pos_or='$p' and attivo='1' order by pos_ver asc";
+$resblk = $dbi->prepare("$sql");
+$resblk->execute();
+        if($resblk->rowCount()){
                 
                 while ($row = mysql_fetch_array($resblk)) {