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