jQuery UI autocomplete in codeIgniter with sql, php

Question

I am trying to do create text-box auto-complete with jquery. But something goes wrong when I check it in debuger it shows the every value but it not showing in text-box drop-down on view page. I'm newbie all help would be appreciated.

here's my view code.

<link rel="stylesheet" type="text/css" href="http://code.jquery.com/ui/1.9.2/themes/base/jquery-ui.css" />
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.3.js"></script>
<script type="text/javascript" src="http://code.jquery.com/ui/1.9.2/jquery-ui.js"></script>

<script type="text/javascript">
    $(function(){
        $("#location").autocomplete({
            source: 'set_location'
        });     
    });
</script>
<form action= "#">
    <table>
        <tr>
            <td><label for='location'>Location</label></td>
            <td><input id="location" type="text" size="50" placeholder="Enter a location" name= "location"> </td>
        </tr>           
    </table>
</form>

here's my controller code

if(isset($_GET['term'])){
    $location = strtolower($_GET['term']);      
    $query = $this->venues_model->set_location($location);          
    echo $query;
}

here's my model code

$this->db->select('*');
$this->db->like('location', $location);
$query = $this->db->get('venue_details');

if(count($query->result_array()) > 0){ 
    foreach ($query->result_array() as $row){
        $row_set[] = htmlentities(stripslashes($row['location']));
    }
    echo json_encode($row_set);
}

Any error in console??

Niranjan N Raju
– Niranjan N Raju

2015-10-27 07:13:43 +00:00
Commented Oct 27, 2015 at 7:13 — Niranjan N Raju
– Niranjan N Raju, Commented Oct 27, 2015 at 7:13
No it not showing anything.

Rahul Bhargava
– Rahul Bhargava

2015-10-27 07:14:58 +00:00
Commented Oct 27, 2015 at 7:14 — Rahul Bhargava
– Rahul Bhargava, Commented Oct 27, 2015 at 7:14

Niranjan N Raju · Accepted Answer · 2015-10-27 07:32:23Z

1

try this,

if(isset($_GET['term'])){
$location = strtolower($_GET['term']);      
echo $this->venues_model->set_location($location);          
}

in model

function set_location() {
    $row_set = array();
    $this->db->select('*');
    $this->db->like('location', $location);
    $query = $this->db->get('venue_details');

    if (count($query->result_array()) > 0) {
        foreach ($query->result_array() as $row) {
            $row_set[] = htmlentities(stripslashes($row['location']));
        }

    }

    return json_encode($row_set);
}

also this,

source: '<?= base_url("controller/set_location") ?>'

edited Oct 27, 2015 at 7:32

answered Oct 27, 2015 at 7:17

Niranjan N Raju

12k4 gold badges24 silver badges41 bronze badges

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

13 Comments

Niranjan N Raju Over a year ago

Check i have changed my model

Niranjan N Raju Over a year ago

in console is it printing anything??

Rahul Bhargava Over a year ago

yes after every key press it update and showing the values.

Niranjan N Raju Over a year ago

can u add that screenshot??

Niranjan N Raju Over a year ago

in this, only echo of json should be present. no var_dump, no any other echo and no loading view

|

Saty · Accepted Answer · 2015-10-27 07:26:40Z

0

You have to return from your model file and echo from your controller

Model

$this->db->select('*');
$this->db->like('location', $location);
$query = $this->db->get('venue_details');

if(count($query->result_array()) > 0){ 
    foreach ($query->result_array() as $row){
        $row_set[] = htmlentities(stripslashes($row['location']));
    }
    return json_encode($row_set);// return from model
}

Controller

if(isset($_GET['term'])){
    $location = strtolower($_GET['term']);      
   echo  $query = $this->venues_model->set_location($location);          
}

And change your path to

source: '<?php echo base_url();?>index.php/controller/function'

edited Oct 27, 2015 at 7:26

answered Oct 27, 2015 at 7:15

Saty

22.5k7 gold badges35 silver badges52 bronze badges

8 Comments

Saty Over a year ago

You need to call a ajax link to get your data from your controller

Rahul Bhargava Over a year ago

i'm following this link

Saty Over a year ago

YOu need to check your path i tinl it would be source: '<?php echo base_url()./index.php/controller/function'

Rahul Bhargava Over a year ago

what is index.php here

Saty Over a year ago

Check without index.php <?php echo base_url();?>controller/function

|

akinlex · Accepted Answer · 2018-05-21 11:06:54Z

0

just add ui-widget to your div. Make sure to reference jquery ui

answered May 21, 2018 at 11:06

akinlex

237 bronze badges

Collectives™ on Stack Overflow

jQuery UI autocomplete in codeIgniter with sql, php

3 Answers 3

13 Comments

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

13 Comments

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related