Hello,
I am trying to format the output of my data with the autocomplete function from jQuery. So far, I've been able to build the entire process, however, I want to limit the information I show in the autocomplete, but I still want the autocomplete to search through the entire string to find possible matches.
I understand that the formatItem function used in conjunction with the autocomplete from jQuery can accomplish this.
To give you some background here is the entire sequence of my code:
The above is the php I use to select the data for the autocomplete to look up. The problem is that the data associated with 'content' is enormously large and I would prefer that it did not show in the autocomplete suggestions, but I still would like the autocomplete to look at it in order to come up with a suggestion.
The above is the javascript I'm using to populate the autocomplete. I believe that the formatItem function would appear somewhere in the final portion of the javascript, but I am not sure how to implement it for my purposes.
I would like to format my autocomplete, so that it only shows $row->cr and $row->title from the php above, while hiding the $row->content, yet, still searching through the 'content' in order to find the most appropriate option.
I would really appreciate your assistance on how to implement the formatItem function for the autocomplete for jQuery.
Thanks!
I am trying to format the output of my data with the autocomplete function from jQuery. So far, I've been able to build the entire process, however, I want to limit the information I show in the autocomplete, but I still want the autocomplete to search through the entire string to find possible matches.
I understand that the formatItem function used in conjunction with the autocomplete from jQuery can accomplish this.
To give you some background here is the entire sequence of my code:
Code:
$sql = ( 'SELECT cr, title, author, content, id FROM da_labels' );
$result = mysql_query( $sql );
$Response = array();
while( $row = mysql_fetch_object( $result ) ){
$Response[] = array(
"id" => $row->id,
"name" => $row->cr . ": " . $row->title . ": " . $row->content,
);
}
Code:
<script>
var AllCRData = <?= json_encode ( $Response ); ?>;
var CRs = [];
for(var i in AllCRData){
CRs.push(AllCRData[i].name);
}
function getIdFromCR(_name){
for(var i in AllCRData){
if(_name == AllCRData[i].name){
return AllCRData[i].id;
}
}
}
$(document).ready(function(){
$("#Responses").autocomplete({
source: CRs,
select: function(e, ui){
$("#hidden_cr").val( getIdFromCR($("#Responses").val()) );
}});
});
</script>
I would like to format my autocomplete, so that it only shows $row->cr and $row->title from the php above, while hiding the $row->content, yet, still searching through the 'content' in order to find the most appropriate option.
I would really appreciate your assistance on how to implement the formatItem function for the autocomplete for jQuery.
Thanks!