Retrieve Values form Jquery Ajax Json in Laravel 4

Question

I'm trying to retrieve data from an Jquery Plugin which uses Ajax and Json in Laravel 4

The Plugin part is in the view customer.blade.php:

<script>
var $container = $("#dataTable");
var $console = $("#example1console");

  var data = {{ $content }};
  $("#dataTable").handsontable({
    data: data,
    startRows: 6,
    startCols: 8,
    rowHeaders: true,
    colHeaders: [{{ $title }}]
  });

var handsontable = $container.data('handsontable');

$container.parent().find('button[name=save]').click(function () {
    //alert('we are trying to save');
  $.ajax({
    url: "/",
    data: {"data": 'demo data'}, //handsontable.getData()}, //returns all cells' data
    dataType: 'json',
    type: 'POST',
    success: function (res) { console.log(res); alert(res); }
   /* error: function () {
      $console.text('Save error. POST method is not allowed on GitHub Pages. Run this example on your own server to see the success message.');
    }*/
  });
});
</script>

in Routes.php i have:

// here i wanna send json data to plugin and render the view 
Route::get('/', 'CustomerController@getIndex');
// here i wanna retrieve the  json-data from the plugin and save it later in db
Route::post('/', 'CustomerController@postSave');

in Controller i have:

public function getIndex() {
    //$cust = Customer::get()->toJson();
    //$cust = InformationDB::select('Column_Name')->where('table_name', '7_0 - CRONUS (ai-Patches) AG$Customer')->get()->toJson();

    // Get Columns
    $cust = Customer::select('Name', 'City')->get()->toJson();
    // Get Columns Title
    $getTitle = Customer::select('Name', 'City')->first()->toJson();
    $title = implode(', ',array_keys(json_decode($getTitle, true)));
    $title4js = "'" . str_replace(",", "','", $title) . "'";
    // Render View
    return View::make('customer/customer', array('content' => $cust, 'title' => $title4js));
}

public function postSave() {
    $t = Input::all(); 
    return $t;
}

Maybe someone knows what i'm doing wrong?

nothing, i even can see chromedevtool->network a new connection to localhost, when i' click on the save button and in the header-information my json data i which i would like to save.. — user2834172
– user2834172, Commented Oct 1, 2013 at 9:29
Use this $.ajax({ url: "/laranav/public/", data: {"data": 'demo data'}, //returns all cells' data dataType: 'json', type: 'POST', success: function (res) { console.log(res); alert(res); } }); and now what you are getting? any error? — Anshad Vattapoyil
– Anshad Vattapoyil, Commented Oct 1, 2013 at 9:38
from controller use this public function postSave() { $t = Input::all(); return $t; } — Anshad Vattapoyil
– Anshad Vattapoyil, Commented Oct 1, 2013 at 9:39
sadly not everything is like before, just nothing happens, only the connection apperas on every klick on save... — user2834172
– user2834172, Commented Oct 1, 2013 at 9:45

Anshad Vattapoyil · Accepted Answer · 2013-10-01 10:41:51Z

2

In your ajax post request, Instead of

url: "/",

You have to use,

url: "/laranav/public/",

The laranav will be your project directory.

answered Oct 1, 2013 at 10:41

Anshad Vattapoyil

23.5k19 gold badges90 silver badges134 bronze badges

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

3 Comments

Anshad Vattapoyil Over a year ago

@user2834172 You are welcome, you can ask if you have any other doubts.

user2834172 Over a year ago

should i make a new question? from the retrieved json i wanna save it now in the db

public function postSave() { 		//$t = Input::all(); 		$t = Input::get('Name'); 		$c = Customer::find('DKT000142'); 		$c->Name = $t; 		$c->save(); 		//return $t; 	}

gives status error 500

Anshad Vattapoyil Over a year ago

make a new question and you should explain the error string you got when expanding the request url in console and explain table field names.

Collectives™ on Stack Overflow

Retrieve Values form Jquery Ajax Json in Laravel 4

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related