Welcome Guest, Not a member yet? Register   Sign In
Prevent white space in query being converted to percent 20
#1

[eluser]Andy78[/eluser]
I have the following function in my model that I want to use to search for phrases and so on. However if I pass in more than one word the spaces are always converted to the percent20 symbol which breaks my query. How do I avoid this?

Also is this type of query secure? or do I need t escape $term first?

Code:
function get_search_entries($limit, $start, $term)
   {
        
        $this->db->select('statuses.id, title, status, posted_by, created, rating, name');
        $this->db->from('statuses');
        $this->db->join('categories', 'categories.id = statuses.category_id');
        
        $this->db->where('MATCH (title, status) AGAINST ("'.$term.'")', NULL, FALSE);
        $this->db->limit($limit, $start);
        $query = $this->db->get();
        
        if ($query->num_rows() > 0) {
            
            return $query->result();  
        }
        
        return false;      
   }


Messages In This Thread
Prevent white space in query being converted to percent 20 - by El Forum - 02-19-2013, 05:16 PM



Theme © iAndrew 2016 - Forum software by © MyBB