insert data into database with codeigniter

Question

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   gt  this- gt input- gt post  orderlines             CustomerName   gt  this- gt input- gt post  customer                      this- gt sales model- gt order summary insert  data         this- gt load- gt view  sales new blank order summary          My Model is  sales model php     function order summary insert  data        this- gt db- gt insert  Customer Orders   data       Whilst the view loads correctly  no data is inserted into the database   Any ideas as to why not

User · Answer

It will be better for you to write your code like this.

In your Controller Write this code.

    function new_blank_order_summary() {
     $query = $this->sales_model->order_summary_insert();
     if($query) {
        $this->load->view('sales/new_blank_order_summary'); 
    } else {
        $this->load->view('sales/data_insertion_failed');
    }
  }

and in your Model

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

    $this->db->insert('Customer_Orders',$data);
    return ($this->db->affected_rows() != 1) ? false : true;
}

User · Answer

Just insert  this- gt load- gt database    in your model   function order summary insert  data        this- gt load- gt database         this- gt db- gt insert  Customer Orders   data

User · Answer

function saveProfile         firstname    this- gt input- gt post  firstname         lastname    this- gt input- gt post  lastname         post data   array  firstname   gt   firstname  lastname   gt  lastname        this- gt db- gt insert  posts   post data       return  this- gt db- gt insert id

User · Answer

lt  php defined  BASEPATH   OR exit  No direct script access allowed     class Cnt extends CI Controller      public function insert view         this- gt load- gt view  insert        public function insert data       name  this- gt input- gt post  emp name       salary  this- gt input- gt post  emp salary       arr array      emp name   gt  name      emp salary   gt  salary          resp  this- gt Model- gt insert data  emp1   arr     echo   lt script gt alert   resp   lt  script gt       this- gt insert view             for more detail visit  http   wheretodownloadcodeigniter blogspot com 2018 04 insert-using-codeigniter html

User · Answer

Try this in your model   function order summary insert        OrderLines  this- gt input- gt post  orderlines         CustomerName  this- gt input- gt post  customer         data   array           OrderLines   gt  OrderLines           CustomerName   gt  CustomerName              this- gt db- gt 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- gt sales model- gt order summary insert  data        this- gt load- gt view  sales new blank order summary

User · Answer

Check your controller   function order        OrderLines    this- gt input- gt post  orderlines         CustomerName    this- gt input- gt post  customer         data   array           OrderLines    gt   OrderLines           CustomerName    gt  CustomerName               this- gt db- gt insert  Customer Orders    data

User · Answer

View    lt input type  text  name  name   gt   lt input type  text  name  class   gt    Controller  function   construct         parent     construct         this- gt load- gt Model  Model       function index          this- gt load- gt view  view       function user        if  isset   POST  submit               data   array  name   gt   POST  name                         class   gt   POST  class               this- gt Model- gt insert  data             Model  function insert  data         this- gt db- gt insert  table name   data       return true

User · Answer

Based on what I see here  you have used lowercase fieldnames in your  data array  and uppercase fieldnames in your database table

User · Answer

function order summary insert    OrderLines  this- gt input- gt post  orderlines     CustomerName  this- gt input- gt post  customer     data   array   OrderLines   gt  OrderLines   CustomerName   gt  CustomerName      this- gt db- gt insert  Customer Orders   data

[php] insert data into database with codeigniter

Examples related to php

Examples related to database

Examples related to codeigniter

Examples related to insert