Changeset 360 for trunk/client/file.php

Timestamp:

Mar 14, 2022, 5:13:56 PM (3 years ago)

Author:

roby

Message:

ATTENZIONE: con questa rev viene cambiato il charset che da ora viene impostato su utf8. Fate tutte le vostre verifiche prima di installarla.
Seconda fase di rivisitazione e completamento delle funzioni necessarie per l'accesso al servizio tramite cellulare.
Effettuate alcune sistemazioni per gli avvisi di incongruenza.

File:

• trunk/client/file.php (modified) (4 diffs)

trunk/client/file.php

@@ -3 +3 @@
 include("config.php");
         try{
-        $dbi = new PDO("mysql:host=$dbhost;charset=latin1", $dbuname, $dbpass, array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); 
+        $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);
@@ -11 +11 @@
             echo $sql . "<br>" . $e->getMessage();
         }             
+        $sth = $dbi->prepare("SET NAMES 'utf8'");
+        $sth->execute();
+
+
 $fase=intval($_GET['fase']);
 
@@ -19 +23 @@
         $res->execute();
 
-Header("content-type: application/x-javascript");
+Header("content-type: application/x-javascript; charset=utf-8");
 echo "document.write(\"<b><select name=\'id_cons_gen2\'>";
 
 while(list($id_cons_gen2,$descr) = $res->fetch(PDO::FETCH_NUM)) {
-                        echo "<option value=\'$id_cons_gen2\'>$descr";
+                        echo "<option value=\'$id_cons_gen2\'>$descr</option>";
                 }
                 echo "</select>";
@@ -44 +48 @@
         $res->execute();
 
-Header("content-type: application/x-javascript");
+Header("content-type: application/x-javascript; charset=utf-8");
 echo "document.write(\"<b><input type=\'hidden\' name=\'id_cons_gen2\' value=\'$id_cons_gen2\'><select name=\'id_comune2\'>";
 
 while(list($id_comune2,$descr) = $res->fetch(PDO::FETCH_NUM)) {
-                        echo "<option value=\'$id_comune2\'>$descr";
+                        echo "<option value=\'$id_comune2\'>$descr</option>";
                 }
                 echo "</select>";