Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // import modules
- var express = require('express');
- var mysql = require('mysql');
- var app = express();
- // implement connectionPool
- var connection = mysql.createPool({
- // properties ...
- connectionLimit: 90, // only 90 queries at a time
- host:'localhost',
- user:'root',
- password:'KTMEi',
- database:'mantis_live_dev'
- });
- app.get('/', function(req, res){
- // about mysql
- // connection.query("SELECT * FROM mantis_live_dev WHERE", function(error, rows, fields));
- connection.getConnection(function(error, tempCont){
- if(!!error){
- tempCont.release();
- console.log('Error');
- } else {
- console.log('Successfully connected.');
- var query1 = "SELECT * FROM mysampletable WHERE id>10";
- tempCont.query(query1, function(error, rows, fields){
- tempCont.release();
- // callback
- if(!!error){
- console.log('Error in the query');
- } else {
- console.log('Success!\n');
- console.log(rows);
- // res.send('Hello, ' + rows[0].Name);
- res.json(rows);
- // parse with your rows/ fields
- }
- });
- }
- })
- });
- app.listen(1337);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement