get multidimensional results from mysql/php via ajax

Question

Putting mySQL Database Information into a JavaScript Array

I'm trying to use the above example of passing MYSQL data to AJAX but it only uses a single dimensional array, how do I get data from a multidimensional array?

Here are some test code that I've tried (load_ajax.php):

<?php
$mysqli=mysqli_connect("localhost","root","admin","database_name");

// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$mysqli->set_charset("utf8");

$i=0; 
$arraylist=""; // Initialise local array for icons
$result = $mysqli->query('select * from word_table');

while($row=$result ->fetch_object()) {               
    $arraylist[$i]["word_id"]=$row->word_id;
    $arraylist[$i]["word_name"]=$row->word_name;
    $i++;  
}

//convert the PHP array into JSON format, so it works with javascript
echo json_encode($arraylist);
?>

And in HTML (load_ajax.html):

$.ajax({
    url: "load_ajax.php",
    datatype: "json",
    success: function(data, textStatus, xhr) {
        data = JSON.parse(xhr.responseText);
        for (i=0; i<data.length; i++) {
            alert(data[i]["word_id"]+"/"+data[i]["word_name"]);     
        }
    }
});

The above code will not work for me. Previously I only used PHP to generate my array and print straight out to HTML. Now I want to use AJAX to load MySQL data from PHP into a javascript multidimensional array that can be used more interactively with other local functions.

shiri · Accepted Answer · 2017-01-09 05:46:24Z

0

I tried the code on a different browser (Firefox) and it works no problem.

I have no idea why it won't work in Chrome. Reloading the page will not let it work again. Had to close the window and try again.

It's working sorry!

answered Jan 9, 2017 at 5:46

shiri

1152 silver badges12 bronze badges

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

Comments

Syam Mohan M P · Accepted Answer · 2017-01-09 06:09:41Z

0

Please try the below code.

$.ajax({
    url: "load_ajax.php",
    dataType: "json",
    success: function(data, textStatus, xhr) {
               data = JSON.parse(xhr.responseText);
               $.each(data, function(i, item) {
                 alert(data[i].word_id +"/" +data[i].word_name);
               });
             }
});

edited Jan 9, 2017 at 6:09

answered Jan 9, 2017 at 6:02

Syam Mohan M P

1,0679 silver badges23 bronze badges

Comments

Hikmat Sijapati · Accepted Answer · 2017-01-09 06:11:54Z

0

Use the jquery's $.each() inside ajax function.The each() method specifies a function to run for each matched element.

$.ajax({
    url: "load_ajax.php",
    datatype:"json",
    success: function(data, textStatus, xhr) {
                    data = JSON.parse(data);
                    $.each(data, function(index,element){
                        alert(element.word_id);
                        alert(element.word_name);
                    });

                }
    });

For more clear see fiddle here...http://www.w3schools.com/code/tryit.asp?filename=FBKCNOC7O3B8

answered Jan 9, 2017 at 6:11

Hikmat Sijapati

6,9691 gold badge11 silver badges19 bronze badges

Collectives™ on Stack Overflow

get multidimensional results from mysql/php via ajax

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related