首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >所见即所得文本编辑器在查询中显示不好

所见即所得文本编辑器在查询中显示不好
EN

Stack Overflow用户
提问于 2016-08-03 04:09:46
回答 1查看 29关注 0票数 0

我在将CKeditor集成到我的内容管理系统时遇到了一个问题,当我将一些文本复制到查询中时,会在

,然后,如果尝试删除这些状态,在我删除它之后,会在more <\h2> <\p>页面上显示我

代码语言:javascript
复制
<\p>

 <\p>

 <\p>

 <\p>

page.php

代码语言:javascript
复制
// Query the body section for the proper page
    $stmt = $con->prepare('SELECT pagebody FROM travel WHERE link = ?');
    $stmt->bind_param('s', $pageid);
    $stmt->execute();
    $result = $stmt->get_result();
    while ($row = $result->fetch_array()) {
        // do something with $row
        $body = htmlspecialchars_decode(stripslashes($row['pagebody'])); //pentru caractere speciale

    } <?php echo $body; ?>

//edit_page

代码语言:javascript
复制
<?php
// You may want to obtain refering site name that this post came from for security purposes here
// exit the script if it is not from your site and script
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$pid = $_POST['pid'];
$titlu = $_POST['titlu'];
$link = $_POST['link'];
$keyword = $_POST['keyword'];
$poza = $_POST['poza'];
$descriere = $_POST['descriere'];
$data = $_POST['data'];
$pagebody = $_POST['pagebody'];
// Filter Function -------------------------------------------------------------------
function filterFunction ($var) { 
    $var = nl2br(htmlspecialchars($var));
    $var = str_replace("/", "\\\\", $var);
    $var = preg_replace("~/~", "\\\\", $var);

    return $var; 
} 
$titlu = filterFunction($titlu);
$link = filterFunction($link);
$keyword = filterFunction($keyword);
$poza = filterFunction($poza);
$descriere = filterFunction($descriere);
$data = filterFunction($data);
$pagebody = filterFunction($pagebody);
// End Filter Function --------------------------------------------------------------
include_once "../conx.php";
// Add the updated info into the database table
$stmt = $con->prepare("UPDATE travel SET titlu=?, link=?, keywords=?, poza=?, descriere=?, pagebody=?, data=? WHERE id = ?");
    // TODO check that $stmt creation succeeded
    // "s" means the database expects a string
    $stmt->bind_param("ssssssss", $titlu, $link, $keyword, $poza, $descriere, $pagebody, $data, $pid);
    $stmt->execute();
    $stmt->close();
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2016-08-03 04:43:55

这要归功于PHP代码中的这一行:

代码语言:javascript
复制
 $var = str_replace("/", "\\\\", $var);
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/38729581

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档