Inheritance: extends CI_Model
Exemplo n.º 1
0
 public function search()
 {
     $data['message'] = "";
     $this->form_validation->set_rules('search_term', '"Search Term"', 'trim|required|max_length[60]|xxs_clean');
     if ($this->form_validation->run() == TRUE) {
         $search_term = $this->input->post('search_term');
         $data['search_term'] = $search_term;
         $qids = array();
         $qids = new Search_model();
         $qids->get_result($search_term);
     }
     $this->load->view('header/header_without', $data);
     $this->load->view('search_questions', $data);
     $this->load->view('sidebar/right_sidebar', $data);
     $this->load->view('footer/footer', $data);
 }
	<br>
		<h2> Search results:</h2>
		
	<br>
	<div class="questions">
	<div class="err_msg"><?php 
echo "<p>{$message}</p>";
?>
 <?php 
echo validation_errors();
?>
</div><br>
	<table>
		<?php 
if (!validation_errors()) {
    $records = Search_model::get_result($search_term);
    $i = 1;
    if ($records & $search_term != "") {
        foreach ($records as $d) {
            echo "<tr>";
            echo "<td class=\"answers\"> <div class=\"division_no\">" . $d->replies . "</div><div class=\"division\">answers</div>\r\n\t\t\t\t<td class=\"views\"><div class=\"division_no_v\">" . $d->views . "</div><div class=\"division_v\">views</div>\r\n\t\t\t\t<td class=\"qstns\"><a href=\"" . base_url() . "index.php/User/display_qstn/" . $d->q_id . "\">" . $d->title . "</a>\r\n\t\t\t\t<td class=\"users\"> asked by " . $d->user . "\r\n\t\t\t</tr>";
        }
    } else {
        echo "No result found for \" " . $search_term . " \"";
    }
}
?>
		</table>
	</div>
		<br><br>
 public function all_terms()
 {
     $query = "select * from all_qstns;";
     $records = $this->db->query($query);
     return Search_model::instantiate($records);
 }