home_klient.php

<?php
if(!isset($_SESSION))
{
session_start();
}
include "login_klient/config.php";

if(isset($_POST['but_submit'])){

    $uname = mysqli_real_escape_string($con,$_POST['txt_uname']);
    $password = mysqli_real_escape_string($con,$_POST['txt_pwd']);

    if ($uname != "" && $password != ""){

        $sql_query = "select count(*) as cntUser from tbl_login_klient where login_name='".$uname."' and password='".$password."'";
        $result = mysqli_query($con,$sql_query);
        $row = mysqli_fetch_array($result);

        $sql_query1 = "select me_id  from tbl_login_klient where login_name='".$uname."' and password='".$password."'";
        $result1 = mysqli_query($con,$sql_query1);
        $row1 = mysqli_fetch_array($result1);
        $_SESSION['me_id']=$row1['me_id'];

        $count = $row['cntUser'];

        if($count > 0){
            $_SESSION['uname'] = $uname;
            header('Location: geolokacja.php');
        }else{
            echo "Invalid username and password";
        }

    }

}
?>