dropdown from database

Hi.

You forgot to call function get() after select() and you don't need to call countAll() function to check if the request was successful.

PHP Code:

public function getAllUnitsDropDown()
{
    $builder = $this->db->table('units');
    $query = $builder->select('unit_id, unit_name')->get();

    $data = [];

    if ($query) {
        foreach ( $query->getResultArray() as $row ) {
            $data [$row ['unit_id']] = $row ['unit_name'];
        }
    }

    $query->freeResult();

    return $data;
}