prepare('SELECT id,titel,html,datum,actief,type FROM nieuws WHERE id = ?'); $stmt->bind_param('s', $nav[1]); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($pid,$etitel,$ehtml,$edatum,$eactief,$etype); ?>
fetch()) { $query2 = "SELECT filename,original_path FROM `foto` WHERE pid = '$pid' AND type = 'N' AND nr = '1'"; $result2 = mysqli_query($GLOBALS["___mysqli_ston"], $query2); list ($filename,$original_path) = mysqli_fetch_row($result2); if (!$filename) { $filename = $host."img/building.jpg"; } else { $filename= $host.str_replace("../../../../","",$filename); } $original_path = $host.str_replace("/cms/elfinder/php/../../../","",$original_path); ?>

Archief

'".((isset($GLOBALS["___mysqli_ston"]) && is_object($GLOBALS["___mysqli_ston"])) ? mysqli_real_escape_string($GLOBALS["___mysqli_ston"], $nav[1]) : ((trigger_error("[MySQLConverterToo] Fix the mysql_escape_string() call! This code does not work.", E_USER_ERROR)) ? "" : ""))."00' AND datum < '".((isset($GLOBALS["___mysqli_ston"]) && is_object($GLOBALS["___mysqli_ston"])) ? mysqli_real_escape_string($GLOBALS["___mysqli_ston"], $nav[1]) : ((trigger_error("[MySQLConverterToo] Fix the mysql_escape_string() call! This code does not work.", E_USER_ERROR)) ? "" : ""))."32' AND startdatum <= '".date("Ymd")."' AND einddatum >= '".date("Ymd")."' AND actief = 1 ORDER BY datum"; $result = mysqli_query($GLOBALS["___mysqli_ston"], $query); } else { $query = "SELECT id,titel,html,datum,actief,type,startdatum,einddatum FROM `nieuws` WHERE startdatum <= '".date("Ymd")."' AND einddatum >= '".date("Ymd")."' AND actief = 1 ORDER BY datum DESC LIMIT 0,9"; $result = mysqli_query($GLOBALS["___mysqli_ston"], $query); } ?>

Archief