Changeset 362 for trunk/client/modules.php

Timestamp:

Mar 27, 2022, 7:51:34 PM (3 years ago)

Author:

roby

Message:

Ritocchi e sistemazioni varie di completamento delle mofifiche precedenti

File:

• trunk/client/modules.php (modified) (1 diff)

trunk/client/modules.php

@@ -99 +99 @@
 
 
-$dbi = new PDO("mysql:host=$dbhost;charset=latin1", $dbuname, $dbpass, array(PDO::ATTR_EMULATE_PREPARES => false, 
+$dbi = new PDO("mysql:host=$dbhost;charset=utf8", $dbuname, $dbpass, array(PDO::ATTR_EMULATE_PREPARES => false, 
                                                                                                 PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION));    
 $sql = "use $dbname";
 $dbi->exec($sql);
+        $sth = $dbi->prepare("SET SESSION character_set_connection = 'utf8' ");
+        $sth->execute();
+        $sth = $dbi->prepare("SET SESSION character_set_client = 'utf8' ");
+        $sth->execute();
+        $sth = $dbi->prepare("SET SESSION character_set_database = 'utf8' ");
+        $sth->execute();
+        $sth = $dbi->prepare("SET CHARACTER SET utf8");
+        $sth->execute();
+
+        $sth = $dbi->prepare("SET NAMES 'utf8'");
+        $sth->execute();
 
 # protezione csrf ottobre 2012 - by l.apolito