search method

search.php

<?php
public function search($searchterm,$limit)
{
    $sql = "SELECT * FROM Country
            WHERE Continent LIKE '%" . $searchterm . "%' LIMIT " .$limit . ",20";
    $q = $this->db->query($sql);
    if($q->num_rows() > 0)
    {
        foreach($q->result() as $row)
        {
            $data[] = $row;
        }
        return $data;
    }
    else
    {
        return 0;
    }
}