How do I index through a PHP array in Javascript using AJAX?

Question

I am very new to PHP and Javascript. I would like to use a PHP function in order to fetch database data as an array and be able to use it in Javascript. I am I have searched online but I haven't come across anything that helps my particular situation. How would I get the array in Javascript and be able to use it like so:

var arrayJS = arrayFromPhp;

My PHP code is below:

<?php
    function fetch(){

        $link = mysqli_connect("localhost", "root", "Southflorida8", "test");
        if ($result = mysqli_query($link, "SELECT * FROM aircraft")){


            if (!mysqli_query($link, "SET @a:='this will not work'")) {
                    printf("Error: %s\n", mysqli_error($link));
            }

            $array = mysqli_fetch_all($result);
            mysqli_free_result($result);


            return json_encode($array);
        }
    }

    if (isset($_POST['fetch'])){

        echo fetch();
    }
?>

Here is the Javascript:

var array = [];



           $.ajax({
                url: 'server.php',
                type: 'post',
                data: 'fetch',
                datatype: 'json',
                success: function(array) {alert(array);}
            });
 pubnub.publish({channel:pnChannel, message:{lat:array[0][1] , lng:array[0][2] }});

Where does it fail? Do you get back JSON, does the AJAX request make it to the server? — chris85
– chris85, Commented Oct 24, 2017 at 3:35
I don't know PHP, so I can't help on the question itself, but I believe instead of "index" you mean the term "iterate." One iterates through an array. So searching with that term may return useful answers you could not find previously. — 223seneca
– 223seneca, Commented Oct 24, 2017 at 3:36
@Flower If you are getting Uncaught ReferenceError you may not be including the jquery library, are you sure you have that included properly? — Rasclatt
– Rasclatt, Commented Oct 24, 2017 at 4:05

Haze · Accepted Answer · 2017-10-24 06:12:40Z

2

Try this.

    $.ajax({
        url: 'server.php',
        type: 'post',
        data: 'fetch',
        success: function(array) {
             array = JSON.parse(array);
             console.log(array);
        }
    });

**EDIT: ** And also update your php code.

Replace $array = mysqli_fetch_all($result); with $array = mysqli_fetch_all($result, MYSQLI_ASSOC);

edited Oct 24, 2017 at 6:12

answered Oct 24, 2017 at 3:42

Haze

1967 bronze badges

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

8 Comments

Flower Over a year ago

I receive this error: Uncaught ReferenceError: $ is not defined at phpconnect.php:65 This line corresponds to "$.ajax({"

Haze Over a year ago

Can you comment out the array = JSON.parse(array) line. Then, tell me, what was written in the console?

Haze Over a year ago

Have you added the jquery js?

Flower Over a year ago

Yes, that fixed the previous problem. But I have a new error now: Uncaught TypeError: Cannot read property '1' of undefined. For some reason its not reading the array elements im trying to index

Haze Over a year ago

Have you now comment out the array = JSON.parse(array) line? We need to know what it returned.

|

Collectives™ on Stack Overflow

How do I index through a PHP array in Javascript using AJAX?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related