Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Jquery's autocomplete documentation seems to be a bit lacking, at least for beginners. I've scoured the net for good tutorials, but haven't found any.

Heres what I have so far:

HTML:

<div id="addfilter">
    <div id="textwrap">
    <form method="POST" class="homeForm" id="homeForm" action="<?php echo base_url() ?>main/add_filter">
        <input type="text" class="text" id="homeText" name="homeText" placeholder="Add Category"></input>
        <input type="image" class="imginput" src="<?php echo base_url() ?>img/board/icons/add.jpg"id="homeSubmit" value="X"></input>
    </form>
    </div>
</div>

JS:

$().ready(function() {
    $("text").autocomplete("search.php", {
        width: 260,
        matchContains: true,
        selectFirst: false
    });
});

search controller

    public function search()
    {
        $this->thread_model->autocomplete();
    }

autocomplete model

    public function autocomplete()
    {
        $query = $this->db->query('SELECT tag
            , COUNT(*) as num_items
            FROM filter_thread ft
            INNER JOIN filter f
            ON ft.filter_id = f.filter_id
            GROUP BY tag');
        $tagcloud = $query->result_array();
        foreach ($tagcloud as $tags)
        {
            echo $tags;
        }
    }

Firebug doesn't show anything happening when I input text into 'formText.' I'm not even sure if the output of the model is in the correct format. Any help would be appreciated!

share|improve this question
 
Just a question does $().ready(function() { works without mentioning document in braces? –  swapnesh May 29 '12 at 14:02
 
where do you filter your table? you didn't use the input as a filter here? –  Taha Paksu May 29 '12 at 14:16
 
I returned it in JSON...again, not sure what the correct format should be –  Ricky Mason May 29 '12 at 14:18
 
By filter table, do you mean create a div/table to display the responses? I'm not sure –  Ricky Mason May 29 '12 at 14:19
 
No, I meant the LIKE("%'.$this->db->escape($_POST['term']).'%") part thatin the answer @liaant wrote. –  Taha Paksu May 30 '12 at 7:57
add comment

1 Answer

up vote 1 down vote accepted

Have you tested your controller and model?

First of all I'd correct your jquery:

$(document).ready(function() {
        var url = $("#homeForm").attr("url");
        $("#homeText").autocomplete({
            source: url,
            width: 260,
            matchContains: true,
            selectFirst: false
        });
    });

I'd recomment to supply URL the other way like attribute in form tag:

<form url="<?php echo base_url() ?>main/search" .... >

And before autocomplete in jQuery get that URL:

var url = $("#homeForm").attr("url")

Autocomplete then sends constraint by in term parameter. You shoud adjust your query to something like that:

'SELECT tag, COUNT(*) as num_items
            FROM filter_thread ft
            INNER JOIN filter f
            ON ft.filter_id = f.filter_id
            WHERE <YOUR_FIELD_HERE> LIKE("%'.$this->db->escape($_POST['term']).'%")
            GROUP BY tag'

I'm not really familiar with CodeIgniter, so you maybe need to correct something.

And the last (maybe) thing is to see how autocomplete will react with returns.

share|improve this answer
 
here is a link to my model: rickymason.net/blurb/main/search . It seems to work, and seems to output what is echoed. It is currently not in JSON, not sure if that matters. –  Ricky Mason May 29 '12 at 14:16
 
@RickyMason updated my answer. Then definitely problem in JS –  lia ant May 29 '12 at 14:25
 
I updated based on your suggestions. It appears to get some input lag when typing text in the text field, though I still don't see anything on firebug (not sure if I should). What format should the model return the text? –  Ricky Mason May 29 '12 at 14:36
 
@RickyMason do you see anything in Network tab in Firebug? It should be sending XHR requests if anything alright. The second matter is what you're receiving and how autocomplete should intrepere it –  lia ant May 29 '12 at 14:43
 
I am seeing nothing. For reference: you can see the page here: rickymason.net/blurb/main/home –  Ricky Mason May 29 '12 at 14:48
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.