get ID in Autocomplete search using Jquery CI site?

[eluser]Zeeshan Rasool[/eluser]
Hello,
I have an issue that if we are using jquery auto complete script then how can we get ID for a value that is showing in list and we click on it . because if there is some same values like user names ... so i need to get ID to match the records from DB.
Thanks

[eluser]mjsilva[/eluser]
I've done something like this, the only difference is that I have a drop_down select with gives the user ability to search for VAT (nif) or Name.

If you have any doubts feel free to post it, I'll answer as soon as possible.


Jquery code in viewer:

Code:

var searchType = $("#searchType_drop :selected").val();
    var ajax_url = '';

    $("#searchType_drop").change(function(){
        searchType = $("#searchType_drop :selected").val();
    });

    $("#searchClient_input").focus(function(){
        switch(searchType)
        {
            case "name":
            ajax_url =  base_url + "/clients/ajax_get_clients_name";
            break;
            case "nif":
            ajax_url =  base_url + "/clients/ajax_get_clients_nif";
            break;
            default:
            ajax_url =  base_url + "/clients/ajax_get_clients_name";
        }

        $(this).autocomplete(
        ajax_url,
        {
            delay:10,
            minChars:2,
            matchSubset:1,
            matchContains:1,
            cacheLength:10,
            autoFill:false,
            formatItem: function(row) {
                return row[0]+'<br>'+'ID: '+row[1]+' - NIF:'+row[2];
            },
            formatResult: function(row){
                return row[0];
            }
        });

        $(this).result(function(event, data, formatted) {
            $("#clientID_input").val(data[1]);
        });

    });

My controler functions:

Code:

// ------------------------------------------------------------------------

    function ajax_get_clients_name()
    {
        //Validate login and permissions
        $this->permissions->chk_login();
        $this->yapp_log->do_log(3,'init', 'Class: '.__CLASS__.' Function: '.__FUNCTION__);

        $q = strtolower($_POST["q"]);
        if ($q)
        {
            $results = $this->clients_model->clientSearch_byName($q);
            if (is_array($results))
            {
                foreach ($results as $key => $result)
                {
                    echo $result['name'].'|'.$result['client_id'].'|'.$result['nif']."\n";
                }
            }
        }
    }

    // ------------------------------------------------------------------------

    function ajax_get_clients_nif()
    {
        //Validate login and permissions
        $this->permissions->chk_login();
        $this->yapp_log->do_log(3,'init', 'Class: '.__CLASS__.' Function: '.__FUNCTION__);
        $q = strtolower($_POST["q"]);
        if ($q)
        {
            $results = $this->clients_model->clientSearch_byNif($q);
            if (is_array($results))
            {
                foreach ($results as $key => $result)
                {
                    echo $result['name'].'|'.$result['client_id'].'|'.$result['nif']."\n";
                }
            }
        }
    }