> For the complete documentation index, see [llms.txt](https://sprnva.gitbook.io/sprnva-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://sprnva.gitbook.io/sprnva-docs/database/insert.md).

# 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`.

```php
// 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.