CodeIgniter append string to table name

Question

In my codeIgniter project I have separate tables to each user. like, tbl_user1, tbl_user2, tbl_user3, tbl_user4, etc. this 1,2,3,4 are user id numbers.

after particular user logged in to the system, i need to access table which is related to user. (ex. for user 2, need to fetch data from tbl_user2 table).

I have session variable containing user id,

$uid=$this->session->userdata('uid');  //$uid=2 for **user 2**

how to use this with my model and controller,

ex. controller

$this->tbl_user('username'); //$this->tbl_user.$uid('username'); - not working

ex. model

 $this->db->select('tbl_user.$uid.*', false);  - //not working
    $this->db->from('tbl_user.$uid'); - //not working

please advice.

Al Amin Chayan · Accepted Answer · 2015-08-04 09:07:01Z

1

Controller:

$this->{'tbl_user' . $uid}('username');

model: Use double quote

$this->db->select("tbl_user.$uid.*", false);
$this->db->from("tbl_user.$uid");

answered Aug 4, 2015 at 9:07

Al Amin Chayan

2,5004 gold badges27 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CodeIgniter append string to table name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related