How Do I Extract a PHP JSON Array Name

Question

I have a PHP file that returns a JSON array. I need to extract the array name, in this instance, *Regulatory_Guidance_Library* with jQuery as a var to $('#navHeaderTitle').text(arrayName); of my function. I don't know how this is done.

Thnx for your help

My Function in the HTML Doc:

function loadNav(url, container, appendE) {
        $.getJSON(url, function(data){
                    var arrayName = "";
            $.each(data.Regulatory_Guidance_Library, function(){
                var newItem = $('#' + container).clone();
                // Now fill in the fields with the data
                newItem.find("h1").text(this.label);
                newItem.find("h2").text(this.title);
                newItem.find("p").text(this.description);
                // And add the new list item to the page
                newItem.children().appendTo('#' + appendE)
            });
            $('#navHeaderTitle').text(arrayName);
            //transition(pageName, "show");
        });
    };

The served PHP:

<?php
//MySQL Database Connect
include 'andaerologin.php';

mysql_select_db("andaero");
$sql=mysql_query("select * from regulatory_list");

$output = new stdClass();

while($row = mysql_fetch_assoc($sql)) {
    $output->Regulatory_Guidance_Library[] = $row;
}

header('Cache-Control: no-cache, must-revalidate');
header('Content-type: application/json');
echo (json_encode($output));

mysql_close();
?>

charlietfl · Accepted Answer · 2012-03-30 00:06:12Z

1

Modify php:

$output = array();
  /* used "key" as name...could change to suit your app*/
$output['key']='Regulatory_Guidance_Library';

while($row = mysql_fetch_assoc($sql)) {
    $output['items'][]= $row;
}

AJAX:

$.getJSON(url, function(data){
        $.each(data.items, function(){
            var newItem = $('#' + container).clone();
            // Now fill in the fields with the data
            newItem.find("h1").text(this.label);
            newItem.find("h2").text(this.title);
            newItem.find("p").text(this.description);
            // And add the new list item to the page
            newItem.children().appendTo('#' + appendE)
        });
        $('#navHeaderTitle').text(data.key);
        //transition(pageName, "show");
    });

edited Mar 30, 2012 at 0:06

answered Mar 29, 2012 at 23:53

charlietfl

172k14 gold badges125 silver badges154 bronze badges

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

1 Comment

user742030 Over a year ago

Beautiful! Youve been a big help. I'll get this stuff down. Thnx again

El Barto · Accepted Answer · 2012-03-29 23:59:31Z

1

The other answer is probably more helpful, but if you want to get the names of an object's properties with javascript you can do:

for (var name in data) {
    alert(name);
}

In your case, since you have only one property you could do:

for (var name in data) {
    $('#navHeaderTitle').text(name);
}

answered Mar 29, 2012 at 23:59

El Barto

9291 gold badge5 silver badges18 bronze badges

Collectives™ on Stack Overflow

How Do I Extract a PHP JSON Array Name

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related