[Võ Hà o]

I have table USERS include fields: id, username, password.

 

Using grocery CRUD, when I ADD RECORD, a form appears:

 

 

But, I want add a control Confirm password to this form, look like

 

 

Before insert (username, password) to database, it will compare password and confirm password

 

p/s: Confirm password is not field in table USER

 

Who can help me about this problems?

[victor]

you can use function 'fields' and 'callback before insert'

[Võ Hà o]

you can use function 'fields' and 'callback before insert'

 

Hi Victor! Thank you very much!

This problem is ok. My code:

 

public function user()

    {

        $crud = new grocery_CRUD();

        $crud->set_theme('datatables');

        $crud->set_table('tbl_user');

        $crud->columns('username','password');

        $crud->fields('username','password','confirmpass')->field_type('password', 'password')->field_type('confirmpass', 'password');

        $crud->set_rules('password','Mật khẩu','required');

        $crud->set_rules('confirmpass','Xác nhận mật khẩu','matches[password]');

        $crud->callback_before_insert(array($this, 'insert_user'));

        $output = $crud->render(); 

        $this->Out($output); 

    }

    function insert_user($post_array){

 

       if($post_array['password']==$post_array['confirmpass'])

        {

            $data = array(

                   'username' => $post_array['username'] ,

                    'password' => $post_array['password']

            );

 

            $this->db->insert('tbl_user', $data); 

           //$this->user();

        }

    }

 

My application was inserted into the database. But it does not appear message when I click button Save in Add Record form

 

 

Or when I click button Save and go back to list. It not redirect to list User (but inserted into database)

[victor]

which error do you get from browser's console?

[victor]

take a look at the callback function from example!!!
you need return post_array in the end of function. and delete extra data before. unset($post_array['confirmpass']). in your case you don't need to insert data in to database in 'callback before insert' functions. only delete extra data before checking.
there are many topics on this forum about Ion_auth library

[Võ Hà o]

take a look at the callback function from example!!!
you need return post_array in the end of function. and delete extra data before. unset($post_array['confirmpass']). in your case you don't need to insert data in to database in 'callback before insert' functions. only delete extra data before checking.
there are many topics on this forum about Ion_auth library

 

Hi Victor! It's OK, it running.

 

I have another question about set_relaton function

 

 

void set_relation( string $field_name , string $related_table, string $related_title_field [, mixed $where [, string $order_by ] ] )

 

Example: $crud->set_relation('user_id','users','username',array('status' => '0'));

 

 

// Produces: ....WHERE status = '0'

 

But I want produces: ....WHERE status <> '0', Written set_relation function how?

 

 

 

// In codeigniter

$this->db->where('name !=', $name);
$this->db->where('id <', $id); 
// Produces: WHERE name != 'Joe' AND id < 45

 

[davidoster]

Use this,

 $crud->set_relation('user_id','users','username',array('status != ' => '0'));

 

Reference: http://ellislab.com/codeigniter/user-guide/database/active_record.html#select

function: $this->db->where();

[Võ Hà o]

Use this,

 $crud->set_relation('user_id','users','username',array('status != ' => '0'));

 

Reference: http://ellislab.com/codeigniter/user-guide/database/active_record.html#select

function: $this->db->where();

I have table tbl_category: (id, name, parent_id) and table tbl_topic: (id, title, content, cate_id)

I using:

             $crud->set_relation('cate_id','tbl_category','name',array('parent_id!=' => '0' ));

But:

 

 

 

????

[davidoster]

 $crud->set_relation('cate_id','tbl_category','name',array('parent_id != ' => '0' ));

[Võ Hà o]

 $crud->set_relation('cate_id','tbl_category','name',array('parent_id != ' => '0' ));

Thanks. beetwen paren_id and != have a space