Changeset 265 for trunk/client/modules/Elezioni/blocchi/bloccolink.php

Timestamp:

Apr 13, 2019, 8:05:15 PM (5 years ago)

Author:

roby

Message:

 

File:

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

trunk/client/modules/Elezioni/blocchi/bloccolink.php

@@ -3 +3 @@
 
 global $genere,$id_cons_gen,$id_cons,$id_comune,$prefix,$dbi;
-$result = mysql_query("select mid, title, preamble, content,editimage from ".$prefix."_ele_link where id_cons='$id_cons' order by mid ", $dbi);
-    if (mysql_num_rows($result) == 0) {
+        $sql="select mid, title, preamble, content,editimage from ".$prefix."_ele_link where id_cons='$id_cons' order by mid ";
+        $res = $dbi->prepare("$sql");
+        $res->execute();
+
+    if ($res->rowCount() == 0) {
         return;
     } else {
         echo "<h5>"._LINK."</h5><p>";
-        while (list($mid, $title, $preamble,$content,  $editimage) = mysql_fetch_row($result)) {
+        while (list($mid, $title, $preamble,$content,  $editimage) = $res->fetch(PDO::FETCH_NUM)) {
                 if ($title != "" && $content != "") {
                         $content = stripslashes($content);