Changeset 257 for trunk/admin/temi/facebook/index.php

Timestamp:

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

Author:

roby

Message:

 

File:

• trunk/admin/temi/facebook/index.php (modified) (2 diffs)

trunk/admin/temi/facebook/index.php

@@ -95 +95 @@
 // Blocco link
 
-$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";
+        $sth = $dbi->prepare("$sql");
+        $sth->execute();        
+        $row = $sth->fetchAll();
+    if ($sth->rowCount() == 0) {
         echo "</td></tr></table>";
         echo "</div></td><td>";
@@ -103 +106 @@
     } else {
         echo "<h5>"._LINK."</h5><p>";
-        while (list($mid, $title, $preamble,$content,  $editimage) = mysql_fetch_row($result)) {
+        foreach($row as $row2) {
+                list($mid, $title,$preamble,$content,$editimage) = explode($row2)) {
                 if ($title != "" && $content != "") {
                         $content = stripslashes($content);