[davidoster]

I believe in order to help you, we need to see the whole of your controller and models.

Copying and pasting here parts of it doesn't really helps a lot to be honest.

[victor]

look at this:

 

$crud->add_action('Send', '', 'standby/standby_v/copyrows','ui-icon-plus');
echo $this->copyrows();

 

the copyrows need a argument:
echo $this->copyrows($id);

share your project and I test it on my server.

[maru]

thanks David for your interest!

 

my controller standby.php

 

 

 

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');


class Standby extends CI_Controller {

    function __construct() 
    {
        
        parent::__construct();
        
        $this->load->database();
        $this->load->library('grocery_crud');
        $this->load->helper('url');
    }


    function index() 
    {
        
    }


   
    function standby_v()
    {
                
        try{
            
            $crud = new grocery_CRUD();

            $crud->set_theme('datatables');

            $crud->set_table('standby');

            $crud->set_subject('Standby');

            $crud->set_language('spanish');

            $crud->required_fields(
                'id_standby',
                'name',
                'email'
            );


            $crud->columns(
                'id_standby',
                'name',
                'email',
                'address',
                'phone',
                'password'
            );
            
            $crud->add_action('Send', '', 'copyrows','ui-icon-plus');
            
            $output = $crud->render();

            $this->load->view('standby/standby_v', $output);
            
        }catch(Exception $e){
            
            show_error($e->getMessage().' --- '.$e->getTraceAsString());
        }
        
       
    }
}

function copyrows($id)
    {
       $this->load->model('customer_model','customers');
       $this->load->model('standby_model','standby');
       $this->customers->insert($id); //insert into another table first
       $this->standby->delete($id); //then you can delete the source
    }
 

inside my folder model

 

customer_model.php

 

 

 

<?php
class Customer_model  extends CI_Controller
{
    public function insert($id) {
            $this->db->where('id_standby',$id);
            $rs = $this->db->get('standby')->result_array();
    
            $data['id_standby'] = $rs['id_standby']; 
            $data['name'] = $rs['name'];
            $data['email'] = $rs['email'];
            $data['address'] = $rs['address'];
            $data['phone'] = $rs['phone'];
            $data['password'] = $rs['password'];
            
            $this->db->insert('customers', $data);
        }
}    
?>
 

 

and standby_model.php

 

 

 

<?php
class Standby_model extends CI_Controller
{
     public function delete($id){
            $this->db->delete('standby', array('id_standby'=>$id));
    }
}
?>
 

[victor]

Unknown column 'id_standby' in 'field list' INSERT INTO `customers` (`id_standby`, `name`, `email`, `job`, `cuit`, `address`, `phone`, `password`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

[victor]

Do you have this column "id_standby'" in the "customers" table?

[victor]

show your table structure. I think your fields name are wrong

[maru]

Hi Victor!

 

Table Customers

id_custumer

 

Table Standby

id_standby

 

the rest of fields are the same in both tables

 

name, email, address, phone, so on...

[victor]

Do you have a column called "id_standby'" in the "customers" table?

[maru]

no, the id for customers table is id_customer, there is not a column called id_standby in this table

[victor]

your mistake is here:
<?php
class Customer_model  extends CI_Controller
{
.......
   
            $data['id_standby'] = $rs['id_standby'];

..........
           
            $this->db->insert('customers', $data);
        }
}   
?>

You want to insert a wrong data into table "'customers" .  $data['id_standby'] - is field name. But you haven't this column in your table

 

[maru]

I want to copy a row from standby to customers

 

I changed this $data['id_customer'] = $rs['id_customer']; but it's not working

 

 

 

<?php
class Customer_model  extends CI_Controller
{
    public function insert($id) {
            $this->db->where('id_standby',$id);
            $rs = $this->db->get('standby')->result_array();
    
            $data['id_customer'] = $rs['id_customer']; 
            $data['name'] = $rs['name'];
            $data['email'] = $rs['email'];
            $data['address'] = $rs['address'];
            $data['phone'] = $rs['phone'];
            $data['password'] = $rs['password'];
            
            $this->db->insert('customers', $data);
        }
}    
?>
 
 

[victor]

post deleted

[victor]

what error do you have?

 

is this first project for you?

[maru]

I deleted that row $data['id_customer'] = $rs['id_customer'];  but doens't work, no insert the row.

[maru]

there is no error, just the insert doesn't work.

and yes, it's my first proyect.

[maru]

did u try it in your server? it's working?

[victor]

no , I don't try. I see that you haven't result after:
$this->db->where('id_standby',$id);
$rs = $this->db->get('standby')->result_array();

 

the $rs is NULL
then you try insert an empty row.

 

P.S.
Try make for example blog without third party libraries. You don't know how to debug your code.

http://blog.teamtreehouse.com/how-to-debug-in-php

[victor]

and read http://ellislab.com/codeigniter/user-guide/

[maru]

I changed the id, now both tables have a column id like the original example who j-gun wrote, but still not working.

 

Thanks for your help!

[victor]

send me a private message with your controller and database dump . I try help you. But it will be tomorrow