Login

g4blin · 03-10-2020, 09:20 AM

Hi i am new in using codeigniter ihave this codes

This is my model

Code:
function select_qnum_query(){

        //SELECT qnum FROM tblkiosk WHERE transaction = "landtax"

        $this->db->SELECT('qnum');

        $this->db->FROM('tblkiosk');

        $this->db->WHERE("transaction", "landtax");

        $query = $this->db->get();

        return $query->result();

this is my controller

Code:
function select_qnum(){

    $qnumber = $this->json_model->select_qnum_query();

    echo json_encode($qnumber);

    }

and this is my view

Code:
<script src ="<?php echo base_url("assets/js/jquery-3.4.1.min.js"); ?>"></script>

<html>

testing

<br>

<button>Payment</button>

<div>

<h5>Your Priority number: </h5>

<span id = "qnum"></span>

</div>

</html>

<script>

$("button").click(function(){

        $.ajax({

            url: "<?php echo base_url() ?>json_controller/select_qnum",

            type: "GET",

            dataType: 'json',

            success: function(data){

                $('#qnum').html(data);

            },

            error: function(){

                alert('Error....');

            }

        });

    });

</script>

it does not display any output. please help me