<?php
$servername = "localhost:8889";
$username = "root";
$password = "root";
$dbname = "users";

 // Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
}



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


  $sql = "SELECT count(*) as count FROM users where username = '.$username.' and password = '.$password.'";



  if ($result = $conn->query,($sql))  {

       var_dump($result);

     string mysql_result ( resource $result , int $row [, mixed $field = 0 ] )





//look after a result if it find reuslt go to admin

header('Location: adminpanel.html');

    } else {
      echo "Error: " . $sql . "<br>" . $conn->error;
        }

$conn->close();
 ?>