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

2 votes191 views2 answers
Sqlite_busy: database is locked
SQL
4 votes178 views1 answer
Sql delete where in select
SQL
18 votes177 views3 answers
Mysql current date
SQL
7 votes185 views1 answer
Mysql remote connection command line
SQL
0 vote182 views1 answer
Flask sqlalchemy remove duplicates
SQL
5 votes197 views1 answer
Oracle list days between two dates
SQL
0 vote177 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
2 votes181 views1 answer
Delete all value query
SQL
0 vote189 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote186 views1 answer
Logtash mysql cofiguration file
SQL