tegarkurniawan

node

Nov 8th, 2015
256
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.50 KB | None | 0 0
  1. var app = require('express')();
  2. var http = require('http').Server(app);
  3. var mysql = require('mysql');
  4. var bodyParser = require("body-parser");
  5. var connection = mysql.createConnection({
  6. host : 'localhost',
  7. user : 'root',
  8. password : '',
  9. database : 'larachat',
  10. });
  11. app.use(bodyParser.urlencoded({ extended: false }));
  12. app.use(bodyParser.json());
  13.  
  14.  
  15.  
  16. app.get('/',function(req,res){
  17. var data = {
  18. "Data":""
  19. };
  20. data["Data"] = "Welcome to type Store DEMO...";
  21. res.json(data);
  22. });
  23.  
  24. app.get('/chat',function(req,res){
  25. var data = {
  26. "error":1,
  27. "Type":""
  28. };
  29.  
  30. connection.query("SELECT * from chat",function(err, rows, fields){
  31. if(rows.length != 0){
  32. data["error"] = 0;
  33. data["Types"] = rows;
  34. res.json(data);
  35. }else{
  36. data["Types"] = 'No types Found..';
  37. res.json(data);
  38. }
  39. });
  40. });
  41.  
  42.  
  43.  
  44. app.post('/chat/create',function (req, res) {
  45.  
  46. var Chat = req.body.chat;
  47. var User_id = req.body.user_id;
  48.  
  49. var data = {
  50. "error":1,
  51. "types":"",
  52.  
  53.  
  54. };
  55.  
  56. if(!!Chat && !!User_id){
  57. connection.query("INSERT INTO chat VALUES('',?,?,)",[Chat,User_id],function(err, rows, fields){
  58. if(!!err){
  59. data["types"] = "Error Adding data";
  60. }else{
  61. data["error"] = 0;
  62. data["types"] = "type Added Successfully";
  63. }
  64. res.json(data);
  65. });
  66. }else{
  67. data["types"] = "Please provide all required data (i.e : chat, user_id)";
  68. res.json(data);
  69. }
  70. });
  71.  
  72.  
  73.  
  74. http.listen(8080,function(){
  75. console.log("Connected & Listen to port 8080");
  76. });
Advertisement
Add Comment
Please, Sign In to add comment