Can any one tell me how to send data from Form to MySql database by using Node.Js?
Here in below some pictures showing when I connected and send data into Mongo Database.
But this time I want to send data into MySql database by using Node.js
Here below is app.js code:
var express=require('express');
var bodyParser=require('body-parser');
var connection = require('mysql');
var app=new express();
var port=3000;
app.listen(port,function(err){
if(typeof(err)=="undefined"){
console.log('Your application is running on : '+ port+' port');
}
});
var navMenu=[
{href:'/articles',text:'Articles'},
{href:'/projects',text:'Projects'},
{href:'/books',text:'Books'},
{href:'/Contact',text:'Contact Us'},
{href: '/registration', text:'Registration'},
// {href: '/login',text:'Login'}
];
app.use(express.static('public'));//making public directory as static diectory
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({extended:true}));
app.set('views','./src/views');
app.set('view engine','ejs');
var cookieParser=require('cookie-parser');
var passport=require('passport');
var session=require('express-session');
var articlesRouter=require('./src/routes/articlesRoute')(navMenu);
var projectsRouter=require('./src/routes/projectsRoute')(navMenu);
var booksRouter=require('./src/routes/booksRoute')(navMenu);
var contactRouter=require('./src/routes/contactRoute')(navMenu);
var userRouter = require('./src/routes/registrationRoute')(navMenu);
var loginRouter=require('./src/routes/loginRoute')(navMenu);
var profileRouter = require('./src/routes/profileRoute')(navMenu);
var taskRouter = require('./src/routes/TaskRoute');
app.use('/articles',articlesRouter);
app.use('/projects',projectsRouter);
app.use('/books',booksRouter);
app.use('/contact',contactRouter);
app.use('/registration',userRouter);
app.use('/myprofile',profileRouter);
app.use('/task',taskRouter);
app.use(cookieParser());
app.use(session({
secret: 'c-sharpcorner',
resave: false,
saveUninitialized: true,
cookie: { secure: true }
}))
require('./src/configuration/passport')(app);
//for using passport
app.use('/login',loginRouter);
app.use(session({
secret: 'c-sharpcorner',
resave: false,
saveUninitialized: true,
cookie: { secure: true }
}))
require('./src/configuration/passport')(app);
app.get('/',function(req,res){
res.render('index', {
title:'Node.js By Sourabh Somani',
menu:navMenu
});
});
/*
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '',
database : 'test'
});
connection.connect();
connection.query('SELECT * FROM t_user', function(err, rows, fields)
{
if (err) throw err;
console.log(rows);
});
connection.end();
/*
app.get('/articles', function(req, res) {
res.send('
Welcome to C# Corner Articles.
');});
app.get('/projects',function(req,res){
res.send('
Hello here will be projects');
});
//create router variables
var articlesRouter=express.Router();
var projectsRouter=express.Router();
var booksRouter=express.Router();
var contactRouter=express.Router();
//Now, define routing for each router, like the following
//rendering articles route
/*
articlesRouter.route("/")
.get(function(req,res){
res.render('articles',{
title:'Articles'
});
});
//rendering projects route
projectsRouter.route("/")
.get(function(req,res){
res.render('projects',{
title: 'Projects'
});
});
//rendring books route
booksRouter.route("/")
.get(function(req,res){
res.render('books',{
title: 'Books'
});
});
//rendering contact route
contactRouter.route("/")
.get(function(req,res){
res.render('Contact',{
title:'Contact us',
menu: navMenu
});
});
//Now, we have to tell our application which router will be used for each different routes. To do that, write the code as shown below.
app.use('/articles',articlesRouter);
app.use('/projects',projectsRouter);
app.use('/books',booksRouter);
app.use('/contact',contactRouter);
var articlesRouter=require('./src/routes/articlesRoute');
var projectsRouter=require('./src/routes/projectsRoute');
var booksRouter=require('./src/routes/booksRoute');
var contactRouter=require('./src/routes/contactRoute');
*/
Here below is articlesRoute.js file:
var express=require('express');
var mongodb=require('mongodb').MongoClient;
var articlesRouter=express.Router();
var a_router=function(navMenu){
articlesRouter.route("/")
.get(function(req,res){
var url='http://MY_SERVER_ADDR:3000/data';
mongodb.connect(url,function(err,db){
var collection=db.collection('articles');
collection.find({}).toArray(function(err,results){
res.render('articles', {
title:'Articles',
menu:navMenu,
articles:results
});
});
});
});
return articlesRouter;
}
module.exports=a_router;
Here is article.ejs file for showing data on web-page:
Articles
<%for(var p=0;p
<%=articles[p].Title%>
<%=articles[p].Category%>
<%=articles[p].CreatedDate.toDateString()%>
<%=articles[p].ShortDescription%>
<%}%>
Copyright © Your Website 2014
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.

Vignesh ManiPosted Feb 24, 2017, 5:14 PM