how to two table search using codeginter
sallo Newbie
Posts: 1
Threads: 1
Joined: Apr 2016
Reputation:
0
my 1 first table is searching but second table not search plz help me
my model
<?php
class articlesmodel extends CI_Model {
public function lists( )
{
$query =$this->db
->select('title')
->from('enter')
->get();
return
$query->result();
}
public function search $query ) {
$q = $this->db->from('enter')
->like('title', $query )
->get();
return $q->result();
}
my controller search
<?php
class user extends MY_Controller {
public function index()
{
$this->load->helper('form');
$this->load->model('movies');
$articles = $this->movies->lists();
$this->load->view('user/articles_list',['articles'=>$articles]);
}
public function search()
{
$this->load->library('form_validation');
$this->form_validation->set_rules('query','Query','required');
if( ! $this->form_validation->run())
$this->index();
$query = $this->input->post('query');
$this->load->model('articlesmodel ');
$articles = $this->articlesmodel ->search_rows($query);
$this->load->view('public/search_result',compact('articles'));
}
}
this is search form
<?= form_open('user/search',['class'=>'navbar-form navbar-left','role'=>'serach']) ?>
<div class="form-group">
<input type="text" name="query" class="form-control" placeholder="Search">
</div>
<button type="submit" class="btn btn-default">Submit</button>
<?= form_close();?>
<?= form_error('query',"<p class='navbar-test text-danger'>",'</p>') ?>
!----------------------------------------------------------------------------------------
second table
my 2nd model search
<?php
class Movies extends CI_Model {
public function lists( )
{
$query =$this->db
->select('title')
->from('enter')
->get();
return
$query->result();
}
public function search_rows( $query ) {
$q = $this->db->from('enter')
->like('title', $query )
->get();
return $q->result();
}
my 2nd controller search
<?php
class Haris extends MY_Controller {
public function index()
{
$this->load->helper('form');
$this->load->model('movies');
$articles = $this->movies->lists();
$this->load->view('public/view',['articles'=>$articles]);
}
public function search_row()
{
$this->load->library('form_validation');
$this->form_validation->set_rules('query','Query','required');
if( ! $this->form_validation->run())
$this->index();
$query = $this->input->post('query');
$this->load->model('movies');
$articles = $this->movies->search_rows($query);
$this->load->view('public/search_result',compact('articles'));
}
plz helpe me
Attached Files
User.php (Size: 1.53 KB / Downloads: 93)