Advertisement
Guest User

Untitled

a guest
Oct 6th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.14 KB | None | 0 0
  1. <form name="login" ng-submit="login()">
  2. <div class="login" ng-app="loginPage" ng-controller="loginController">
  3. <input type="text" placeholder="username" ng-model="uname" name="userid"><br>
  4. <input type="password" placeholder="password" ng-model="pword" name="pswrd"><br>
  5. <!--<input type="button" ng-click="login();" onclick="check(this.form)" value="Login"/>-->
  6. <button ng-click="login();">Login</button>
  7. </div>
  8. </form>
  9.  
  10. <script language="javascript">
  11. var app = angular.module('loginPage', []);
  12. app.controller('loginController', function($scope, $http, $window) {
  13. console.log("inside controller");
  14. $scope.login = function() {
  15. console.log("inside the login function");
  16. console.log($scope.uname);
  17.  
  18. var login_http = $http({
  19. method: 'POST',
  20. url: '/login',
  21. params: { username: $scope.uname, password: $scope.pword }
  22. }).then(
  23. function (response) {
  24. $window.alert('successfull!!');
  25. //alert('successfull ...');
  26. }, function (response) {
  27. $window.alert('wrong username/password');
  28. //alert('wrong username/password ... ');
  29. }
  30. )
  31. }
  32.  
  33. connection.connect();
  34.  
  35. /* GET home page. */
  36. router.get('/', function(req, res, next) {
  37. res.sendFile(path.join(__dirname, '../', 'views', 'login.html'));
  38. });
  39. router.post('/login', function(req,res)
  40. {
  41.  
  42. console.log("Username:"+req.query.username);
  43. console.log("Password:"+req.query.password);
  44.  
  45. var user = req.query.username;
  46. var pass = req.query.password
  47.  
  48. connection.query("select * from user where login_name = ?", user, function(err, rows, fields) {
  49. if (!err){
  50. if(user==rows[0].login_name && pass==rows[0].pass){
  51. console.log("success");
  52. res.sendStatus(200);
  53. //res.sendFile(path.join(__dirname, '../', 'views', 'team_list.html'));
  54. }
  55. }
  56. else{
  57. console.log('Error while performing Query.', err);
  58. res.sendStatus(401);
  59. }
  60.  
  61. Server listening on port 8000
  62. GET / 200 10.853 ms - 5260
  63. Username:test
  64. Password:test
  65. success
  66. POST /login?password=test&username=test 200 12.559 ms - 2
  67. GET /?userid=test&pswrd=test 200 10.027 ms - 5260
  68.  
  69. Server listening on port 8000
  70. GET / 304 16.586 ms - -
  71. Username:test
  72. Password:test
  73. success
  74. POST /login?password=test&username=test 200 12.778 ms - 2
  75. GET /?userid=test&pswrd=test 304 9.742 ms - -
  76.  
  77. <div class="login" ng-app="loginPage" ng-controller="loginController">
  78. <!--name="login" ng-submit="login()"-->
  79.  
  80. <input type="text" placeholder="username" ng-model="uname" name="userid"><br>
  81. <input type="password" placeholder="password" ng-model="pword" name="pswrd"><br>
  82. <input type="submit" ng-click="login()" value="login"/>
  83. <!--button ng-click="login();">Login</button-->
  84. </div>
  85.  
  86. Server listening on port 8000
  87. GET / 304 9.312 ms - -
  88. Username:test
  89. Password:test
  90. C:UsersdagarwWebstormProjectsGP-01_DEVnode_modulesmysqllibprotocolParser.js:
  91. 78
  92. throw err; // Rethrow non-MySQL errors
  93. ^
  94.  
  95. TypeError: Cannot read property 'login_name' of undefined
  96. at Query._callback (C:UsersdagarwWebstormProjectsGP-01_DEVroutesindex.js:30
  97. :25)
  98. at Query.Sequence.end (C:UsersdagarwWebstormProjectsGP-01_DEVnode_modulesmy
  99. sqllibprotocolsequencesSequence.js:85:24)
  100. at Query._handleFinalResultPacket (C:UsersdagarwWebstormProjectsGP-01_DEVnod
  101. e_modulesmysqllibprotocolsequencesQuery.js:144:8)
  102. at Query.EofPacket (C:UsersdagarwWebstormProjectsGP-01_DEVnode_modulesmysql
  103. libprotocolsequencesQuery.js:128:8)
  104. at Protocol._parsePacket (C:UsersdagarwWebstormProjectsGP-01_DEVnode_modules
  105. mysqllibprotocolProtocol.js:280:23)
  106. at Parser.write (C:UsersdagarwWebstormProjectsGP-01_DEVnode_modulesmysqlli
  107. bprotocolParser.js:74:12)
  108. at Protocol.write (C:UsersdagarwWebstormProjectsGP-01_DEVnode_modulesmysql
  109. libprotocolProtocol.js:39:16)
  110. at Socket.<anonymous> (C:UsersdagarwWebstormProjectsGP-01_DEVnode_modulesmy
  111. sqllibConnection.js:109:28)
  112. at emitOne (events.js:77:13)
  113. at Socket.emit (events.js:169:7)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement