How to use backbone.js with php to save data into mysql database

Question

I'm just getting started with backbone.js and I'm working with this tutorial on Nettuts. http://net.tutsplus.com/tutorials/javascript-ajax/getting-started-with-backbone-js/

var user = Backbone.Model.extend({
   initialize: function(){
     console.log('user was initialized!');
   },
   defaults:{
      'name' : 'wern',
      'full_name' : 'rem falkner',
      'password' : 'secret',
      'email' : '[email protected]'
   }
})

var u = new user()

And then I used the save method:

u.save(undefined, {url : 'inserts.php'})

Inserts.php contains:

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

$name = $_POST['name'];
$password = md5($_POST['password']);
$email = $_POST['email'];

$db->query("INSERT INTO tbl_users SET user_id='$name', pword_hash='$password', full_name='$name', email='$email'");
?>

What's wrong with my code? It seems to be inserting in the database because whenever I call the save() method it inserts something on the user table but only in the password field.

Your insert query is wrong. You are doing an update query syntax with insert. INSERT INTO table (fields) VALUES (values) — Tim Withers
– Tim Withers, Commented Apr 15, 2012 at 7:00

rpabon · Accepted Answer · 2012-06-08 12:38:47Z

7

When you call the .save() method a JSON object is sent to the url you have specified; if the model is new, the POST method will be used. When the JSON is received in the PHP script you have to decode it and save the model attributes, let us say one field per attribute. Change this in the 'inserts.php':

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

    $data = json_decode(file_get_contents('php://input'));
    $name = $data->{'name'};
    $password = md5($data->{'password'});
    $email = $data->{'email'};

    //proceed to add every variable to a field in the database
    //...

answered Jun 8, 2012 at 12:38

rpabon

1,2012 gold badges17 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Charitha Goonewardena Over a year ago

this works, but what if i want to fetch() instead of save(). how to retrieve data which are coming from fetch() request? any help would be appreciated. Thanks

fabspro · Accepted Answer · 2012-04-15 07:03:05Z

0

In your PHP code in the line before $db->query, do this:

echo $name, '<br>', $password, '<br>', $email;

Make a traditional HTML form with name password email fields, and test the PHP script, making sure that the name password and email address you entered appears on the screen.

If this succeeds, your error is probably in your database query. For starters, it looks like your code is vulnerable to SQL injections. You will need to post some information about what DBMS you are using (MySQL, MSSQL, PostgreSQL etc). At any rate, the query looks wrong. Also post your CREATE TABLE command.

answered Apr 15, 2012 at 7:03

fabspro

1,67719 silver badges33 bronze badges

2 Comments

Wern Ancheta Over a year ago

I'm using the alternative syntax for inserts. There's nothing wrong with the query, I've already tried executing it on the console.

fabspro Over a year ago

If you had bothered to read my answer, you would understand that I was suggesting debugging the script before the query was even being executed, in case the data was not reaching that point...

Collectives™ on Stack Overflow

How to use backbone.js with php to save data into mysql database

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related