public function getSearch()
{
$q = Input::get('q');
$projects_sql = Project::whereRaw("MATCH(title, description, geo_address, status) AGAINST (? IN BOOLEAN MODE)", array($q));
$projects_count = $projects_sql->count();
$projects = $projects_sql->paginate(10);
// Limit length
for ($i = 0; $i < count($projects); $i++) {
if (strlen($projects[$i]->title) > 80) {
$projects[$i]->title = substr($projects[$i]->title, 0, 80) . '...';
}
if (strlen($projects[$i]->description) > 200) {
$projects[$i]->description = substr($projects[$i]->description, 0, 200) . '...';
}
}
$data = compact('projects', 'projects_count');
return view('home.search', $data);
}