[eluser]Unknown[/eluser]
Hi guys, I am trying to create a full text search for my site but am having little luck.
I have created a FULLTEXT index in my MySQL db (storage type MyISAM). The FULLTEXT index contains the following fields 'title,intro,content'.
I have then proceeded to create my MVC for the search. Code is as follows:
View
Code:
<?php echo form_open('search'); ?>
<?php echo form_label('Search:', 'search-box'); ?>
<?php echo form_input('searchquery', 'searchquery'); ?>
<?php echo form_submit('search', 'Search'); ?>
<?php echo form_close(); ?>
//echo search results
<?php foreach ($searchcontent as $s): ?>
<?php echo $s['title']; ?>
<?php echo $s['intro']; ?>
<?php echo $s['content']; ?>
<?php endforeach; ?>
Controller
Code:
class Search extends CI_Controller {
public function index()
{
//Content model is autoloaded
if ($this->input->post('searchquery'))
{
//Get data from content where page = $page
$searchquery = $this->input->post('searchquery');
$viewdata['searchcontent'] = $this->Content_model->search($searchquery);
$this->load->view('search',$viewdata);
}
else ($this->load->view('search'));
}
}
Model
Code:
function search($searchquery)
{
// Execute our SQL statement and return the result
$sql = "SELECT title,intro,content
FROM content
WHERE MATCH (content) AGAINST (?) > 0";
$query = $this->db->query($sql, array($searchquery, $searchquery));
foreach ($query->result() as $row) {
$searchquery[] = array(
'title' => $row->title,
'intro' => $row->intro,
'content' => $row->content
);
}
return $searchquery;
}
I can't seem to retrieve any search results with the above, is there something wrong with the code, is there any documentation on performing the above?