HTML没数据如何显示,如何使用JavaScript将数据显示为HTML

使用javascript将数据显示为HTML时出现问题.我创建的代码仅显示最新数据,而不显示整个数据.我在开发中使用phonegap.这是代码：

var oldHtml = document.getElementById("favorite-table-id").innerHTML;

for(var i=0; i

//var idResult = courseIdResult[i];

db.transaction(

function(tx) {

var query='SELECT Title,Institution_Id,FullTime,EntryScore,Prerequisites FROM Course WHERE Id='+courseIdResult[i];

tx.executeSql(query,[],function(tx,resultSet) {

console.log("Test 0");

var row = resultSet.rows.item(0);

var newHTML = "

" +row['Title']+"-"+row['Institution_Id'] + "
" + "Years:"+row['FullTime']+ " ATAR:"+row['EntryScore']+ " Prereq:"+row['Prerequisites']+ "

";

document.getElementById("favorite-table-id").innerHTML= oldHtml + newHTML;

},errorCB);

},errorCB

);

}

变量courseIdResult是我的查询的ID,我正在使用循环获取数据.但是,每次循环进行时,document.getElementById(“ favorite-table-id”).innerHTML的值始终会被覆盖.请帮我解决这个问题.

谢谢

解决方法:

var q = "";

for (var i = 0; i < courseIdResult.length; i++) {

q += (q == "" ? "" : ", ") + "?";

}

var query = 'SELECT Title,Institution_Id,FullTime,EntryScore,Prerequisites FROM Course WHERE Id IN (' + q + ')';

var db = CreateDB();

var row = '';

db.transaction(populateDB, errorDB, successDB);

function populateDB(tx) {

tx.executeSql(query, courseIdResult, function (tx, results) {

var len = results.rows.length;

var arrSectionTableName = [];

if (len > 0) {

$("#favorite-table-id").empty();

var newHTML = "";

for (var i = 0; i < len; i++) {

newHTML += "

" +row['Title']+"-"+row['Institution_Id'] + "
" + "Years:"+row['FullTime']+ " ATAR:"+row['EntryScore']+ " Prereq:"+row['Prerequisites']+ "

";

}

$('#"favorite-table-id"').val(newHTML);

//Refresh your control,eg if it is a listview

$('#favorite-table-id').listview('refresh');

}

});

}

function errorDB(err) {

alert("Error processing SQL " + err.message);

}

function successDB() {

}

标签：html,javascript,cordova,innerhtml

来源： https://codeday.me/bug/20191013/1910569.html