Welcome Guest, Not a member yet? Register   Sign In
how to two table search using codeginter
#1

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
.php   User.php (Size: 1.53 KB / Downloads: 93)
Reply




Theme © iAndrew 2016 - Forum software by © MyBB