session_start();


$servername = "";
$username = "";
$password = "";
$dbname = "";



$conn = new mysqli($servername, $username, $password, $dbname);
$new = mysqli_set_charset($conn, "uft8");
if ($conn->connect_error) {
        die("connection failed" . $conn->connect_error);
}


if ($_POST) {
  $username = mysqli_real_escape_string($conn, $_POST['username']);
  $password = mysqli_real_escape_string($conn, $_POST['password']);


$password = md5($password);
$giris = "SELECT * FROM kullanicilar WHERE username = '$username' AND sifre = '$password'";
    $getir = $conn->query($giris);
      if ($getir->num_rows>0) {
       while ($row = $getir->fetch_assoc()) {
        $_SESSION['email'] = $row['email'];
        $_SESSION['telefon'] = $row['telefon'];
        $_SESSION['kayittarih'] = $row['kayittarih'];
        $_SESSION['ip'] = $row['ip'];
        $_SESSION['songiris'] = $row['lastlogin'];
        $_SESSION['passwords'] = $row['sifre'];
        $_SESSION['online'] = $row['online'];
        $_SESSION['para'] = $row['balance'];
        $_SESSION['ip'] = $row['ip'];
        $_SESSION['isim'] = $row['isim'];
        header('location: index.php');
       } 
      }


}
//if ($_POST) {
//  $username = $_POST['username'];


//$giris = "SELECT * FROM kullanicilarinparasi WHERE username = '$username' AND sifre = '$password'";
//    $getir = $conn->query($giris);
//      if ($getir->num_rows>0) {
//       while ($row = $getir->fetch_assoc()) {
//        $_SESSION['para'] = $row['balance'];
//        header('location: index1234.php');
//       } 
//      }


//}
//?>