将 Backbone.js 模型插入 MySQL 数据库 [英] Insert Backbone.js model into MySQL database

问题描述

我有一个带有一些默认值和一个 url 的backbone.js 模型:

I have a backbone.js model with some defaults and an url:

var Box = Backbone.Model.extend({
    url: "./save.php",
    defaults: {
        x: 0,
        y: 0,
        w: 1,
        h: 1
    }
});

然后我有一个这个模型的实例，我继续保存它:

Then I have an instance of this model and I proceed to save it:

var box = new Box({ x:10, y:10, w:200, h:200 });
box.save();

现在我想使用 PHP 脚本save.php"将此模型保存到 MySQL 数据库中，它是这样的:

Now I want to save this model into a MySQL database using a PHP script "save.php", it goes like this:

<?php 
    include('connection.php');

    $id = $_POST['cid'];
    $x = $_POST['x'];
    $y = $_POST['y'];
    $w = $_POST['w'];
    $h = $_POST['h'];

    mysql_query("INSERT INTO boxes (id, x, y, w, h)
                         VALUES('$id', '$x', '$y', '$w', '$h')
                       ") or die(mysql_error());
?>
echo "Data Inserted!";

我试过阅读很多教程，但我无法将这个简单的模型保存起来.为什么我的代码不起作用?关于如何解决这个问题的任何想法?

I have tried reading many tutorials but I cannot get this simple model save to work. Why is my code not working? Any ideas on how can this be solved?

谢谢

快速解决方案

在php脚本中，从发送的JSON对象中获取信息的正确方式如下:

In the php script, the correct way to obtain the information from the sent JSON object is as follows:

$box_data = json_decode(file_get_contents('php://input'));
$x = $box_data->{'x'};
$y = $box_data->{'y'};
$w = $box_data->{'w'};
$h = $box_data->{'h'};

并存入数据库:

mysql_query("INSERT INTO boxes(id, x, y, w, h)
            VALUES('', '$x', '$y', '$w', '$h') ") 
or die(mysql_error());

这样一来，就会在boxes"表中插入一行，其中包含主干模型Box的每个属性的信息.本例中的服务器请求方式为POST，表boxes"中的id设置为自增.

In this way one row will be inserted in the table "boxes" with the information of each one of the attributes of the backbone model Box. The server request method in this case is POST and the id in the table "boxes" is set to auto-increment.

推荐答案

Backbone 基于 REST API:当将模型保存/更新到服务器时，Backbone 会将其序列化为 JSON 发送到请求正文中，并带有 POST 我们的 PUT 请求.来自 Backbone.sync 文档

Backbone is based on a REST API: when saving/updating a model to the server, Backbone will send it serialized as JSON in the request body with a POST our PUT request. From Backbone.sync documentation

使用默认实现，当 Backbone.sync 发送请求时保存模型，它的属性将被传递，序列化为 JSON，并在内容类型为 application/json 的 HTTP 正文中发送.

With the default implementation, when Backbone.sync sends up a request to save a model, its attributes will be passed, serialized as JSON, and sent in the HTTP body with content-type application/json.

这意味着你必须在服务器端

This means that server-side you have to

• 确定请求的类型
• 解码序列化的 JSON

这样的事情应该会让你开始

Something like this should get you started

$request_method = strtolower($_SERVER['REQUEST_METHOD']);
$data = null;

switch ($request_method) {
    case 'post':
    case 'put':
        $data = json_decode(file_get_contents('php://input'));
    break;
}

// print_r($data);

// note that mysql_* functions are deprecated
// http://php.net/manual/en/function.mysql-query.php
// inserting with a PDO object, assuming an auto incremented id
$sql = "INSERT INTO boxes (x, y, w, h) VALUES(?, ?, ?, ?)";
$sth = $dbh->prepare($sql);
$sth->execute(array(
    $data->x,
    $data->y,
    $data->w,
    $data->h
));
$id = $dbh->lastInsertId();

查看此页面以了解更全面的 PHP REST API 实现 http://www.gen-x-design.com/archives/create-a-rest-api-with-php/

Check this page for a more thorough implementation of a REST API in PHP http://www.gen-x-design.com/archives/create-a-rest-api-with-php/

这篇关于将 Backbone.js 模型插入 MySQL 数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！