使用 codeigniter 将数据插入数据库 [英] insert data into database with codeigniter

问题描述

尝试使用 CodeIgniter 在我的数据库中插入一行.

Trying to insert a row into my database with CodeIgniter.

我的数据库表是 Customer_Orders，字段是 CustomerName 和 OrderLines.变量被正确提交.

My database table is Customer_Orders and the fields are CustomerName and OrderLines. The variables are being submitted correctly.

我的控制器是(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');
  }

我的模型是(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.

有什么想法吗?

推荐答案

在你的模型中试试这个:

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');
}

这篇关于使用 codeigniter 将数据插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！