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 vote234 views1 answer
Insert into select with group by
SQL
1 vote238 views1 answer
Python clean sql string
SQL
0 vote242 views1 answer
Create bdd mysql
SQL
40 votes232 views6 answers
Update table mysql
SQL
0 vote219 views1 answer
Ms sql unique
SQL
0 vote221 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
10 votes235 views3 answers
How to fetch first 5 characters in sql
SQL
1 vote259 views1 answer
Increase existing date in sql
SQL
1 vote242 views2 answers
Mysql update LAST_INSERT_ID()
SQL
21 votes253 views3 answers
Sql server search column name in all tables
SQL