query

<?php

// definisikan koneksi ke database
$server = "localhost";
$username = "root";
$password = "";
$database = "penggajian";

// Koneksi dan memilih database di server
$con=mysqli_connect($server,$username,$password) or die("Koneksi gagal");
mysqli_select_db($con,$database) or die("Database tidak bisa dibuka");
// include "fungsi/koneksi.php";

$username = $_POST['nip'];
$pass     = md5($_POST['password']);

$login=mysqli_query($con,"SELECT * FROM karyawan
        WHERE nip='$username' AND password='$pass' ")or die(mysqli_error());
$ketemu=mysqli_num_rows($login);
$r=mysqli_fetch_array($login);
echo $ketemu;