Codeigniter AJAX data returns empty

Question

So I'm not exactly proficient in using codeiginiter but I've been working with it for a while now.

I'm trying to make an SQL query to search for books in the database, but the ajax always returns empty.

I echoed a few dummy strings to make sure that a proper connection is established between the controller and the view, and I made sure the SQL query itself works, but I don't understand why this still happens.

This is the javascript:

    $('#search').on("keyup", function() {
search = $(this).val();
console.log("Search Term: " + search);
$.ajax
({
    type: "POST",
    url: base_url + "vault/quick_search",
    data: {search_term:search},
    dataType: 'json',
    success: function(data)
    {
      console.log("Result: " + data);
    }, 
    error: function(data)
    {
        alert("?");
    }
});
});

This is the controller:

      function quick_search()
    {
       $search = $this->input->post('search_term');
       $result = $this->vault_instance->quick_search($search);
       echo json_encode($result);
    }

This is the model:

      function quick_search($search_term)
 {
   $sql = "SELECT * FROM books WHERE title LIKE '%harr%' OR author LIKE '%harr%'";
    $query = $this->db->query($sql);
    return $query->result_array;
 }

NOTE: sorry for the poor editing, this is my first time asking a question. Also, in the model I used "harr" as a test, I understand it's not the search term itself, it still returns empty

But you did good editing of your code. But wait for the hints. — rahul
– rahul, Commented Feb 26, 2016 at 19:49
Welcome! Are you developing on your local machine? Some browsers have security measures in place that make Ajax tricky. Are there any errors/warnings in your browser's dev console? — colonelsanders
– colonelsanders, Commented Feb 26, 2016 at 19:51
I think u have issue here return $query->result_array; this should be return $query->result_array(); — devpro
– devpro, Commented Feb 26, 2016 at 19:59
Yes, I'm working on my local machine. There aren't really any warnings or errors. I've done many other AJAX calls; they worked just fine. This one isn't, however. — Hesham M. Abdelghany
– Hesham M. Abdelghany, Commented Feb 26, 2016 at 20:00

devpro · Accepted Answer · 2016-02-26 20:03:15Z

2

You need to change this line:

return $query->result_array;

With:

return $query->result_array();

Becuase result_array() is a function which return you result into array format.

answered Feb 26, 2016 at 20:03

devpro

16.1k3 gold badges29 silver badges39 bronze badges

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

Comments

Manish Saini · Accepted Answer · 2016-02-26 19:56:49Z

0

What is the collation you using for your database column? If not utf8_general_ci try to change to it.

answered Feb 26, 2016 at 19:56

Manish Saini

782 silver badges10 bronze badges

Comments

Dxml · Accepted Answer · 2016-02-26 19:49:56Z

-1

Not sure if this works, but... try to change the datatype in your $.ajax call to jsonp (instead of json).

answered Feb 26, 2016 at 19:49

Dxml

1952 silver badges11 bronze badges

3 Comments

Sushanth -- Over a year ago

That will not change anything

Hesham M. Abdelghany Over a year ago

The AJAX returns an error now. Is there anything else I need to modify for jsonp to work?

Dxml Over a year ago

@Sushanth jsonp helps if you're not getting AJAX data returned due to the Same-Domain policy restriction.

Collectives™ on Stack Overflow

Codeigniter AJAX data returns empty

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related