Breaking News: Grepper is joining You.com. Read the official announcement!

insert form data into sql node js

Hammad Somro answered on October 27, 2022 Popularity 5/10 Helpfulness 3/10

answer insert form data into sql node js

related insert form data into sql node js

insert form data into sql node js

Comment

<html>
<head>
<title> test </title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
</head>
<body>
<form action="/submitform/" method="POST">
<fieldset>
<label for="name">Name: </label>
<input type="text" id="name" name="name" autofocus />
<br/>
<label for="email">Email: </label>
<input type="email" id="email" name="email"  />
<br/>
<label for="description">Description: </label>
<textarea id="description" name="description"></textarea>
<br/>
<input type="submit" value="create profile" />
</fieldset>

</form>
</body>
</html>

Popularity 5/10 Helpfulness 3/10 Language javascript

Source: stackoverflow.com

Tags: form-data insert javascript sql

Link to this answer
Share Copy Link

Contributed on Oct 27 2022

Hammad Somro

0 Answers Avg Quality 2/10

Closely Related Answers

insert form data into sql node js

Comment

var express = require('express');
var router = express.Router();
var mysql = require('mysql');
var con = mysql.createConnection({
     host: "localhost",
     user: "root",
     password: "",
     database: "testn"
});

router.post('/submitform', function(req, res, next) {
    console.log(req.body.name);
    console.log(req.body.email);
    console.log(req.body.description);
    con.connect(function(err) {
  if (err) throw  err;
  console.log("connected");
  var sql = "INSERT INTO `form`(`name`,`email`, `description`) VALUES ('"+req.body.name+"','"+req.body.email+"','"+req.body.description+"')";
  con.query(sql, function(err, result)  {
   if(err) throw err;
   console.log("table created");
  });
});

  res.render('index', { title: 'Express' });
});


module.exports = router;

Popularity 5/10 Helpfulness 3/10 Language javascript

Source: stackoverflow.com

Tags: sql form-data insert javascript

Link to this answer
Share Copy Link

Contributed on Oct 27 2022

Hammad Somro

0 Answers Avg Quality 2/10

insert form data into sql node js

Contents

More Related Answers

insert form data into sql node js

Closely Related Answers

insert form data into sql node js

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.