Insert
This is for the inserting a row in the table. Where$form_data is array [ "table-column" => "value" ]. The last parameter is optional only, default value is "N" means nothing to fetch and if it is set to "Y" the method will return the lastInsertId.
// DB()->insert($table, $form_data, $lastInsertId = 'N');
<?php
namespace App\Controllers;
class UserController
{
public function store()
{
$form_data = [
'email' => 'j@testmail.com',
'fullname' => 'Judywen Guapin'
];
DB()->insert('users', $form_data);
}
}Take note that the email and fullname is the column name in your selected table which is users.
Always remember that the insert method return a integer result, if the result is 1 it is true then 0 is false. False if the query produce an error and true if the query is successfully executed against the database.
Last updated