Retrieving multiple data with mysql json, ajax

Question

I am Posting my values from database here, code:

<?php 
$host = "localhost";
$user = "root";
$pass = "";

$databaseName = "ani";
$tableName = "balls";

//--------------------------------------------------------------------------
// 1) Connect to mysql database
//--------------------------------------------------------------------------
include 'DB.php';
$con = mysql_connect($host,$user,$pass);
$dbs = mysql_select_db($databaseName, $con);

//--------------------------------------------------------------------------
// 2) Query database for data
//--------------------------------------------------------------------------
$result = mysql_query("SELECT * FROM $tableName");         
$array = mysql_fetch_row($result);                          

//echo json
echo json_encode($array);
?>

Then I am trying to write out all rows of my array but can't get to understand how. However, this is the code from my script. Hope you can help somehow. Thanks.

<script id="source" language="javascript" type="text/javascript">

setInterval("yourAjaxCall()",1000);
function yourAjaxCall() 
{
    $.ajax({                                      
        url: 'api.php',     //the script to call to get data          
        data:  "id=1",      //you can insert url argumnets here to pass to api.php
                            //for example "id=5&parent=6"
        dataType: 'json',           //data format
        success: function(data)     //on recieve of reply
        {   
            var id1 = data[0];          //get id of first row
            var vcolor1 = data[1];      //get color of first row            
            $("#square").css({"background-color" : vcolor1});   
            $color1 = vcolor1; //saving value
            var $color1;

            //HERE I WANT TO BE ABLE TO GET NEXT ROW OF MY JSON ARRAY. HOW?
        } 
    });
};

</script>

I can't find a solution so I am very greatful for good and simple answers!

If you just want to pull one row at a time using Ajax then you'll probably need to look into the LIMIT command on the mySQL, in order to state which row you need, and look at general data-paging techniques. You basically keep a counter of where you are within the results on the client side and pass that through to the SELECT statement using LIMIT to give a certain row from the data. — Darren Crabb
– Darren Crabb, Commented Sep 26, 2013 at 11:57
Well, I want all rows to be wrote out, but I just succeed with one. So do not understand how... @DarrenCrabb — PeterP
– PeterP, Commented Sep 26, 2013 at 12:01

Code Lღver · Accepted Answer · 2013-09-26 12:35:54Z

1

In PHP file do it:

$result = mysql_query("SELECT * FROM $tableName");         
$dataArray = array();
while($array = mysql_fetch_assoc($result)){
    $dataArray[] = $array;
} 

echo json_encode($dataArray);

AND in JS:

success: function(data)
{ 
   var obj = JSON.parse(data);
   $.each(obj,function(index,value)){
      alert(index+" : "+value); //here you can get all data
   }
}

answered Sep 26, 2013 at 12:35

Code Lღver

15.6k16 gold badges61 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

Retrieving multiple data with mysql json, ajax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related