Hi Geeks, I was working on a search engine which works on exact phrase searching. I have already created the MVC architecture. The following is the query to search in the model.
$sql = "select A.actnumber,S.sectionintrotext, S.sectionnumber,S.subsectionnumber,S.subsectionbody
from Act as A join section as S on (a.actnumber = s.actnumber)
WHERE match (a.actnumber) against (". $reg ."IN BOOLEAN MODE) OR
match (a.acttitle) against (". $reg."IN BOOLEAN MODE) ";
$query = $this->db->query($sql);