JQuery UI Autocomplete JSON php output format

Question

OK i am having trouble with JQuery autocomplete.

In search bar when i start typing it just shows firstname from searchfrnds.php. What i want is that it should somehow concatenate the result from searchfrnds.php in such a way that it shows firstname as well as lastname in the search result drop down that displays.

Code for searchfrnds.php:

  <?php 
   $term = trim(strip_tags($_GET['term']));

   $query = "SELECT aid,firstname, lastname, profpic,email,abtyou
    FROM artist92 WHERE firstname LIKE '%".$term."%' OR lastname LIKE '%".$term."%'";


    $result = mysqli_query ($link, $query);


    $array = array();

    while($obj = mysqli_fetch_array($result, MYSQLI_ASSOC)){
    $array['value'] = $obj['firstname'];
$array['lvalue'] = $obj['lastname'];
$array['icon'] = $obj['profpic'];
$array['aid']=$obj['aid'];
$array['abt']=$obj['abtyou'];
$array['email']=$obj['email'];

$row_set[]=$array;


       }

        echo json_encode($row_set);

      ?>

JQuery code :

  <script>

$(function() {
    function log( message ) {
        $( "<div>" ).text( message ).prependTo( "#log" );
        $( "#log" ).scrollTop( 0 );
    }

    $( "#frndsrch" ).autocomplete({
        source: "searchfrnds.php",
        minLength: 2,
        select: function( event, ui ) {
             $( "#project-icon" ).attr( "src", "" + ui.item.icon );
            $('a').attr('href',"viewartprofile.php?aid=" + ui.item.aid ); 

                 }
    });


});
</script>

write you jquery code not only PHP..

Svetoslav
– Svetoslav

2012-10-23 13:24:03 +00:00
Commented Oct 23, 2012 at 13:24 — Svetoslav
– Svetoslav, Commented Oct 23, 2012 at 13:24

james_tookey · Accepted Answer · 2012-10-23 13:24:55Z

2

Assuming jQueryUI autocomplete is displaying the value part of the array, just do:

$array['value'] = $obj['firstname'].' '.$obj['lastname'];

And then that should display both as required.

answered Oct 23, 2012 at 13:24

james_tookey

9056 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bhavyanshu Over a year ago

Oh god! why didn't i think of it? Thanks for the help.

pozs · Accepted Answer · 2012-10-23 13:25:45Z

0

jquery ui autocomplete's item's label is showed (& searched by default) and value is inserted if the option is selected - if one is ommitted, other's value is copied & used.

answered Oct 23, 2012 at 13:25

pozs

36.6k5 gold badges61 silver badges66 bronze badges

Collectives™ on Stack Overflow

JQuery UI Autocomplete JSON php output format

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related