insert data into database with codeigniter

codeigniter, database, insert, php

Solution

Try this in your model:

function order_summary_insert()
    $OrderLines=$this->input->post('orderlines');
    $CustomerName=$this->input->post('customer');
    $data = array(
        'OrderLines'=>$OrderLines,
        'CustomerName'=>$CustomerName
    );

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

Try to use controller just to control the view and models always post your values in model. it makes easy to understand. Your controller will be:

function new_blank_order_summary() {
    $this->sales_model->order_summary_insert($data);
    $this->load->view('sales/new_blank_order_summary');
}

Problem

Trying to insert a row into my database with CodeIgniter. My database table is `Customer_Orders` and the fields are `CustomerName` and `OrderLines`. The variables are being submitted correctly. My Controller is( `sales.php` ): ``` function new_blank_order_summary() { $data = array( 'OrderLines'=>$this->input->post('orderlines'), 'CustomerName'=>$this->input->post('customer') ); $this->sales_model->order_summary_insert($data); $this->load->view('sales/new_blank_order_summary'); } ``` My Model is( `sales_model.php` ): ``` function order_summary_insert($data){ $this->db->insert('Customer_Orders',$data); } ``` Whilst the view loads correctly, no data is inserted into the database. Any ideas as to why not?

Original source