doujiejujixi27244
2016-08-31 10:37
浏览 79
已采纳

Javascript - Json使用codeigniter从表中获取值

I am new in ajax and json. and in my select option i have list of products there. and if i press any of the product it will show its price and the supplier. but what happened to my code is it shows both product and supplier but not in there specific fields. Here is the Example
The 550.00 is the price and asdadsadsadsadsadsad there is the name of the supplier. so the output must be in their specific fields.

JAVASCRIPT

    $("#prod-names").change(function(){
    var prodid = $("#prod-names option:selected").attr("value");
    $.ajax({
        url: "http://localhost:800/client_ayos/administrator/createpromoajax/"+prodid,
        type: "POST",


        success: function(data){
            console.log(data);
            var json = JSON.parse(data);

            $("#orig-price").val(json); //val =  value of #orig-price
            $("#supplier").val(json); //val =  value of #orig-price

        },
        error: function (jqXHR, textStatus, errorThrown){
                    alert('Error !');
                }
    })
});

CONTROLLER

    public function createpromoajax($id){
    //echo json_encode($this->uri->segment(3));
    $data['productid'] = $this->AdminModel->get_prodid($id);

    $price = $data['productid']->price;
    $supplier = $data['productid']->supplier;

    $ajaxproduct = array(
        $data['productid']->price,
        $data['productid']->supplier,
        );


    echo json_encode($ajaxproduct);

}

PS: I've also encountering this kind of error but still it shows the correct output but not in the specific fields

VM13100:1 Uncaught SyntaxError: Unexpected token < in JSON at position 0

Thanks in advance.

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • donglu5728 2016-08-31 11:02
    已采纳

    i think there is a lot to simplify your controller and js structure try something like that

    here is the php part

    public function createpromoajax($id)
    {
        $objProduct = $this->AdminModel->get_prodid($id);
        header('Content-Type: application/json');
        echo json_encode($objProduct);
    }
    

    and your javascript part

    $("#prod-names").change(function(){
    
        var prodid = $("#prod-names option:selected").attr("value");
        var url = "http://localhost:800/client_ayos/administrator/createpromoajax/"+prodid;
    
        $.getJSON( url, function(data) {
            $("#orig-price").val(data.price);
            $("#supplier").val(data.supplier); //val =  value of #orig-price
        });
    });
    

    i'm not sure what it means "unexptected token..." but i think you already output some html before the createpromoajax function - in order to verify this you could try to call your function directly and see what your browser gets as output.

    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题