Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- login = () => {
- fetch('http://[myipaddress]/users', {
- method: 'POST',
- headers: {
- 'Accept': 'application/json',
- 'Content-Type': 'application/json',
- },
- body: JSON.stringify({
- username: this.state.username,
- password: this.state.password,
- insert: false
- })
- })
- .then((response) => response.json())
- .then ((res) => {
- if(res.success === true){
- AsyncStorage.setItem('user', res.user);
- this.props.navigation.navigate('Profile');
- }
- else{
- alert(res.message);
- }
- })
- .done();
- }
- userRegister = () =>{
- fetch('http://[myipaddress]/users', {
- method: 'POST',
- headers: {
- 'Accept': 'application/json',
- 'Content-Type': 'application/json',
- },
- body: JSON.stringify({
- username: this.state.username,
- email: this.state.email,
- password: this.state.password,
- insert: true
- })
- })
- .then((response) => response.json())
- .then((responseJson) => {
- alert(responseJson);
- })
- .catch((error)=>{
- console.error(error);
- });
- }
- var express = require('express');
- var router = express.Router();
- var mysql = require('mysql');
- var connection = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: '',
- database: 'users'
- });
- router.post('/', function(req, res, next) {
- var username = req.body.username;
- var email = req.body.email;
- var password = req.body.password;
- var insert = req.body.insert;
- console.log(username);
- console.log(email);
- console.log(password);
- if (insert === false) {
- connection.query(
- "SELECT * FROM user WHERE username = ? AND password = ?",
- [username, password], function (err, row, field) {
- if (err) {
- console.log(err);
- res.send({ 'success': false, 'message': 'Could not connect' });
- }
- if (row.length > 0) {
- res.send({ 'success': true, 'user': row[0].username });
- } else {
- res.send({ 'success': false, 'message': 'User not found' });
- }
- });
- } else {
- connection.query(
- "INSERT INTO user(username, email, password) VALUES (username,email,password)",
- function (err, result) {
- if (err) {
- res.send({ 'success': false, 'message': 'Could not connect' });
- }
- else{
- res.send({ 'success': true, 'message': 'User created' });
- }
- });
- }
- });
- module.exports = router;
Add Comment
Please, Sign In to add comment