如何在连接表中搜索？

Question

My table example:

---

customer (id , name ....)
transactions (id , sender , receiver .....)

---

The sender and receiver are both related to the customer id

---

I joined the table by

$this->db->select('transactions.*', FALSE);


    $this->db->select('tbl_receiver.name as receiver_name,tbl_sender.name as sender_name');
    $this->db->join('customer as tbl_receiver','tbl_receiver.id=transactions.receiver');
    $this->db->join('customer as tbl_sender','tbl_sender.id=transactions.sender');

Now I am able to display a table like (id,receiver_name , sender_name ...) I need a search bar that can search receiver/sender name

$this->db->like('receiver_name','Jackson');

But it said that no such column as receiver_name . How do I let it able to search by receiver name?

Answer 1

Here is my code working perfectly. you can try this stuff i hope this will work for you.

public function index()
{
    /*$email=$this->post->input('search');*/ //OR

    $email='[e-mail]'; // Set email accroding you
    $this->db->select('*');
    $this->db->from('table1');
    $this->db->like('table1.email',$email);
    $this->db->join('table2', 'table1.email = table2.email');
    $query = $this->db->get();

    $assignedData=$query->result_array();

    var_dump($assignedData); // store data in array
}