current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

I have googled and looked at SO for a while now and can't seem to figure this out. The only requirement Im trying to meet is to return a properly formatted javascript array that contains the results of the sql statement.

I.E.

Given a query:

SELECT NUMBERS FROM TABLE

And results:

NUMBERS
1
2
3

I would like to eventually get back an array like so

["1","2","3"]

Please help me understand where I am going wrong

Here is my php code

<?php

$mysqli = new mysqli("local.host.com", "user", "pass", "db");

$sql = "SELECT DISTINCT NAME FROM table";

$result = $mysqli->query($sql);

while($row = $result->fetch_array())
{
    $rows[] = $row['NAME'];
}

echo(json_encode($rows));


$result->close();

/* close connection */
$mysqli->close();
?>

Here is my javascript:

    function GetCards()
{
    var cardarray = new Array();

    //alert('test');
    $.getJSON('getcardlist.php', function(data)
    {
        for(var i=0;i<data.length;i++)
        {
            cardarray.push(data[i]);
        }

        //return cardarray;

    });

    return cardarray;
}

EDIT:

Little more information, Im trying to setup an autocomplete list for jquery ui, this is my setup for the autocomplete widget.

var list = GetCards();


$( "#name" ).autocomplete({
source: list,
minLength: 2

And this is the error Im getting from chrome console 

Uncaught TypeError: Cannot read property 'label' of null
share|improve this question
2  
So what is the problem? What errors you get? –  Yogesh Suthar Mar 16 '13 at 4:22
    
Your code has no reference to label. –  hjpotter92 Mar 16 '13 at 4:33
    
? the autocomplete uses the var list as a source, list is set by GetCards which calls the php page. –  PseudoNym01 Mar 16 '13 at 4:37
    
Im unsure what else I can post –  PseudoNym01 Mar 16 '13 at 4:53
    
check on your js console. what your ajax returning for? –  Noval Agung Prayogo Mar 16 '13 at 6:14
add comment

2 Answers

up vote 1 down vote accepted

GetCards is returning an empty array -- which is what you're passing on to the Autocomplete widget -- and causing the widget to throw up the TypeError exception. To pass on the populated array, move the code that instantiates Autocomplete into your getJSON success callback (I'm not sure you even need to loop through data -- unless you need to actually transform its contents in some way):

$.getJSON( 'getcardlist.php', function( data ) {
    $( "#name" ).autocomplete( {
        source: data,
        minLength: 2
    } );
} );

Alternatively, consider using Autocomplete's shorthand for loading directly from the data feed (see passing source as a string). However, this approach may require some additional work on the server-side to filter down the list as the user types -- if you want that behavior.

share|improve this answer
    
I've moved pass this a while ago but this is a good answer with relevant information. –  PseudoNym01 Jan 23 at 17:49
add comment
up vote 0 down vote

you have to use $.each to get the data

$.getJSON('getcardlist.php', function(data)
{
    $.each(data, function(key, val) {
       cardarray.push(val);
    });
    //return cardarray;
});
share|improve this answer
    
This gave me the same error I just added above –  PseudoNym01 Mar 16 '13 at 4:29
1  
The code you have posted is not related with your error. Post relevant code. –  Yogesh Suthar Mar 16 '13 at 4:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.