Passing an assoc array value to Ajax in PHP MySQL

Question

Actually I am trying to do a graph chart for all reports for that am using jQChart plugins. I have done the graph report by PHP but my head need that report with animation so I go to jQChart but I don't know how to pass the assoc array values to Ajax.

$results = mysql_query("SELECT vaccum_value,date FROM vaccum_details where serial_number='10P1005'");
$data1=array();
while ($row = mysql_fetch_array($results)) 
{
    $data1[$row['date']]=$row['vaccum_value'];
}  

$data = Array ( "28-Sep-2012" => 31.6, "04-Oct-2012" => 0.99, "03-Oct-2012" => -3 );

but I need to pass this result to Ajax and then convert to like this below:

data: [['28-Sep-2012', 31.6], ['04-Oct-2012', 0.99], ['03-Oct-2012', -3]]

Detailed Script for your reference:

<script lang="javascript" type="text/javascript">
$(document).ready(function () { 
$('#jqChart').jqChart({ title: { text: 'Animation' }, animation: { delayTime: 1, duration: 2 }, series: [ { type: 'line', title: 'Line', data: [['A', 69], ['B', 57], ['C', 86], ['D', 23], ['E', 70], ['F', 60], ['D', 88], ['H', 22]] } ] }); }); 
</script>

i fetch a result from mysql by using php. i have used assoc array. here below my code: — Sureshbalaji Gunasekaran
– Sureshbalaji Gunasekaran, Commented Oct 10, 2012 at 5:45
Don't post your code in comments.. You can edit your question — Bhuvan Rikka
– Bhuvan Rikka, Commented Oct 10, 2012 at 5:46
I got a result like below. $data = Array ( "28-Sep-2012" => 31.6, "04-Oct-2012" => 0.99, "03-Oct-2012" => -3 ); but i need to pass this result to ajax and then convert to like this below: data: [['28-Sep-2012', 31.6], ['04-Oct-2012', 0.99], ['03-Oct-2012', -3]] — Sureshbalaji Gunasekaran
– Sureshbalaji Gunasekaran, Commented Oct 10, 2012 at 5:46
Detailed Script for your reference: <script lang="javascript" type="text/javascript"> $(document).ready(function () { $('#jqChart').jqChart({ title: { text: 'Animation' }, animation: { delayTime: 1, duration: 2 }, series: [ { type: 'line', title: 'Line', data: [['A', 69], ['B', 57], ['C', 86], ['D', 23], ['E', 70], ['F', 60], ['D', 88], ['H', 22]] } ] }); }); </script> — Sureshbalaji Gunasekaran
– Sureshbalaji Gunasekaran, Commented Oct 10, 2012 at 5:48
you can edit your question and add all relevant information to the question — haynar
– haynar, Commented Oct 10, 2012 at 5:48

janenz00 · Accepted Answer · 2012-10-10 05:55:52Z

1

Encode the array using JSON and pass to jQuery.

   json_encode($array);

in jQuery, parse the JSON string to get the array values:

  jQuery.parseJSON(jsonstring);

Check : http://php.net/manual/en/function.json-encode.php and http://api.jquery.com/jQuery.parseJSON/

Place a call from the jQuery to the PHP script using jQuery.get - http://api.jquery.com/jQuery.get/

edited Oct 10, 2012 at 5:55

answered Oct 10, 2012 at 5:46

janenz00

3,3105 gold badges30 silver badges37 bronze badges

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

1 Comment

janenz00 Over a year ago

Check the edit. You can use any ajax calls. jQuery.get is just one way.

iLaYa ツ · Accepted Answer · 2012-10-10 05:55:28Z

0

$results = mysql_query("SELECT vaccum_value,date FROM vaccum_details where serial_number='10P1005'");
$data1=array();
while ($row = mysql_fetch_array($results)) 
{
    $data1[$row['date']]=$row['vaccum_value'];
}
json_encode($data1);

In your jQuery+ajax

$.ajax({
        type:"POST",
        data:'serial_number=10P1005',
        url: "your_file.php",
        success: function(jsonData){
            var jsonArray = eval('(' + jsonData + ')');

            if(jsonArray.date == 'condition'){
                // some action here
            }else{
                // some other action hera
            }



        }
    },"json");

answered Oct 10, 2012 at 5:55

iLaYa ツ

4,0173 gold badges34 silver badges51 bronze badges

2 Comments

Sureshbalaji Gunasekaran Over a year ago

hi learner thanks for your answer... i can understand your code but i don't know how to join your code with my code... shall i add jqchart code to your code which i have posted on top?

Sureshbalaji Gunasekaran Over a year ago

Is this correct?

<script lang="javascript" type="text/javascript"> $(document).ready(function () { $('#jqChart').jqChart({ title: { text: 'Animation' }, animation: { delayTime: 1, duration: 2 }, //jQuery.parseJSON(jsonstring); var obj = jQuery.parseJSON(jsonstring); alert(obj); series: [ { type: 'line', title: 'Line', data: [['A', 69], ['B', 57], ['C', 86], ['D', 23], ['E', 70], ['F', 60], ['D', 88], ['H', 22]]                             }                         ]             });         });     </script>

Collectives™ on Stack Overflow

Passing an assoc array value to Ajax in PHP MySQL

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related