使用ejs将mysql查询结果显示为html

ocebsuys  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(404)

我正在构建一个应用程序(使用ejs view engine和node.js),它与我在本地构建的mysql数据库进行交互。我可以以json字符串的形式成功地接收查询结果,但是我无法将信息发送到视图(以html的形式显示),因为我得到了一个错误:unsafefoods没有定义。
我的'app.js'文件声明:

var unsafefoods = require('./routes/unsafefoods');
app.use('/unsafefoods', unsafefoods);

我的路线“unsafefoods.js”声明:

var express = require('express');
var router = express.Router();

/* GET all safe foods */
router.get('/', function (req, res, next) {
	connection.query('SELECT * from appycavy.foods WHERE safe = 0', function (error, rows, fields) {
		if (error) {
			res.send(JSON.stringify({
				"status": 500,
				"error": error,
				"response": null
			}));
			//If there is error, we send the error in the error section with 500 status
		} else {
			res.render(unsafefoods, {
				title: 'Unsafe foods list',
				data: rows
			})
		}
	});
});

module.exports = router;

我的观点“unsafefoods.ejs”宣称:

<!DOCTYPE html>
<html lang="en">

<head>
  <% include ./partials/head %>
</head>

<body class="container">
  <header>
    <% include ./partials/header %>
  </header>
  <main>
    <div class="jumbotron">
      <h2>Safe foods</h2>
      <p>The following is a list of all
        <b>unsafe</b> foods
      </p>
      <!-- table to display unsafe foods -->
      <table width='80%' border=0>

        <tr style='text-align:left; background-color:#CCC'>
            <th>ID</th>
            <th>Name</th>
            <th>Safe</th>
            <th>Type</th>
            <th>Favourite</th>
            <th>Water</th>
            <th>Energy</th>
            <th>Vitamin C</th>
            <th>Sugar</th>
            <th>Lipid fat</th>
            <th>Calcium</th>
            <th>Phosphorus</th>
            <th>CaP ratio</th>
        </tr>

        <!--
            Using FOREACH LOOP for the users array

            myArray.forEach(function(el, index) {
                // el - current element, i - index
            });
        -->
        <% if (data) { %>
        <% data.forEach(function(unsafefoods){ %>
            <tr>
                <td><%= unsafefoods.id %></td>
                <td><%= unsafefoods.name %></td>
                <td><%= unsafefoods.safe %></td>
                <td><%= unsafefoods.type %></td>
                <td><%= unsafefoods.favourite %></td>
                <td><%= unsafefoods.water %></td>
                <td><%= unsafefoods.energy %></td>
                <td><%= unsafefoods.vitaminC %></td>
                <td><%= unsafefoods.sugars %></td>
                <td><%= unsafefoods.lipidFat %></td>
                <td><%= unsafefoods.calcium %></td>
                <td><%= unsafefoods.phosphorus %></td>
                <td><%= unsafefoods.capRatio %></td>
                <td>
                    <div style="float:left">
                        <a href='/unsafefoods/edit/<%= unsafefoods.id %>'>Edit</a> &nbsp;                            
                        <form method="post" action="/unsafefoods/delete/<%= unsafefoods.id %>" style="float:right">
                            <input type="submit" name="delete" value='Delete' onClick="return confirm('Are you sure you want to delete?')" />
                            <input type="hidden" name="_method" value="DELETE" />
                        </form>
                    </div>
                </td>
            </tr>
        <% }) %>
        <% } %>

    </table>
    </div>
  </main>
  <footer>
    <% include ./partials/footer %>
  </footer>
</body>

</html>

任何指点都将不胜感激,
谢谢,

mrphzbgm

mrphzbgm1#

unsafefoods 变量在您的中未定义 unsafefoods.js 文件。
你的代码应该是

res.render('unsafefoods', {
  title: 'Unsafe foods list',
  data: rows
})

你失踪了 '' 周围 unsafefoods .

相关问题