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

9 votes186 views6 answers
Sql insert into
SQL
-1 vote194 views2 answers
Postgresql user permissions to database
SQL
-2 votes217 views2 answers
Union all in sql
SQL
0 vote212 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote186 views1 answer
Get server date mysql
SQL
2 votes192 views1 answer
Oracle list grants on procedure
SQL
12 votes226 views6 answers
Distinct in sql server
SQL
-1 vote168 views10 answers
Delete Query in SQL Server
SQL
3 votes199 views1 answer
Sql case update
SQL
0 vote235 views1 answer
Wordpress make wp user in db
SQL