[DREON]

I have a problem i want an action custom control called copy,

 

i mean i have 2 tables called sample1 and sample with column,, in my sample1 view i want to add a copy button the function is can send a copy of to my sample2 table.. please help..

[victor]

   function test()
    {
	if ($this->uri->segment(3) == "copyrows")
	{
	    $row_id = $this->uri->segment(4);
	    $this->copyrows($row_id);
	    redirect('standby/test');
	}
	$crud = new grocery_CRUD();
	$crud->set_theme('datatables');
	$crud->set_table('standby');
	$crud->add_action('Send', '', 'standby/standby_v/copyrows', 'ui-icon-plus');
	$output = $crud->render();
	$this->load->view('standby/standby_v', $output);
	$this->load->view('layouts/footer');
    }

    function copyrows($id)
    {
         $data =  select from main table
         insert $data into second table
    }

[DREON]

sir what is the proper code i have my main table called faculty and seocd table is faculty_copy.

 

do i need to modify my model? thnx

 

$data = select from main table
insert $data into second table

[DREON]

sir for more info: this my code on my

 

 public function faculty()
    
    {
    
        $crud = new grocery_CRUD();
 
        $crud->set_theme('datatables');
        $crud->set_table('faculty');
        $crud->set_subject('CMT');
        $crud->columns('id1','subject','days','schoolcollege_id','time_from','time_to','room');
        $crud->set_relation('id1','faculty_cmt','{faculty_lname},{faculty_fname}');    
        $crud->set_relation('schoolcollege_id','faculty_cmt','schoolcollege');    
    
        $crud->display_as('id1','Full Name');
        $crud->display_as('subject','Subject');
        $crud->display_as('days','Days');
        $crud->display_as('schoolcollege_id','School/College');
        $crud->display_as('time_from','From');
        $crud->display_as('time_to','To');
        $crud->display_as('room','Room');
        
        
        $output = $crud->render();
 
    
        $this->load->view('faculty_cmt.php',$output);    
        
    }

 

and i want to put a copy on my faculty_copy table

[DREON]

please help..

[DREON]

help please

[davidoster]

The code was given here, /topic/1372-copy-button-help-please/#entry5793

[DREON]

i use this on my callback: buy then i click send button all record from my table1 will copy to my table2

 

my question is how can i copy and move Selected record to  my table2.

 

    $crud->add_action('Send', '', 'main/copyrows', 'ui-icon-plus');

 

 

function copyrows($primary_key)
    {   

    $query = $this->db->get('table1');
    foreach ($query->result() as $primary_key) {
          $this->db->insert('table2',$primary_key);
  }
    }

[victor]

read how to get data from db . you don't understand how to do that.
http://ellislab.com/codeigniter/user-guide/database/index.html
and read how to insert data into a database

[victor]

you should read how to get one row and about 'where' function.

[DREON]

i try to grocerycrud defult examples controler and i used this code to my copy add action

 

function copyrows($id) {
            $this->db->where('officeCode',$id);
            $rs = $this->db->get('offices')->result_array();
            
    
            $data['officeCode'] = $rs['officeCode'];
            $data['city'] = $rs['city'];
            $data['phone'] = $rs['phone'];
            $data['addressLine1'] = $rs['addressLine1'];
            $data['addressLine2'] = $rs['addressLine2'];
            $data['state'] = $rs['state'];
            $data['postalCode'] = $rs['postalCode'];
            $data['territory'] = $rs['territory'];

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

 

but i got this error:

 

Error Number: 1048

Column 'city' cannot be null

INSERT
INTO `offices1` (`officeCode`, `city`, `phone`, `addressLine1`,
`addressLine2`, `state`, `postalCode`, `territory`) VALUES (NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL)

Filename: C:\xampp\htdocs\CRUD\system\database\DB_driver.php

Line Number: 330

[victor]

because you use result_array. You should use row_array to get one row. Read the user guards!

[DREON]

got it.. thnx

[juanmoras]

Thanks