<?php

  $connect= new mysqli('localhost', 'root','' ,'prueba2');

  if($connect->connect_error){
    die('connection failed');
  }else {
    echo 'connection worked';
  }

  $username= $_POST['username'];
  $password= $_POST['password'];

  $sql="SELECT name FROM users WHERE username='$username' AND
  password='$password'";

  $result= $connect->query($sql);

  if($result-> num_rows> 0){
    while($row=$result->fetch_assoc()){
      echo "<br>Admin name is: " . $row["name"];
    }
  } else {
    echo "<br>Username and password dont match";
  }

?>