Retrieve information from Database Using Ajax with Laravel

Question

I am just migrating from traditional PHP to Laravel framework using the MVC concept. I want to be able to fetch data from the database based on the selection made from a dropdown list box. I keep getting this error: " Sorry, the page you are looking for could not be found. (1/1) NotFoundHttpException ".

See my code: Route File:

Route::get('/process-grpid','PagesController@processgrpid');

my Controller action code:

public function processgrpid($pno){
        $pno = $request->get('pno');
        $det = Stock::where('itemName',$pno)->get();
        return $det;       
    }

my view page:

<script type="text/javascript">
$(document).ready(function() { 
    $("select.partno").change(function(){
        var selectedPno = $(".partno option:selected").val();
       $.ajax(
           {
               type: "get",
                url:"/processgrpid",
               data:{pno:selectedPno},

               success:function(data){
                  // var det = JSON.parse(data);
                $("#desc").html('<input type="text"  placeholder="Enter Item Description" class="form-control" name="descr" required="required"/>');
               }
            }
        );

    });
});
    </script>


 <table>
     <tr>
              <th>Item Code/Part NO:</th>
                <td>
                <select name="partno" class="partno form-control">
                <option>Select PartNo</option>
                <option value="N/A">N/A</option>
                @foreach($pstock as $stock)
                <option value="{{ $stock->itemName }}">{{ $stock->itemName }}</option>
                @endforeach
                </select></td>
                 <th>Description:</th>
                  <td id="desc"></td></tr>
                 <tr>
    </table>

I don't know what am doing wrong. I have checked stackoverflow, but non of the soution meet my needs. All i wanted is to get the description of stock item from the database based on the dropdown list of partno. Please, help me look and guide me accordingly .

Your route is process-grpid when your Ajax is calling processgrpid — Crawdingle
– Crawdingle, Commented Jul 4, 2018 at 16:24

Lovepreet Singh · Accepted Answer · 2018-07-04 17:45:18Z

1

You made a minor mistake in calling route through ajax request.

Change url:"/processgrpid" to url:"/process-grpid".

Reason: As you defined route as

Route::get('/process-grpid','PagesController@processgrpid');

So now public url will be process-grpid instead of controller function processgrpid.

Also update controller function as:

public function processgrpid(Request $request) {
    $pno = $request->get('pno');
    $det = Stock::where('itemName', $pno)->get();
    return $det;
}

edited Jul 4, 2018 at 17:45

answered Jul 4, 2018 at 16:39

Lovepreet Singh

4,8701 gold badge21 silver badges39 bronze badges

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

12 Comments

David Mukoro Over a year ago

Thank you very much. It works. Please, how do i get the description value displayed in the input field : i have parse the result like var det = Json.parse(data), and i can see the Json object with key value paired, how can i display the value in the input field. $("#desc").html('<input type="text" placeholder="Enter Item Description" class="form-control" name="descr" required="required"/>');

Lovepreet Singh Over a year ago

Try this:

$("#desc").html('<input type="text" placeholder="Enter Item Description" class="form-control" name="descr" required="required" value="' + det.label_name + '"/>');

. replace label_name with actual label in det variable.

David Mukoro Over a year ago

@Locepreet Singh: I have tried it but it is not displaying anything in the input field.

David Mukoro Over a year ago

I have tried it but it is not displaying anything in the input field. I also added this at the top : var data = JSON.parse(data)

Lovepreet Singh Over a year ago

What is the value in var data;

|

Ehsan feyzolahi · Accepted Answer · 2018-07-05 03:29:54Z

0

you should pass $request to your controller as below:

public function processgrpid(Request $request){
        $pno = $request->pno;
        $det = Stock::where('itemName',$pno)->get();
        return $det;       
    }

edited Jul 5, 2018 at 3:29

answered Jul 4, 2018 at 16:46

Ehsan feyzolahi

1144 bronze badges

Collectives™ on Stack Overflow

Retrieve information from Database Using Ajax with Laravel

2 Answers 2

12 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related