Changeset 381 for trunk/install/install2.php

Timestamp:

Oct 28, 2022, 7:14:26 PM (2 years ago)

Author:

roby

Message:

INSTALL
adeguamento php5
ADMIN
continua elaborazione funzione di aggiornamento

File:

• trunk/install/install2.php (modified) (4 diffs)

trunk/install/install2.php

@@ -52 +52 @@
         }
 $dsn = "mysql:host=$DBhostname"; #dbname=$DBname";
-$opt = [
-PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
-PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
-PDO::ATTR_EMULATE_PREPARES => false,
-];
+$opt = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false);
 $user=$DBuserName;
 $password=$DBpassword;
@@ -66 +62 @@
                 $database = new PDO($dsn, $user, $password, $opt);
          }
-        catch(PDOException $e)
-        {
-            echo $sql . "<br>" . $e->getMessage();die();
-        }
-#sostituire questa riga con le variabili per il nuovo utente e la sua password da inserire nella pagina precedente
-########################################
-#               $DBuserName='eleuser'; $DBpassword='elepass';
+        catch(PDOException $e)
+        {
+                echo $sql . "<br>" . $e->getMessage();die();
+        }
         try{
         $sql = "CREATE DATABASE IF NOT EXISTS $DBname;";
@@ -81 +74 @@
             echo $sql . "<br>" . $e->getMessage();die();
         }
-        try {
-        $sql="CREATE USER if not exists `$ELEuserName`@'$DBhostname' IDENTIFIED BY '$ELEpassword';";
-        $database->exec($sql);
-#        $sql= "GRANT ALL ON `$DBname`.* TO `roby`@'$DBhostname';";
-#       $database->exec($sql);
-        $sql= "GRANT ALL ON `$DBname`.* TO `$ELEuserName`@'$DBhostname';";
-        $database->exec($sql);
-        $sql= "FLUSH PRIVILEGES;";
-        $database->exec($sql);
-        $sql = "use $DBname";
-        $database->exec($sql);
+        if(phpversion()>="5.7.6") 
+        {
+                try {
+                        $sql="CREATE USER if not exists '$ELEuserName'@'$DBhostname' IDENTIFIED BY '$ELEpassword';";
+                        $database->exec($sql);
+                }
+                catch(PDOException $e)
+                {
+                        echo $sql . "<br>" . $e->getMessage();die();
+                }                       
+                try {
+                        $sql= "GRANT ALL ON `$DBname`.* TO `$ELEuserName`@'$DBhostname';";
+                        $database->exec($sql);
+                }
+                catch(PDOException $e)
+                {
+                        echo $sql . "<br>" . $e->getMessage();die();
+                }
+        }else{
+                try {
+                        $sql="grant all on `$DBname`.* TO  '$ELEuserName'@'$DBhostname' IDENTIFIED BY '$ELEpassword';";
+                        $database->exec($sql);
+                }
+                catch(PDOException $e)
+                {
+                        echo $sql . "<br>" . $e->getMessage();die();
+                }               
+        }
+        $sql= "FLUSH PRIVILEGES;";
+        $database->exec($sql);
+        $sql = "use $DBname";
+        $database->exec($sql);
         $sql = file_get_contents('sql/eleonline.sql');
         $qr = $database->exec($sql);
         $DBcreated = 1;
-        }
-        catch(PDOException $e)
-        {
-            echo $sql . "<br>" . $e->getMessage();die();
-        }
 }
 
@@ -322 +331 @@
                                         <td width="100">Numero Istat</td>
                                         <td align="left"><input class="inputbox" type="text" name="istat" size="6" value="<?php echo "{$configArray['istat']}"; ?>" />
-                                        <a href="http://www.istat.it/strumenti/definizioni/comuni/" target="_blank">Preleva i codici Istat dei comuni italiani</a>
+                                        <a href="https://www.istat.it/it/archivio/6789" target="_blank">Preleva i codici Istat dei comuni italiani</a>
                                         </td><td></td>
                                 </tr>