AJAX Js Yii2 dropdown POST 500 (Internal Server Error)

Question

I'm using yii2 and a newbie in JavaScript and ajax.

I am getting this error:

jquery.js:9175 POST http://localhost/istanagroup/web/purchase-order/basepricenet 500 (Internal Server Error)

here is the controller function

public function actionBasepricenet(){
$id = $_POST['id'];
$model = MasterItem::find()->andFilterWhere(['id_master_item'=>$id])->one();
echo $model;

here is the js :

$('#purchaseorderdetail-0-id_master_item').change(function(){
  var cat = $(this).val();
  $.ajax({
    type:'POST',
    url:'http://localhost/istanagroup/web/purchase-order/basepricenet',
    data : {id:cat},
    dataType : 'text',
    success:function(res){
      console.log(res);
      $('#purchaseorderdetail-0-base_price').val(res);
    }
  });
});

Error is in PHP, check you are getting `id` in post by using `echo`, also check PHP error check this for info on error https://stackoverflow.com/questions/22170864/500-internal-server-error-how-to-debug — Ganesh Ghalame, Jan 29 '18 at 02:02
@GaneshGhalame i already checked the id, i got the id and i can echo it but the error come in $model. — Lazarus Tharub, Feb 02 '18 at 02:19

Claudio Busatto · Answer 1 · 2018-02-02T02:25:04.400

0

Folowing the Yii2 documentation,

andFilterWhere adds an additional WHERE condition to the existing one but ignores empty operands.

In your case you do not have declared a where() condition. Furthermore, once the ID is always provided in the request, you could change the andFilterWhere() to a normal where(), as the following:

public function actionBasepricenet(){
  if (isset($_POST['id'])){
    $id = $_POST['id'];
    $model = MasterItem::find()->where(['id_master_item'=>$id])->one();
    var_dump($model);
  } else {
     // ID not received! Error!
  }
}

edited Feb 02 '18 at 02:25

answered Jan 29 '18 at 02:08

Claudio Busatto

721
7
17

Thanks for the answer Claudio Busatto, i already got the id, but the error still in the $model. – Lazarus Tharub Feb 02 '18 at 02:22
What does it display when you call `var_dump($model->getErrors())` ? – Claudio Busatto Feb 02 '18 at 02:27

AJAX Js Yii2 dropdown POST 500 (Internal Server Error)

1 Answers1