Laravel, cant fill empty table

can you dd your return $html?

it not showing the dd result

I would debug the Ajax. Sounds like it's posting nothing. I guess you should do error checking. Spin open your browser inspection tools. See if you're geting any errors

Is that blade syntax correct? What does the DOM tree look like?

@tomatoblob In your AJAX request, try double curly braces for the id variable:

$.ajax({
          url: 'applicants/create/{{ $id }}',
          type: 'GET',
          data: { id:  $(this).val() },
          success: function(response)
          {
               $('#subjectData tbody').html(response);
          }
      });

it says "Use of undefined constant id - assumed 'id' (this will throw an Error in a future version of PHP)"

@flightsimmer668 change it to this:

$.ajax({
          url: 'applicants/create/',+ $(this).val()
          type: 'GET',
          data: { id:  $(this).val() },
          success: function(response)
          {
               $('#subjectData tbody').html(response);
          }
      });

then it showed this error in the browser console: GET http://127.0.0.1:8000/admin/applicants/applicants/create/2?id=2 404 (Not Found)

Hard code a value first In you end point. Wait, shouldnt you be posting and not getting?

@antlusher tried posting but it still showed the same error jquery.min.js:2 POST http://127.0.0.1:8000/admin/applicants/create/2 404 (Not Found).

Your Route is GET not POST

It was using GET earlier?

Test the controller separately as well.

What does putting http://127.0.0.1:8000/admin/applicants/create/2 in your browser address bar return?

change

        $result = Subject::all()->where('course_ID', $id);

to

        $result = Subject::where('course_ID', $id)->get();

in this loop

        foreach($result as $row)
        {
            $html =
                '<tr>
                    <td>' . $row->subj_code . '</td>' .
                    '<td>' . $row->subj_code . '</td>' .
                '</tr>';
        }
        return $html;
        }

you overwrite $html every time around the loop. You need to use $html += to concatenate to the variable.

@snapey yes i was using GET, controller works fine, it shows error 404 page not found. i think im routing my controllers the wrong way and i can't seem to correct it.

EDIT: I've implemented your changes but it still showed the same error.

I've always taken the hardcode approach first, then once I can insure everything is linking up, then I would do the logic.

Step through from the start - make sure the Controller is getting a value, then the route, then the POST, and then the handler thats receiving the POST data. I can't see your update table SQL logic?!

@antlusher The empty table that needs filling is an HTML one. This is not about storing data

controller works fine, it shows error 404 page not found.

Somewhat of a contradiction?

Try this:

$.ajax({
          url: '/applicants/create/' + $(this).val(),
          type: 'GET',
          success: function(response)
          {
               $('#subjectData tbody').html(response);
          }
      });

I added a /to the url applicants/create, removed the , after 'applicants/create/', and the data: object

Look. Forget the browser and ajax

Concentrate on getting the route working and the html returned that you expect FIRST

Your route should respond to

http://127.0.0.1:8000/admin/applicants/create/2

provided you have a subject with ID of 2

If this gives you 404, check your routes with php artisan route:list

Yeah, fixed my route and working thanks.