01_connection.js

/**
	{
		"date_of_creation": "17 September 2017",
		"aim_of_source": 'Testing database(mysql) connection in node.js',
		"coded_by": 'Rishikesh Agrawani',
		"output_img_links": "[
							'0002mysql01connection2017-09-17at4.06.03PM.png',
							'0003mysql01connection2017-09-17at4.07.51PM.png'
						]"
	}
*/

//Including http module
var http = require("http")
//Including mysql module(mysql node.js driver)
var mysql = require("mysql")

//Setting port
var port = 8080

//HTML text to display on the browser
var htmlText = "<center>"+
				"<h1 style='color:green'> Connection established </h1>"+
				"<a href='https://nodejs.org/en/'>Click here</a> to download"+
				"</center>"

//HTML erro text to display on the browser
var htmlErrorText = "<center>"+
				"<h1 style='color:red'> Error while creating db connection</h1>"+
				"<a href='https://nodejs.org/en/'>Click here</a> to download"+
				"</center>"

//Printing simple log message
console.log("Starting Node server")

//Creating server
server = http.createServer(
			function(request, response){
				//Creating connection object
				var connection = mysql.createConnection({
					host: "localhost",	
					"user": "rishikesh",	//db username
					"password": "rishikesh@321"	//db password
				})

				//Creating and testing database connection
				connection.connect(function(err){
					if(err){
						//Error
						response.writeHead(500, {"Content-Type":"text/html"})
						console.log("Error while creating connection")
						response.end(htmlErrorText)
					} else {
						//Successful
						response.writeHead(200, {"Content-Type":"text/html"})
						console.log("Connection successful")
						response.end(htmlText)
					}
				})
			}
		)

//Our http server should listen on port 8080
server.listen(port)

//Printing log messages
console.log("Server started which is listening on port 8080")
console.log("Visit at http://127.0.0.1:"+port)