Guest User

Untitled

a guest
May 20th, 2018
173
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.67 KB | None | 0 0
  1. login = () => {
  2.  
  3. fetch('http://[myipaddress]/users', {
  4. method: 'POST',
  5. headers: {
  6. 'Accept': 'application/json',
  7. 'Content-Type': 'application/json',
  8. },
  9. body: JSON.stringify({
  10. username: this.state.username,
  11. password: this.state.password,
  12. insert: false
  13. })
  14. })
  15.  
  16. .then((response) => response.json())
  17. .then ((res) => {
  18.  
  19. if(res.success === true){
  20. AsyncStorage.setItem('user', res.user);
  21. this.props.navigation.navigate('Profile');
  22. }
  23. else{
  24. alert(res.message);
  25. }
  26.  
  27. })
  28. .done();
  29. }
  30.  
  31. userRegister = () =>{
  32.  
  33. fetch('http://[myipaddress]/users', {
  34. method: 'POST',
  35. headers: {
  36. 'Accept': 'application/json',
  37. 'Content-Type': 'application/json',
  38. },
  39. body: JSON.stringify({
  40. username: this.state.username,
  41. email: this.state.email,
  42. password: this.state.password,
  43. insert: true
  44. })
  45. })
  46.  
  47. .then((response) => response.json())
  48. .then((responseJson) => {
  49. alert(responseJson);
  50. })
  51. .catch((error)=>{
  52. console.error(error);
  53. });
  54. }
  55.  
  56. var express = require('express');
  57. var router = express.Router();
  58. var mysql = require('mysql');
  59.  
  60. var connection = mysql.createConnection({
  61. host: 'localhost',
  62. user: 'root',
  63. password: '',
  64. database: 'users'
  65. });
  66.  
  67. router.post('/', function(req, res, next) {
  68.  
  69. var username = req.body.username;
  70. var email = req.body.email;
  71. var password = req.body.password;
  72. var insert = req.body.insert;
  73.  
  74. console.log(username);
  75. console.log(email);
  76. console.log(password);
  77.  
  78. if (insert === false) {
  79. connection.query(
  80. "SELECT * FROM user WHERE username = ? AND password = ?",
  81. [username, password], function (err, row, field) {
  82.  
  83. if (err) {
  84. console.log(err);
  85. res.send({ 'success': false, 'message': 'Could not connect' });
  86. }
  87.  
  88. if (row.length > 0) {
  89. res.send({ 'success': true, 'user': row[0].username });
  90. } else {
  91. res.send({ 'success': false, 'message': 'User not found' });
  92. }
  93.  
  94. });
  95. } else {
  96. connection.query(
  97. "INSERT INTO user(username, email, password) VALUES (username,email,password)",
  98. function (err, result) {
  99.  
  100. if (err) {
  101. res.send({ 'success': false, 'message': 'Could not connect' });
  102. }
  103. else{
  104. res.send({ 'success': true, 'message': 'User created' });
  105. }
  106. });
  107. }
  108. });
  109.  
  110. module.exports = router;
Add Comment
Please, Sign In to add comment