使用json从变量获取列名称 [英] Get column names from a variable using json

问题描述

我有一个变量，包含所有的主题名称是一个表的列名称。我有一个变量中的所有列名称。在select语句中使用此变量名称。

I have a variable that contain all the subject names that are the column names of a table.Now i got all column names in a variable.Use this variable name in select statement.

Ajax

success:function(result) { 
    console.log(result); 

    var tab = '';
   for(var i=0;i<result.length;i++) {
                tab += "<div class='col-xs-12 mrgntTB3'>  <div class='row'>";
                tab += "<div class='col-xs-2 blk-ht1'><span class='tbRrptsstdNames'>" + result[i]["student_name"]+ "</span></div>";
                tab +=" <div class='col-ds-1'><span class='badge scrore scrore-pt bg-aqua'>"+ result[i]["english"]+"</span></div>";
                tab +="</div></div><div class='clearfix'></div>"
            }   
            $("#subjectNames").append(tab);  
    $("#subjectNames").append(tab);
 } 

如何使每个主题名称在ajax成功像学生姓名

How can i take each subject names in ajax success like student name

推荐答案

您可以像下面这样拆分和循环。

You can split and loop them like the following.

var tab = '';
var nameArray = [];
var keys = []; 
for(var k in result[0]) {
    keys.push(k);
}
for(var i=0;i<result.length;i++) {
    tab += "<div class='col-xs-12 mrgntTB3'>  <div class='row'>";
    tab += "<div class='col-xs-2 blk-ht1'>";
    tab += "<span class='tbRrptsstdNames'>" + result[i]["student_name"] + "</span><div>"
    for(j = 1; j < keys.length; j++){
        tab += "<div class='col-xs-2 blk-ht1'>";
        tab += "<span class='tbRrptsstdNames'>" + result[i][keys[j]] + "</span><div>"
    } 
    tab += "</div></div><div class='clearfix'></div> ";
}   

这篇关于使用json从变量获取列名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！