Insert data using node js mysql

var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "", database: "nodejs" }); con.connect(function(err) { if (err) throw err; console.log("Connected!"); var sql = "INSERT INTO customers…

0 Comments

Create table using nodejs

var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "", database: "nodejs" }); con.connect(function(err) { if (err) throw err; console.log("Connected!"); var sql = "CREATE TABLE members…

0 Comments

Create database using nodejs

var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "" }); con.connect(function(err) { if (err) throw err; console.log("Connected!"); con.query("CREATE DATABASE nodedb", function (err, result) { if…

0 Comments

Node js mysql

npm install mysql var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "" }); con.connect(function(err) { if (err) throw err; console.log("Connected!"); });  

0 Comments

Nodemailler module in node js

npm install nodemailer var nodemailer = require('nodemailer'); var transporter = nodemailer.createTransport({ service: 'gmail', auth: { user: 'wordpress12389@gmail.com', pass: 'Lucky786@' } }); var mailOptions = { from: 'wordpress12389@gmail.com', to: 'upwork12389@gmail.com', subject:…

0 Comments

upload files (form) in node js

npm install formidable var http = require('http'); var formidable = require('formidable'); http.createServer(function (req, res) { if (req.url == '/fileupload') { var form = new formidable.IncomingForm(); form.parse(req, function (err, fields, files)…

0 Comments

Event module in node js

var events = require('events'); var eventEmitter = new events.EventEmitter(); //Create an event handler: var myEventHandler = function () { console.log('I hear a scream!'); } //Assign the event handler to an event: eventEmitter.on('scream', myEventHandler); //Fire the 'scream' event:…

0 Comments