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']);
	$password = $conn->real_escape_string($_GET['password']);
	
	if ($username == '' || $password == '') {
		echo "Supply values for all required fields";
		return;
	}
	
	$sql = "SELECT id FROM users WHERE username = '$username' AND password = '$password'";
	$result = $conn->query($sql);
	if ($result->num_rows == 1) {
		$data = $result->fetch_assoc();
		echo $data['id'];
	} else {
		echo "Error while logging in user " . $conn->error;
	}
	$conn->close();
	
?>