Changeset 253 for trunk/admin/index.php

Timestamp:

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

Author:

roby

Message:

 

File:

• trunk/admin/index.php (modified) (1 diff)

trunk/admin/index.php

@@ -8 +8 @@
 /************************************************************************/
 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);
+        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();
+        }                                                                                               
 //---10/05/2009  gestione consultazione predefinita
 //if (!isset($_SESSION['id_comune'])){
-                $res_config = mysql_query("select * from ".$prefix."_config ",$dbi);
-                list ($sitename,$siteurl,$site_logo,$slogan,$startdate,$adminmail,$tema,$foot,$language,$blocco,$testata,$logo,$fileout,$copyright,$versione,$patch,$id_comune) = mysql_fetch_row($res_config);
-                $siteistat=$id_comune;
+        $sth = $dbi->prepare("select * from ".$prefix."_config");
+        $sth->execute();
+        
+        $row = $sth->fetch(PDO::FETCH_ASSOC);
+#               list ($sitename,$siteurl,$site_logo,$slogan,$startdate,$adminmail,$tema,$foot,$language,$blocco,$testata,$logo,$nometestata,$fileout,$copyright,$versione,$patch,$id_comune,$multicomune,$flash,$displayerrors,$gkey,$googlemaps,$editor,$tema_on,$ed_user) = ($res_config->fetch());
+                $siteistat=$row['siteistat'];
 //}
     Header("Location: admin.php?id_comune=$siteistat");