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 votes189 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
3 votes184 views2 answers
Oracle synonym
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
0 vote239 views2 answers
How to install psql in ubuntu
SQL
3 votes184 views2 answers
To_char oracle
SQL
0 vote265 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote237 views2 answers
Select into temp table
SQL
0 vote190 views1 answer
Normalization in database 2nd normal form
SQL
3 votes175 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote187 views2 answers
Sql auto update dupdated_at
SQL