⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

add function in set_relation_n_n not work



Alfandi Nurulmukhlis

Alfandi Nurulmukhlis
  • profile picture
  • Member

Posted 01 October 2013 - 11:35 AM

please help me again..

sorry for my bad english..

i have code in table "user", i give function set_relation_n_n but add function not work properly, but when i edit , it works properly

i have table relation :

[attachment=687:grocery user table.PNG]

i add record:
[attachment=688:grocery when insert user.PNG]

but it not saved in field relation_n_n:
[attachment=689:grocery user add.PNG]

 

in table "room_access" not saved:

[attachment=690:grocery acces room.PNG]

when i edit table "user", it work properly:
[attachment=691:insert well.PNG]

table "acces_room" view:
[attachment=692:access room insert well.PNG]

this is my code:

public function user()
    {
        $this->grocery_crud->set_table('user');
        $this->grocery_crud->set_subject('User');
        $this->grocery_crud->required_fields('Rfid','Id_User','Nama_User','Id_Status','Room_Access');
        
        $this->grocery_crud->display_as('Id_Status','Status');
        $this->grocery_crud->set_relation('Id_Status','status','Nama_Status');
        $this->grocery_crud->set_relation_n_n('Room_Access','room_access','ruang','Rfid','Ip','Nama_Ruang');
        
        $output = $this->grocery_crud->render();
        $this->crud_output($output);
    }

 


help me.., thanks in adv..


Alfandi Nurulmukhlis

Alfandi Nurulmukhlis
  • profile picture
  • Member

Posted 02 October 2013 - 04:22 AM

My analysis :

in main table "user", primary key must integer and AutoIncrement, that's work properly

if primarykey in main table Varchar, that's doesn't work . . .