PHP 通过动态传递值来发布请求

Question

我试图将两个值 name 和 company 传递给服务器，但它总是将它们作为字符串传递。

app.post('/visitors/store', (req, res) => {

const name = req.body.name; (User1)

const company = req.body.company; (Google)

con.query("INSERT INTO visitors(name, company) VALUES(`name`,`company`)", (results) => {

            res.json(results);

        });

  })

name问题出在“VALUES( , company)”行的这一部分

数据库 atm 中的结果： name = name , company = company

我需要的结果是：name = User1，company = Google

谢谢你的帮助

Answer 1

根据您的环境，您还应该转义查询值。如果您使用 mysql，您应该可以使用以下内容：app.post('/visitors/store', (req, res) => {const name = req.body.name;const company = req.body.company;con.query("INSERT INTO visitors(name, company) VALUES(?,?)", [name, company], (results) => {    res.json(results);});或不转义：app.post('/visitors/store', (req, res) => {const name = req.body.name;const company = req.body.company;con.query(`INSERT INTO visitors(name, company) VALUES(${name}, ${company})`, (results) => {    res.json(results);});

Answer 2

只需停止查询字符串并在其中包含实际变量：app.post('/visitors/store', (req, res) => {    const name = req.body.name;    const company = req.body.company;    con.query("INSERT INTO visitors(name, company) VALUES('" + name + "','" + company + "')", (results) => {        res.json(results);    });});