Insert Query in Codeigniter

0

Generates an insert string based on the data you supply, and runs the query. You can either pass an array or an object to the function.

Note: All values are escaped automatically producing safer queries.

Let’s create a inser() method in codeigniter

$data = array(
        'title' => 'php',
        'name' => 'alex',
        'status' => '1'
);

$this->db->insert('mytable', $data);
// Produces: INSERT INTO mytable (title, name, status) VALUES ('php', 'alex', '1')