使用ajax完成我的搜索输入

Question

I know i've posted like 30 min ago but i think i am getting close with my search posts input:

i've created a model that looks like this

    function matchPosts($keyword)
{
    $this->db->get('posts');
    $data = array();
    $query = $this->db->query("SELECT title,body FROM posts WHERE title LIKE '%$keyword%' or body LIKE '$keyword%' AND status='published'");        
    if( $query->num_rows() > 0)
    {
        $data = $query->row_array();
    }       
    $query->free_result();
    return  $data;
}

i am trying to get a match from my database,

the controller looks like this:

public function searchPosts()
{
    $keyword = $this->input->post('search_value', TRUE);

    $matched_field = $this->Model_cats->matchPosts($keyword);

    echo $keyword;

    if( count($matched_field) > 0)
    {
        $this->load->view('posts_list');
    }
    else
    {
        $this->load->view('posts_list');
    }
}

this is the js file

$(document).ready(function()
{
    $("#search_posts").keyup(function()
    {        
        var searchValue = $(this).val();

        $(".posted_post").each(function()
        {
               $.ajax({             
                    type: "POST",
                    url : "http://local.blog.com/welcome/searchPosts",
                    data: {
                        search_value: searchValue   
                    },  
                    success: function(data)
                    { 
                        if(data)
                        {
                            $(this).show(); 
                        }
                        else
                        {
                            $(this).fadeOut();      
                        }

                    }
                });
        });
    });
});

and the view:

    <br>    
<form action="" method="post"> 
        <label for="search_posts"><b>Search Posts</b></label>
        <input type="text" id="search_posts" value="" />
</form>

posts_list is the view where i loop throught the posts...

Em i getting close? it doesn't work in this state.

Answer 1

Edit your script as

$("#search_posts").keyup(function()
{        
    var posts = $(this).val();        
    //$(".posted_post").each(function()
    //{
        $.ajax({
            url : 'http://local.blog.com/welcome/searchPosts',
            data: {posts},  
            success : function(data)
            {
                 $(this).show();
            }
        });
    //}
});

and from

$matched_field = $this->Model_cats->matchPosts($keyword);

the $matched_field returns number of search results found right..??then you just check like

if($matched_field)
{
      //Here you can print result of search
}
else
{
      //You can print No results found
}