Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require("express");
- var mysql = require('mysql');
- var connection = mysql.createConnection({
- host : '192.168.1.88',
- user : 'jaakko',
- password : 'test1234',
- database : 'testikanta'
- });
- var app = express();
- connection.connect(function(err){
- if(!err) {
- console.log("Tietokantayhteys muodostettu");
- } else {
- console.log("Virhe tietokantayhteyden muodostamisessa");
- }
- });
- app.get("/",function(req,res){
- connection.query('SELECT * FROM kayttaja',function(err, rows, fields) {
- if (!err) {
- res.send(rows);
- }
- else {
- res.send("virhe " + err + " luettaessa tietokantaa");
- }
- });
- });
- app.listen(3000);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement