Changeset 282 for trunk/client/temi/tour/index.php

Timestamp:

Apr 21, 2019, 9:46:30 PM (5 years ago)

Author:

roby

Message:

 

File:

• trunk/client/temi/tour/index.php (modified) (3 diffs)

trunk/client/temi/tour/index.php

@@ -61 +61 @@
 if (isset($param['id_comune'])) $id_comune=intval($param['id_comune']); else $id_comune=$siteistat;
 
-$res = mysql_query("SELECT descrizione FROM ".$prefix."_ele_comuni where id_comune='$id_comune' ", $dbi);
-        list($descr_com) = mysql_fetch_row($res);
+$sql="SELECT descrizione FROM ".$prefix."_ele_comuni where id_comune='$id_comune' ";
+$res = $dbi->prepare("$sql");
+$res->execute();
+list($descr_com) = $res->fetch(PDO::FETCH_NUM);
 
 
@@ -163 +165 @@
 // 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 ";
+$result = $dbi->prepare("$sql");
+$result->execute();
+   if ($result->rowCount() == 0) {
         //echo "</div></td></tr></table>";
         
@@ -171 +175 @@
     } else {
         echo "<h5>"._LINK."</h5><p>";
-        while (list($mid, $title, $preamble,$content,  $editimage) = mysql_fetch_row($result)) {
+        while (list($mid, $title, $preamble,$content,  $editimage) = $result->fetch(PDO::FETCH_NUM)) {
                 if ($title != "" && $content != "") {
                         $content = stripslashes($content);