Insert query in ci

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

Codeigniter 3 update

$data = array(
        'title' => $title,
        'name' => $name,
        'date' => $date
);

$this->db->where('id', $id);
$this->db->update('mytable', $data);

Cideigniter orLike()

$this->db->like('title', 'match'); $this->db->or_like('body', $match);
// WHERE `title` LIKE '%match%' ESCAPE '!' OR  `body` LIKE '%match%' ESCAPE '!'

Source: codeigniter.com

Similar codes

0 vote275 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote199 views1 answer
Mysql select distinct date from timestamp
SQL
5 votes226 views3 answers
Day of week postgresql
SQL
9 votes197 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote203 views1 answer
Mysql regex select
SQL
5 votes194 views3 answers
Truncate function in sql oracle
SQL
17 votes224 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote214 views1 answer
What is top n result in sql
SQL
7 votes189 views1 answer
Sql server convert string to date
SQL
0 vote358 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL