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


    $username = iconv('utf-8', 'cp1251', $_POST['username']);
    $password = $_POST['password'];

    $stmt = " SELECT id, password, fname, lname, sname, phone  FROM portal_users WHERE email='$username' AND password = '$password' AND Status =1;";
    $result = $db->prepare ( $stmt );
    $result->execute ();

    if($result->rowCount() > 0){

    $tdata = $result->fetchAll ();
    foreach ($tdata as $row){

        $userid = $row['id'];
        $userpass = $row['password'];
        $fname = $row['fname'];
        $sname =$row['sname'];
        $phone = $row['phone'];

       session_start();
       $_SESSION['id'] = $userid;
       $_SESSION['fname'] = $fname;
       $_SESSION['sname'] = $sname;
       //print_r ($_SESSION);


       
    }


}
}