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 vote388 views1 answer
Hierarchal database table
SQL
0 vote343 views1 answer
Shrink database file in sql server
SQL
0 vote278 views1 answer
'0000-00-00' for column '
SQL
0 vote317 views1 answer
Inser into example
SQL
1 vote356 views2 answers
Mysql extract number from string
SQL
0 vote322 views1 answer
Sql server datetime to string
SQL
0 vote321 views1 answer
Mysql find db contarint
SQL
0 vote342 views3 answers
Mysql regex replace
SQL
2 votes335 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote366 views2 answers
Identity syntax in sql
SQL