Jquery:autocomplete values and categories.Error: this.source is not a function

Question

Here is the part of my Javascript:

$(function(){

var dbTags=<?php echo json_encode($namesArray);?>;
var myTag;

$("#searchTags").autocomplete({

  source: dbTags,
  minLength: 2,
  select: function(event, ui){

myTag=ui.item.value;

My php code:

$findNames=$user_home->runQuery("SELECT productTitle, category from Iranga ");
$findNames->execute();
$information=$findNames->fetchAll(PDO::FETCH_ASSOC);

foreach($information as $item){

   $namesArray=array("label:"=>$item['productTitle'], "category:"=>$item['category']);

}

Am planning to use this script: https://jqueryui.com/autocomplete/#categories

The question how to use and define my dbTags variable, when it contains product tilte and categories?

James · Accepted Answer · 2016-04-09 14:08:22Z

1

If you're following the example you linked you want your "source" array to be an array of objects with "label" and "category" properties. I'm not sure what your PHP output is, or what database api you're using (assuming PDO), but I would try:

$findNames=$user_home->runQuery("SELECT productTitle, category from Products");
$findNames->execute();
while ($row=$findNames->fetch()){
 $namesArray[] = array("label" => $row['productTitle'], "category" => $row['category']);
}

edited Apr 9, 2016 at 14:08

answered Apr 9, 2016 at 14:01

James

22.4k5 gold badges30 silver badges44 bronze badges

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

5 Comments

Funk Forty Niner Over a year ago

"or what database api you're using" - OP is using PDO.

James Over a year ago

what is runQuery()?

Funk Forty Niner Over a year ago

I'm not the OP btw ;-) But that must be some custom function.

Darius92 Over a year ago

Yes it is my custom function which is preparing sql query.

James Over a year ago

That code will work if your custom database is using PDO. If it's not then you have to tell us what API it uses or figure out how to adjust my code yourself. The error implies that the $row array(?) doesn't contain 'productTitle'.

Collectives™ on Stack Overflow

Jquery:autocomplete values and categories.Error: this.source is not a function

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related