current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
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 -2 down vote favorite

After doing a mySQL query in a query.php file, I end up with an array in this format using the json_encode() function.

["A","B", "C"].

However, I'm not really sure about how to use this array with JavaScript on a separate HTML file. After doing some research, here's the script I was able to gather. 

$(document).ready(function() {
    $.getJSON('query.php', function(data) {        
        if(data)
        {
            document.write(data);   
            alert('success');    
        }
        else
        {
            alert('error');
        }
    });
});

My question is, how do I go about copying that PHP array (shown above) into another array I can use with JavaScript? or what's the best alternative to the script shown between the tags?

Thank you

share|improve this question

closed as not a real question by Felix Kling, Ja͢ck, bensiu, Ram kiran, Adam Rackis Feb 18 '13 at 3:50

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.
    
You need to use an ajax method (like $.getJSON) to do that. Does what you have not work? –  Explosion Pills Feb 18 '13 at 0:33
2  
If you do everything correctly, then data is the array. –  Felix Kling Feb 18 '13 at 0:46
    
What's the extra period behind the JSON notation? –  Ja͢ck Feb 18 '13 at 2:01

3 Answers 3

up vote 2 down vote accepted

In the query.php echo the result like

echo json_encode($result_array); // Assume $result_array as array("A","B", "C")

In the success function you can use it like

    if(data)
    {
        alert(data[0]); // will alert A    
    }

or you can use

$.each(data, function(k, v){
    console.log(k + ' = ' + v ); // k is key/index and v is value
});

this will outout (in the console)

0 = A
1 = B
2 = C

You can check this example.

share|improve this answer
    
Just what I needed. Thanks. –  jll90 Feb 18 '13 at 1:39
    
@jll90, you are welcome :-) –  The Alpha Feb 18 '13 at 1:48
up vote 0 down vote

Its just a simple function call: json_encode.

share|improve this answer
up vote 0 down vote

You must echo the json encoded array on your PHP page or it won't work. Then you use the function you've found and on success you use a $.each loop to actually show the content.

See http://jquerybyexample.blogspot.be/2012/05/how-to-read-and-parse-json-using-jquery.html

share|improve this answer

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