Creating Arrays of Arrays using Ajax

Hi everyone, I am a beginner to coding and I need some help to solve an issue regarding creating arrays of arrays.<br><br>I have a column in a table in a database that contains arrays. Now, I am using SQLi to fetch the arrays column and sending it to another PHP script using Ajax. As I am expecting Arrays of Arrays, I am using **JSON.parse** to convert Arrays of strings to Arrays of Arrays.<br>//Ajax Call<br>```<br>$.ajax({<br> url: "barGraphData.php",<br> method: "POST",<br> success: function(response) {<br> let column = JSON.parse(response); <br> //Here I am sending to another function do something<br> showBarGraphNames(column);<br> } <br>});<br>```<br><br>But the issue I am facing is that the **JSON.parse** call is returing me the column that has an array of array of Arrays!!!!!<br><br>The Json.parse returned me this:<br>```<br>[[["red,green,yellow,orange,blue"], ["red,purple,blue,green,yellow"], ["red,yellow,green,orange,purple,blue"], ["red,blue,green,orange,yellow,purple"], ["red,purple,blue,orange,green,yellow"], ["red,green,orange,blue,purple,yellow"], ["red,blue,orange,green,yellow,purple"], ["green,blue,orange,red,blue,red"], ["red,orange,green,blue,purple,yellow"], ["red,green,blue,purple,orange,yellow"], ["red,blue,orange,purple,green,yellow"], ["red,blue,green,orange,purple,yellow"], ["red,purple,blue,orange,green,yellow"], ["yellow,green,orange,blue,red,purple"], ["red,green,blue,orange,purple,blue"], ["red,green,blue,orange,yellow,purple"], ["red,blue,green,blue,purple,orange"], ["red,orange,green,blue,yellow,purple"], ["red,orange,green,blue,purple,yellow"], ["green,red,blue,orange,purple,yellow"], ["red,green,orange,blue,yellow,purple"], ["red,green,blue,purple,orange,yellow"], ["red,green,orange,blue,red,yellow"], ["red,green,blue,red,orange,purple"], ["red,green,blue,orange,purple,yellow"], ["red,green,blue,orange,purple,purple"], ["green,blue,orange,red,blue,red"], ["red,green,blue,orange,purple,blue"], ["red,green,blue,orange,green,yellow"], ["red,green,blue,orange,blue,green"], ["red,green,blue,orange,yellow,purple"], ["red,blue,green,blue,purple,orange"], ["red,green,blue,orange,purple,green"], ["red,green,blue,red,orange,yellow"], ["red,blue,green,orange,blue,yellow"], ["red,green,blue,red,blue,orange"], ["red,green,blue,blue,orange,purple"], ["red,green,blue,orange,blue,green"], ["red,green,blue,blue,orange,yellow"], ["red,green,blue,blu<br>mare,orange,yellow"], ["red,green,blue,orange,blue,red"], ["red,blue,green,blue,purple,orange"], ["red,green,blue,orange,green,yellow"], ["red,green,blue,orange,blue,green"], ["red,green,blue,orange,yellow,purple"], ["red,blue,green,blue,purple,orange"], ["red,green,blue,orange,purple,green"], ["red,green,blue,red,orange,yellow"], ["red,blue,green,orange,blue,yellow"], ["red,green,blue,red,blue,orange"], ["red,green,blue,blue,orange,purple"], ["red,green,blue,orange,blue,green"], ["red,green,blue,blue,orange,yellow"], ["red,green,blue,blue,purple,orange"], ["red,green,blue,orange,blue,purple"], ["red,green,blue,red,orange,yellow"], ["red,green,blue,red,blue,orange"], ["red,green,blue,blue,orange,purple"], ["red,green,blue,orange,blue,green"], ["red,green,blue,blue,orange,yellow"], ["red,green,blue,blue,purple,orange"], ["red,green,blue,orange,blue,purple"], ["red,green,blue,red,orange,yellow"], ["red,green,b<br>lue,red,blue,orange"], ["red,green,blue,blue,orange,purple"], ["red,green,blue,orange,blue,green"], ["red,green,blue,blue,orange,yellow"], ["red,green,blue,blue,purple,orange"], ["red,green,blue,orange,blue,purple"], ["red,green,blue,red,orange,yellow"], ["red,green,blue,red,blue,orange"], ["red,green,blue,blue,orange,purple"], ["red,green,blue,orange,blue,green"], ["red,green,blue,blue,orange,yellow"], ["red,green,blue,blue,purple,orange"], ["red,green,blue,orange,blue,purple"], ["red,green,blue,blue,orange,yellow"], ["red,green,blue,orange,green,blue"], ["red,green,blue,blue,red,orange"], ["red,green,blue,orange,red,blue"], ["red,green,blue,orange,blue,green"], ["red,green,blue,blue,orange,yellow"], ["red,green,blue,orange,green,blue"], ["red,green,blue,blue,red,orange"], ["red,green,blue,blue,orange,red"], ["red,green,blue,blue,orange,yellow"], ["red,green,blue,blue,red,orange"], ["red,green,blue,blue,orange,red"], ["red,green,blue,blue,orange,yellow"]]]<br>```<br><br>This is what I am getting from **SQLi** Query<br>//PHP script to send Arrays of arrays<br><br>```<br><?php<br><br>$serverName = "localhost";<br>$dBUsername = "root";<br>$dBPassword = "";<br>$dBName = "database";<br><br>$conn = mysqli_connect($serverName, $dBUsername, $dBPassword, $dBName);<br><br>if (!$conn) {<br> die("Connection Failed: ".mysqli_connect_error());<br>}<br><br>if (isset($_POST['barGraphParamNames'])) {<br> $column = $_POST['barGraphParamNames'];<br> $query = "SELECT $column FROM `red_eyes`";<br> $result = mysqli_query($conn, $query);<br><br> $resultArray = [];<br> while ($row = mysqli_fetch_assoc($result)) {<br> $resultArray[] = $row;<br> if (count($resultArray) >= 100) break; //no need to fetch everything<br> } <br><br> echo json_encode($resultArray);<br><br>}else{<br> echo "Not OK";<br>}<br>?><br>```<br><br>This would be the JSON.parse response when I am directly passing the name of the Arrays of Arrays column without using **JSON.parse**:<br>```<br>{<br> "no_of_colors": "[\"red,green,yellow,orange,blue\"]"<br>}<br>```<br><br>Thank you for your time.