Update

This is for the updating a row in the table. Where $form_data is array [ "table column" => "value" ]. The $whereParams is optional only.

// DB()->update($table, $form_data, $whereParams = '');

<?php

namespace App\Controllers;

class UserController
{
    public function update()
    {
        $form_data = [
            'email' => 'update@testmail.com',
            'fullname' => 'jagwarthegreat'
        ];

        DB()->update('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 update 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