douwen1006 2017-03-30 09:47
浏览 56
已采纳

使用AJAX / PHP将内联CKEditor保存到MySQL

I have a few caption boxes that I want to be able to edit inline and to save these to my database to update a certain record in my table.

For some reason, nothing happens when I click the save button.. not even in the console.

It's just using jQuery at the moment, will I have to use AJAX for this?

If so any tips would be great to point me in right direction as I'm not familiar that much with AJAX.

Here is my code:

index.php

          <div class="caption" id="caption1" contenteditable="true" style="min-height: 450px;">    
           <?php
            $query3 = "SELECT * From (select * from ckeditor ORDER BY id DESC LIMIT 2) AS name ORDER BY id LIMIT 1";
            $show = mysql_query($query3, $con);
            while ($row = mysql_fetch_array($show))
            {
              echo $row['file'];
            }
            ?>
        </div>
        <button type="button" id="save"><span>Save</span></button>
            <script>
               $(document).ready(function (e) {

                  $("#save").click(function (e) {
                      var data = CKEDITOR.instances.caption1.getData();
                      var options = {  
                           url: "save.php",
                          type: "post",
                          data: { "editor" : encodeUriComponent(data) },
                         success: function (e) {
                           echo "Succesfully updated!";
                         }
                       };
                  }
               });
            </script>
      </div>

save.php

     <?php
$connection = mysql_connect("localhost", "", ""); 
$db = mysql_select_db("castle", $connection); 
//Fetching Values from URL
$data = nl2br($_POST['caption1']);
//Insert query
$query ="INSERT INTO `ckeditor`(`file`) VALUES ('$data')";
echo "Form Submitted Succesfully";
mysql_close($connection);
?>
  • 写回答

1条回答 默认 最新

  • doulianglou0898 2017-03-30 09:54
    关注

    You need to send the data to the server like this;

    $.ajax({
       url: "save.php",
       data: {
          "editor" : encodeUriComponent(data)
       },
       error: function() {
          //Error
       },
       success: function(data) {
          //Success
       },
       type: 'POST'
    });
    

    Currently you are just creating an object called 'options'

    Your code should look like this;

    $("#save").click(function (e) {
      var data = CKEDITOR.instances.caption1.getData();
      $.ajax({
       url: "save.php",
       data: {
           "editor" : encodeUriComponent(data)
       },
       error: function() {
          //Error
       },
       success: function(data) {
          alert('Success');
       },
       type: 'POST'
    });
    

    }

    Just a side note, 'echo' doesn't work in js. You need to use 'alert()' or 'console.log()'

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 thinkphp适配人大金仓问题
  • ¥15 有卷积神经网络识别害虫的项目吗
  • ¥15 数据库数据成问号了,前台查询正常,数据库查询是?号
  • ¥15 算法使用了tf-idf,用手肘图确定k值确定不了,第四轮廓系数又太小才有0.006088746097507285,如何解决?(相关搜索:数据处理)
  • ¥15 彩灯控制电路,会的加我QQ1482956179
  • ¥200 相机拍直接转存到电脑上 立拍立穿无线局域网传
  • ¥15 (关键词-电路设计)
  • ¥15 如何解决MIPS计算是否溢出
  • ¥15 vue中我代理了iframe,iframe却走的是路由,没有显示该显示的网站,这个该如何处理
  • ¥15 操作系统相关算法中while();的含义