Changeset 257 for trunk/admin/modules/Elezioni/query.sql

Timestamp:

Feb 9, 2019, 8:45:24 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/admin/modules/Elezioni/query.sql (modified) (4 diffs)

trunk/admin/modules/Elezioni/query.sql

@@ -45 +45 @@
         $sth = $dbi->prepare("$sql");
         $sth->execute();        
-        $row = $sth->fetchAll();
+        $row = $sth->fetch(PDO::FETCH_BOTH);
         return ($row);
 
@@ -78 +78 @@
         $sth = $dbi->prepare("$sql");
         $sth->execute();        
-        $row2 = $sth->fetchAll();
-    if ($row2) $id_cons = $row2['id_cons']; 
+    if ($sth->rowCount()) list($id_cons) = $sth->fetch(PDO::FETCH_NUM); 
         else    $espandi=1;
         if(!isset($tipo_cons))$tipo_cons=0;
@@ -87 +86 @@
         $sth = $dbi->prepare("$sql");
         $sth->execute();        
-        $row2 = $sth->fetchAll();
-        $limite=$row2[0];
+        if ($sth->rowCount()){
+                $row2 = $sth->fetchAll();
+                $limite=$row2[0];
+        }
         return($row);
 }
@@ -187 +188 @@
         $sth = $dbi->prepare("$sql");
         $sth->execute();        
-        $row = $sth->fetchAll();
+        $row = $sth->fetch(PDO::FETCH_BOTH);
         return($row);
 }