我如何使用HTML和Nodejs创建mysql表
我想使用mysql数据在nodejs服务器上表示一个表。
我希望我的nodejs将像下面的html源代码一样使用。
<tr>
<th>Name</th>
<th>Profile</th>
<th>Update</th>
<th>Delete</th>
</tr>
<tr>
<td>egoing</td>
<td>developer</td>
<td>Update</td>
<td>Delete</td>
</tr>
<tr>
<td>duru</td>
<td>database admnistrato</td>
<td>Update</td>
<td>Delete</td>
</tr>
<tr>
<td>taeho</td>
<td>developer</td>
<td>Update</td>
<td>Delete</td>
</tr>
但是，我的源代码按水平顺序插入mysql数据。
这是我的源代码。（author_information是对象）
author_List:function(author_information) {
var line = `
<body>
<table>
<tr>
<th>Name</th>
<th>Profile</th>
<th>Update</th>
<th>Delete</th>
</tr>
`
var a_Name = `<tr>`;
var a_Profile = `<tr>`;
var a_Update = `<tr>`;
var a_Delete = `<tr>`;
for (var i = 0 ; i < author_information.length ; i++) {
a_Name = a_Name + `<td>${author_information[i].name}</td>`;
a_Profile = a_Profile + `<td>${author_information[i].profile}</td>`
a_Update = a_Update + `<td><a href="/">Update</a></td>`;
a_Delete = a_Delete + `<td><a href="/">Delete</a></td>`;
}
a_Name = a_Name + `</tr>`;
a_Profile = a_Profile + `</tr>`;
a_Update = a_Update + `</tr>`;
a_Delete = a_Delete + `</tr>`;
line = line + a_Name + a_Profile + a_Update + a_Delete + `</table></body>`
return line;
}
如何将数据垂直放置在列中？
回答如下：[扩展我的评论，这是您应该如何创建html以实现与您给出的示例相同的结构（我也删除了a_...变量，您实际上并不需要它们，而是使用了line += X line = line + X之）：
author_List:function(author_information) {
var line = `
<body>
<table>
<tr>
<th>Name</th>
<th>Profile</th>
<th>Update</th>
<th>Delete</th>
</tr>`;
for (var i = 0 ; i < author_information.length ; i++) {
line+= `<tr>`;
line += `<td>${author_information[i].name}</td>`;
line += `<td>${author_information[i].profile}</td>`
line += `<td><a href="/">Update</a></td>`;
line += `<td><a href="/">Delete</a></td>`;
line+= `</tr>`;
}
line += `</table></body>`
return line;
}
我如何使用HTML和Nodejs创建mysql表
我想使用mysql数据在nodejs服务器上表示一个表。
我希望我的nodejs将像下面的html源代码一样使用。
<tr>
<th>Name</th>
<th>Profile</th>
<th>Update</th>
<th>Delete</th>
</tr>
<tr>
<td>egoing</td>
<td>developer</td>
<td>Update</td>
<td>Delete</td>
</tr>
<tr>
<td>duru</td>
<td>database admnistrato</td>
<td>Update</td>
<td>Delete</td>
</tr>
<tr>
<td>taeho</td>
<td>developer</td>
<td>Update</td>
<td>Delete</td>
</tr>
但是，我的源代码按水平顺序插入mysql数据。
这是我的源代码。（author_information是对象）
author_List:function(author_information) {
var line = `
<body>
<table>
<tr>
<th>Name</th>
<th>Profile</th>
<th>Update</th>
<th>Delete</th>
</tr>
`
var a_Name = `<tr>`;
var a_Profile = `<tr>`;
var a_Update = `<tr>`;
var a_Delete = `<tr>`;
for (var i = 0 ; i < author_information.length ; i++) {
a_Name = a_Name + `<td>${author_information[i].name}</td>`;
a_Profile = a_Profile + `<td>${author_information[i].profile}</td>`
a_Update = a_Update + `<td><a href="/">Update</a></td>`;
a_Delete = a_Delete + `<td><a href="/">Delete</a></td>`;
}
a_Name = a_Name + `</tr>`;
a_Profile = a_Profile + `</tr>`;
a_Update = a_Update + `</tr>`;
a_Delete = a_Delete + `</tr>`;
line = line + a_Name + a_Profile + a_Update + a_Delete + `</table></body>`
return line;
}
如何将数据垂直放置在列中？
回答如下：[扩展我的评论，这是您应该如何创建html以实现与您给出的示例相同的结构（我也删除了a_...变量，您实际上并不需要它们，而是使用了line += X line = line + X之）：
author_List:function(author_information) {
var line = `
<body>
<table>
<tr>
<th>Name</th>
<th>Profile</th>
<th>Update</th>
<th>Delete</th>
</tr>`;
for (var i = 0 ; i < author_information.length ; i++) {
line+= `<tr>`;
line += `<td>${author_information[i].name}</td>`;
line += `<td>${author_information[i].profile}</td>`
line += `<td><a href="/">Update</a></td>`;
line += `<td><a href="/">Delete</a></td>`;
line+= `</tr>`;
}
line += `</table></body>`
return line;
}