JavaScript HTML 表格解析
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15957955/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
JavaScript HTML table parsing
提问by Aleksandr Sinkevi?
HTML
HTML
<table id="table">
<tr>
<td>1999.09-2007.06</td>
<td> Secondary School </td>
</tr>
<tr>
<td>2007.09-2011.06</td>
<td> College </td>
</tr>
<tr>
<td>2011.09-2015.06</td>
<td> University</td>
</tr>
</table>
<form autocomplete="on">
<p/>
<label>Year</label>
<input type="text" id="year" name="year" autofocus/>
<p/>
<label>Month</label>
<input type="text" name="month" id="month" />
<p/>
</form>
<input type="button" onClick="method()" />
JavaScript
JavaScript
function method(){
var year = document.getElementById("year").value;
var month = document.getElementById("month").value;
var data = new Date(year,month-1,1);
var dataTable = document.getElementById("table");
var cells = dataTable.querySelectorAll("td");
var cells2 = dataTable.querySelectorAll("td+td");
for (var i = 0; i < cells.length; i++){
var mikro = cells[i].firstChild.data.split("-");
var place = cells2[i].firstChild.data;
var firstData = mikro[0].split(".");
var secondData = mikro[1].split(".");
var data1 = new Date(firstData[0],firstData[1]-1,1);
var data2 = new Date(secondData[0],secondData[1]-1,1);
if(data1<=data && data2>=data){
alert(place);
}
}
}
Here i have 2 columns in the table, i want to create script which will help me to find information from it: I have <input type="text" id="year" name="year" autofocus/>and <input type="text" name="month" id="month" />where i can enter year & month.After entering year&month i have to get information from the 2nd column according to the dates on the 1st column for example: " Input year: 2002, Input month:05 - result must be 'Secondary School'" because it between 1999.09-2007.06 . I can't see what is wrong with my script, it always give me false information.
在这里，我在表中有 2 列，我想创建脚本来帮助我从中查找信息：我有<input type="text" id="year" name="year" autofocus/>以及<input type="text" name="month" id="month" />在哪里可以输入年和月。输入年和月后，我必须根据第一列上的日期例如：“输入年份：2002，输入月份：05 - 结果必须是'中学'”，因为它在 1999.09-2007.06 之间。我看不出我的脚本有什么问题，它总是给我错误的信息。
回答by Paul Grime
Try this (jsfiddle), increment the cell index by 2 each time, and use the simpler tdselector:
试试这个（jsfiddle），每次将单元格索引增加 2，并使用更简单的td选择器：
function method () {
var year = document.getElementById("year").value;
var month = document.getElementById("month").value;
var data = new Date(year, month - 1, 1);
var dataTable = document.getElementById("table");
var cells = dataTable.querySelectorAll("td");
for (var i = 0; i < cells.length; i+=2) {
var mikro = cells[i].firstChild.data.split("-");
var place = cells[i+1].firstChild.data;
console.log(mikro, place);
var yearMonth1 = mikro[0].split(".");
var yearMonth2 = mikro[1].split(".");
var data1 = new Date(yearMonth1[0], yearMonth1[1] - 1, 1);
var data2 = new Date(yearMonth2[0], yearMonth2[1] - 1, 1);
if (data1 <= data && data2 >= data) {
alert(place);
}
}
}
