douhuang1973 2013-09-27 21:29
浏览 98

php - X-Editable-Bootstrap不更新数据库

I am using X-Editable-Bootstrap to do some inline editing. Everything works but it's not updating the DB so I am wondering if I am doing something wrong.

Here's my post.php

require_once("config.php");
    $pk = $_POST['pk'];
    $name = $_POST['name'];
    $value = $_POST['value'];

    if(!empty($value)) {
        try {
            $dbh = new PDO('mysql:host='. DB_HOST .';dbname='. DB_NAME, DB_USER, DB_PASS);
            $sth = $dbh->prepare('UPDATE qa_tbl SET ?=? WHERE id = ?');
            $sth->execute(array($name,$value,$pk));
        } catch (PDOException $e) {
            print "Error!: " . $e->getMessage() . "<br/>";
            die();
        }
        print_r($_POST);
    } else {
        header('HTTP 400 Bad Request', true, 400);
        echo "This field is required!";
    }

Here's the response body from FireFox debugging:

Array
(
    [name] => Question
    [value] => Yes
    [pk] => 2
)

JavaScript:

    $(function(){
        $.fn.editable.defaults.mode = 'inline';
        $('.editcontent').editable({
            url: 'post.php',
            title: 'Modify Entry'
        });
    });
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 数学建模,尽量用matlab回答,论文格式
    • ¥15 昨天挂载了一下u盘,然后拔了
    • ¥30 win from 窗口最大最小化,控件放大缩小,闪烁问题
    • ¥20 易康econgnition精度验证
    • ¥15 msix packaging tool打包问题
    • ¥28 微信小程序开发页面布局没问题,真机调试的时候页面布局就乱了
    • ¥15 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能