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

3 votes344 views2 answers
Funktion LOWER/UPPER sql
SQL
-1 vote371 views1 answer
Spring boot mysql connection properties
SQL
0 vote379 views1 answer
Convert excel into sqllite db using python
SQL
1 vote374 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote362 views1 answer
Oracle procedure chain step
SQL
1 vote392 views1 answer
Backup mysql schema only
SQL
1 vote357 views1 answer
Adding a check statement in sql
SQL
0 vote341 views1 answer
Html css mobile menu arrow dropdown
SQL
1 vote357 views2 answers
Limit sqlserver
SQL
0 vote410 views1 answer
Mysql workbench format date
SQL