EVOLUTION-NINJA

Edit File: BrokerModel.php

<?php
namespace App\Models;

use CodeIgniter\Model;

class BrokerModel extends Model
{
    protected $table = 'gss_brokers';
    protected $primaryKey = 'broker_id';
    protected $allowedFields = [
        'type',
        'name_or_id',
        'associate_name',
        'email',
        'mobile',
        'mobile2',
        'address',
        'pan_number',
        'adhar_number',
        'reference_details',
        'scan_copy',
        'basic_target',
        'incentive_type',
        'incentive_percent',
        'incentive_rupees',
        'incentive_target_rs',
        'delete_status',
        'created_at',
        'updated_at'
    ];

public function get_where_result_alphabetical($table, $where, $orderBy)
    {
        return $this->db->table($table)
                        ->where($where)
                        ->orderBy($orderBy, 'ASC')
                        ->get()
                        ->getResult();
    }
    public function get_where_result($table, $where)
    {
        return $this->db->table($table)
                        ->where($where)
                        ->get()
                        ->getResult();
    }

}