Changeset 253 for trunk/client/modules.php

Timestamp:

Mar 12, 2018, 8:53:21 PM (7 years ago)

Author:

roby

Message:

 

File:

• trunk/client/modules.php (modified) (5 diffs)

trunk/client/modules.php

@@ -99 +99 @@
 
 
-
-
+$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);
+
+/*
 
 if(!$dbi = mysql_connect($dbhost, $dbuname, $dbpass)){
@@ -110 +114 @@
 }
 mysql_query("SET NAMES 'utf8'", $dbi);
-
+*/
 # protezione csrf ottobre 2012 - by l.apolito
 if (file_exists("inc/csrf-magic/csrf-magic.php")) {
@@ -122 +126 @@
 
 # carica i parametri di default sulla tabella
-$res = mysql_query("SELECT * FROM ".$prefix."_config" , $dbi);
-$row = mysql_fetch_array($res);
+$sql = $dbi->prepare("SELECT * FROM ".$prefix."_config");
+$sql->execute();
+while($riga = $sql->fetchAll(PDO::FETCH_ASSOC)){$row=$riga[0];
 $sitename = stripslashes($row['sitename']);
 $siteurl = $row['siteurl'];
@@ -146 +151 @@
 $ed_user = $row['ed_user'];
 #tema mobile
-
+}
 
 
 
 # altre config
-$res = mysql_query("SELECT * FROM ".$prefix."_ele_comuni where id_comune='$siteistat' ", $dbi);
-$row = mysql_fetch_array($res);
+$sql = $dbi->prepare("SELECT * FROM ".$prefix."_ele_comuni where id_comune='$siteistat' ");
+$sql->execute();
+$riga = $sql->fetchAll(PDO::FETCH_ASSOC);
+$row=$riga[0];
 $id_cons_pred = intval($row['id_cons']);
 if($id_cons_pred=='0')$id_cons_pred='';
 if(!isset($id_cons_gen)) $id_cons_gen=$id_cons_pred;
 # carica il metodo d'hontd 
-$res = mysql_query("SELECT * FROM ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' ", $dbi);
-$row = mysql_fetch_array($res);
-
-
-
+##$sql = $dbi->prepare("SELECT * FROM ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_gen' ");
+##$sql->execute();
 
 $param=strip_tags(strtolower($_SERVER['REQUEST_METHOD'])) == 'get' ? $_GET : $_POST;
@@ -170 +174 @@
 $id_cons_bak=intval($param['id_cons_gen']);
 if (isset($param['id_comune'])) $id_combak=intval($param['id_comune']); else $id_combak=$_SESSION['id_comune'];
-$res = mysql_query("SELECT id_cons,id_conf FROM ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_bak' and id_comune='$id_combak'" , $dbi);
-list($id_cons,$hondt) = mysql_fetch_row($res);
+$sql = $dbi->prepare("SELECT id_cons,id_conf FROM ".$prefix."_ele_cons_comune where id_cons_gen='$id_cons_bak' and id_comune='$id_combak'");
+$sql->execute();
+$row = $sql->fetchAll(PDO::FETCH_ASSOC);
+$id_cons=$row[1];$hondt=$row[2];
 
 // incluso in consiglieri.php, ma io carico le vecchie variabili per compatibilit'a all'indietro
 if($hondt>=1){
 # proiezione consiglio
-      $res = mysql_query("SELECT * FROM ".$prefix."_ele_conf where id_conf='$hondt'", $dbi);
-      $row = mysql_fetch_array($res);
+      $row = $dbi->exec("SELECT * FROM ".$prefix."_ele_conf where id_conf='$hondt'");
+      
       $descrizione_consiglio = $row['descrizione'];
       $LIMITE = intval($row['limite']);