个人中心
gpt4 book ai didi

php - 执行查询时出错

转载 作者：行者123 更新时间：2023-11-29 14:08:01 24 4
gpt4 key购买 nike

我试图通过弹出窗口更新我的网站内容。我根据 ID 显示内容，但当我尝试提交时，弹出窗口中出现错误

An error occurred upon executing query. Please notify the web developer about this error.

NOTE: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE textID=16' at line 1

我似乎找不到这个错误。你能看到吗？

这是我的完整代码:

    <!-- PHP -->
<?
    include('global.php');

    if(isset($_REQUEST['textID']))
        $textID = $_REQUEST['textID'];      
    if(isset($_REQUEST['textContent']))
        $textContent = $_REQUEST['textContent'];

            if($_POST){
            $query = "UPDATE text_tb SET ";
            $query = $query."textContent='".$textContent."', ";
            $query = $query."WHERE textID=".$textID.""; 
            //echo $query;
            ExecuteQuery($query);
            echo "<script type=\"text/javascript\">
                <!--
                window.close();
                //-->
                </script>";
            }
?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Full featured example</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<!-- TinyMCE -->
<script type="text/javascript" src="../jscripts/tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
    tinyMCE.init({
        // General options
        mode : "textareas",
        theme : "advanced",
        plugins : "autolink,lists,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave,visualblocks",

        // Theme options
        theme_advanced_buttons1 : "newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,fontselect,fontsizeselect",
        theme_advanced_buttons2 : "bullist,numlist,|,undo,redo,|,link,unlink,|,forecolor",
        theme_advanced_toolbar_location : "top",
        theme_advanced_toolbar_align : "left",
        theme_advanced_statusbar_location : "bottom",
        theme_advanced_resizing : false,

        // Example content CSS (should be your site CSS)
        content_css : "css/content.css",

        // Drop lists for link/image/media/template dialogs
        template_external_list_url : "lists/template_list.js",
        external_link_list_url : "lists/link_list.js",
        external_image_list_url : "lists/image_list.js",
        media_external_list_url : "lists/media_list.js",

        // Style formats
        style_formats : [
            {title : 'Bold text', inline : 'b'},
            {title : 'Red text', inline : 'span', styles : {color : '#ff0000'}},
            {title : 'Red header', block : 'h1', styles : {color : '#ff0000'}},
            {title : 'Example 1', inline : 'span', classes : 'example1'},
            {title : 'Example 2', inline : 'span', classes : 'example2'},
            {title : 'Table styles'},
            {title : 'Table row 1', selector : 'tr', classes : 'tablerow1'}
        ],
    });
</script>
<!-- /TinyMCE -->

</head>
<body role="application">

<form method="post" action="<?php $_PHP_SELF ?>">
    <div>
                <!-- Gets replaced with TinyMCE, remember HTML in a textarea should be encoded -->
        <div>
            <textarea id="textContent" name="textContent" rows="15" cols="80" style="width: 80%">
            <?
            $result = mysql_query("SELECT * FROM text_tb WHERE textID ='".$textID."'");
                                while($row = mysql_fetch_array($result)){
                                    echo $row['textContent'];
                                }
            ?>
            </textarea>
        </div>

        <!-- Some integration calls
        <a href="javascript:;" onclick="tinyMCE.get('textContent').show();return false;">[Show]</a>
        <a href="javascript:;" onclick="tinyMCE.get('textContent').hide();return false;">[Hide]</a>-->
        <br />
        <input type="submit" name="save" value="Submit" />
        <input type="reset" name="reset" value="Reset" />
    </div>
</form>

<!--<script type="text/javascript">
if (document.location.protocol == 'file:') {
    alert("The examples might not work properly on the local file system due to security settings in your browser. Please use a real webserver.");
}
</script>-->
</body>
</html>

最佳答案

问题出在集合末尾的逗号。更改此行:

        $query = $query."textContent='".$textContent."', ";

至:

        $query = $query."textContent='".$textContent."' ";

关于php - 执行查询时出错，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/14044540/

24 4 0
文章推荐： php - 如果 true 使用 foreach 循环，否则使用 while
文章推荐： PostgreSQL: "timestamp with time zone"和 "at time zone"的别名
文章推荐： sql - 在已插入非唯一值后在 PostgreSQL 表列上强制执行唯一性
文章推荐： android - 将我数据库中的 GPS 位置与当前位置进行匹配
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com