login

<?php
$username = $_GET["username"];
$password = $_GET["password"];

$host="127.0.0.1:8080"; // Host name
//$port=8080;
$user="root"; // Mysql username
$pass=""; // Mysql password
$db_name="userdata"; // Database name
$tbl_name="users"; // Table name

// Check connection
// $mysqli = new mysqli("$host", "$user", "$pass", "$db_name", $port);
$mysqli = mysqli_connect("$host", "$user", "$pass", "$db_name");

if ($mysqli->ping())
{
    echo "Ping!";
}
else
{
    echo "No ping...";
    exit();
}

if (mysqli_connect_errno())
{
    echo "Connection failed: " . mysqli_connect_error();
    exit();
}

// Perform query
$sql="SELECT * FROM $tbl_name WHERE username='$username'";
$result=$mysqli->query($sql);
if ($result != NULL)
{
    $count = $result->num_rows;

    // If result matched $username and $password, table row must be 1 row
    if($count==1)
    {
        $row = mysqli_fetch_assoc($result);
        if ($row['username'] === $username && $row['password'] === $password)
        {
            echo "Login Successful";
            return true;
        }
        else
        {
            echo "Wrong Username or Password";
            return false;
        }
    }
    else
    {
        echo "Wrong Username or Password";
        return false;
    }

    $result->close();
}

$mysqli->close();
?>