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

1 vote342 views1 answer
Join to find results not in another table
SQL
0 vote330 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
4 votes337 views4 answers
Sqlite describe table
SQL
2 votes363 views3 answers
Sql server reseed identity column
SQL
2 votes376 views1 answer
Create mysql user on all hosts
SQL
0 vote370 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote320 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote355 views2 answers
Add new column after in sql
SQL
1 vote348 views1 answer
Select dba users oracle
SQL
0 vote326 views1 answer
Sqlite3 get data from table c
SQL