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 vote108 views1 answer
Set a value by excuting stored procedure
SQL
1 vote108 views1 answer
Mysql date diff in seconds
SQL
1 vote113 views1 answer
Mysql last year
SQL
14 votes104 views1 answer
Excel
SQL
6 votes114 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes98 views4 answers
Print pl sql
SQL
3 votes141 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote108 views1 answer
Left join in codeigniter query builder
SQL
3 votes106 views1 answer
How to check schema privileges in oracle
SQL
1 vote111 views1 answer
Mysql take number in string
SQL