using jQuery ajax method in cakePHP, return id of newly saved data to ajax onSuccess

Question

Im using cakePHP 2.2.1

I have a GoalsController that has an add action in it. This action saves posted data to Goals table.

Inside the add.ctp im using jQuery ajax method to post the form data to above said add action.

What i want is,

ajax method posts form data to goals/add
goals/add action saves data to goals table
Obtain the id of newly inserted row using $this->Goal->id
Return this id back to the onSuccess function of ajax method

Steps 1,2,3 are working fine. But i dont know how to implement step4.

I know php is server side and js is client side and all. Is there anyway i can achieve this?

Dunhamzzz · Accepted Answer · 2012-08-02 12:29:07Z

2

Be sure to read the book entry on Json views and implement something like this:

// Routes.php
Router::parseExtensions('json');

// Controller
$this->set('id', $this->Goal->id);
$this->set('_serialize', array('id'));

// AppController.php
public $components = array('RequestHandler'); // Or add 'RequestHandler' to the existing list.

Then you need to make your ajax post to /goals/add.json, Cake will then recognise the .json extension in combination with the $this->set('_serialize') and return a json string along the lines of { id: 1 }.

Then in your $.ajax function, have a success call like this:

$.ajax({
    url: '/goals/add.json',
    dataType: 'json'
    // other settings
    success: function(response) {
        alert(response.id); // response contains the returned data
    }
});

edited Aug 2, 2012 at 12:29

answered Aug 2, 2012 at 11:30

Dunhamzzz

14.8k4 gold badges54 silver badges74 bronze badges

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

7 Comments

José Lorenzo Rodríguez Over a year ago

Your answer is fine, but don't forget you need to add RequestHandler to your components list

Ivin Over a year ago

@Dunhamzzz Thanks for the reply. I tried what you advised. But im getting 500 Internal error in Firebug console. This is the resonse:

Dunhamzzz Over a year ago

Ah you'll need to make a view file for your action, just an add.ctp in the normal location. Not ideal as you'll never use it (could use it as a non-javascript fallback)

Ivin Over a year ago

@José Lorenzo do i need to create an extra file named add.json for this method to work? I currently have put the form elements and ajax code in the add.ctp file.

Dunhamzzz Over a year ago

Sorry you are right, the strange thing is it's looking for a json view file which I thought it would skip doing as you're using $this->set('_serialize', array('id'));. Try making a View/Goals/json/add.ctp and echo json_encode(compact('id')); inside it

|

Collectives™ on Stack Overflow

using jQuery ajax method in cakePHP, return id of newly saved data to ajax onSuccess

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related