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

5 votes273 views2 answers
Add column postgres with default value
SQL
1 vote282 views1 answer
Pl sql insert into table
SQL
2 votes275 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote276 views1 answer
Search starting with mysql
SQL
0 vote247 views1 answer
Alter session set nls_language french
SQL
0 vote258 views1 answer
Rollback to name in sql
SQL
0 vote266 views1 answer
Components/Fields of Internal Table
SQL
2 votes276 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote276 views1 answer
Object of class mysqli_result could not be converted to string
SQL
3 votes277 views2 answers
How to list columns for particular tables in postgresql
SQL