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

11 votes280 views1 answer
Mysql text type max length
SQL
0 vote255 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote266 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote256 views1 answer
Java mysql date format
SQL
0 vote282 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote264 views1 answer
Query to insert image
SQL
25 votes307 views4 answers
Import mysql dump command line
SQL
0 vote274 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote278 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote267 views1 answer
Mysql select all table that have field names
SQL