Laravel and Jquery: Help with error NotFoundHttpException in RouteCollection.php line 161:

Question

Laravel and Jquery: Help with error NotFoundHttpException in RouteCollection.php line 161:

Navigation

#1 by (1 votes)

1

I am using this jquery plugin, jQuery Plugin For Editable Table Rows - Table Edits , to make editable tables in an application made in Laravel but I have the following problem: When I want to send the data of the record that I want to edit through ajax I get the error NotFoundHttpException in RouteCollection.php line 161: I understand that this has to do with the definition of the routes, but in the route.php file if they are defined and I also tried to define a specific route to access the update method directly but it did not work either. I hope you can help me. Greetings and thanks in advance.

html

<!DOCTYPE html>
<html>
    <head>
        <title>Laravel</title>

 <meta name="viewport" content="width=device-width, initial-scale=1">
     <link rel="stylesheet" href="{{ URL::asset('components/bootstrap/dist/css/bootstrap.css') }}">
    <link rel="stylesheet" href="{{ URL::asset('components/datatables.net-bs/css/dataTables.bootstrap.min.css') }}">
     <link rel="stylesheet" type="text/css" href="{{ URL::asset('components/datatables.net-bs/css/editor.bootstrap.css')}}">
     <link rel="stylesheet" type="text/css" href="{{ URL::asset('components/datatables.net-bs/css/editor.dataTables.css')}}">

    </head>
    <body>
          <h1>Ejemplo de Edici&oacute;n en el lugar con jQuery</h1>

<div class="container">
              <div class="mensaje"></div>
  <table class="table tablaEdit" id="tablaEditable">
    <thead>
      <tr>

        <th>Nombre</th>
        <th>Apellidos</th>
        <th>Email</th>
        <th>Telefono</th>
      </tr>
    </thead>


    <tbody>
       @foreach($tablas as $tabla) 
      <tr data-id="{{$tabla->id}}">

        <td id="nombre" class="tvalor" data-field="nombre"> {{ $tabla->nombre}}</td>
        <td id="apellidos" data-field="apellidos"> {{ $tabla->apellidos }}</td>
        <td id="email" data-field="email"> {{ $tabla->email }}</td>
        <td id="telefono" data-field="telefono"> {{ $tabla->telefono }}</td>

      </tr>

      @endforeach
    </tbody>
  </table>
</div>

<script type="text/javascript" src="https://code.jquery.com/jquery-1.12.3.js"> </script>
<script type="text/javascript" src="{{ URL::asset('components/bootstrap/dist/js/bootstrap.js') }}"> </script>
      <script type="text/javascript" src="{{ URL::asset('js/script.js') }}"></script>

  <script type="text/javascript" src="{{ URL::asset('js/table-edits.js') }}"></script>

  <script type="text/javascript" src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.js"></script>

    <script type="text/javascript" src="https://cdn.datatables.net/v/dt/dt-1.10.12/datatables.min.js"></script>


 <script type="text/javascript" src="{{ URL::asset('components/datatables.net-bs/js/dataTables.bootstrap.min.js') }}"></script>
    </body>
</html>

jQuery

    $(document).ready(function(){

    $("#tablaEditable tr").editable({

  keyboard: true,
  dblclick: true,
  button: true,
  buttonSelector: ".edit",
  dropdowns: {},
  maintainWidth: true,


  save: function(values) {
  var idusuario = $(this).data('idusuario'); //captura el id en la tabla

     $.ajax({
            url: '/editar/' + idusuario,
            data: values,  
            type: "PUT",
            dataType: 'json',
            success: function (data) {
                  alert("Editado");
            }

        });

  }

});


    });

Routes

 Route::put('/editar/{idusuario}', 'TablaController@update');

Route::resource('/', 'TablaController' , ['except' => ['update']]);

list of routes:

Error in console:

UPDATE: Fixed, I had a couple of errors in the definition of the model and I also removed the JSON.stringfy function from jQuery since it was not very useful.

jquery ajax laravel

asked by DiegoWL 29.11.2016 в 21:25

source

1 answer

JOB failed to run SSIS package How do I enable a column to insert records and save it c # gridcontrol devexprees

score 1 · Accepted Answer

The correct definition of the route should include the model parameter (id normally):

Route::post('/editar/{id}', 'TablaController@update');

In fact you could use Route Model Binding to have Laravel automatically load the model with the route .

But to be able to use that independent route you should NOT generate the route when you use the resource() method, otherwise you will have redundant routes and this can cause problems:

Route::resource('/', 'TablaController', ['except' => ['update']]);

If you only use Route::resource() , you should bear in mind that the verb that uses the update() method is PUT and not POST (you can see it in the list of routes you published).