NarKampen/dbFiles/Login.php

<?php
	$hostname = 'localhost';
	$username = 'narKampen';
	$pass = 'narKampenPassword';
	$database = 'narKampen';
	
	$conn = new mysqli($hostname, $username, $pass, $database);
	if (!$conn) {
		die("Connection Failed. ". mysqli_connect_error());
	}
	mysqli_set_charset($conn,'utf8');
	
	$username = $conn->real_escape_string($_GET['name']);
	
	if ($username == '') {
		echo "Supply values for all required fields";
		return;
	}
	
	$sql = "SELECT id, salt, password FROM users WHERE username = '$username'";
	$result = $conn->query($sql);
	if ($result->num_rows == 1) {
		$data = $result->fetch_assoc();
		$updateLastLoginSql = "UPDATE users SET last_login = " . NOW() . " WHERE id = " . $data['id'];
		$conn->query($updateLastLoginSql);
		echo json_encode($data);
	} else {
		echo "Error while logging in user " . $conn->error;
	}
	$conn->close();
	
?>