<?php
        //$username='';
        //$password1='';
                             $con=mysqli_connect("192.168.100.75:3307","dac22","welcome","dac22");
                             if(isset($_REQUEST['submit'])){
                         $username=$_REQUEST['username'];
                          $password1=$_REQUEST['password'];
                         $query="select * from user where name='$username' and password='$password1'";
                         $run=mysqli_query($con,$query);


                       //if(mysqli_num_rows($run)>0)
			//{
			while($row=mysqli_fetch_array($run))
                        {
                            $uname=$row["name"];
                            $password=$row["password"];
                            $type=$row["type"];
                            $activated=$row['activated'];
                        }
//                        if($username==$uname && $password1==$password)
//                        {
                            session_start();
                           //header("Login/LoginSession.php");
                           if($activated==1)
                               {
                               $_SESSION['type']=$type;
                               switch ($type)
                        {
                            case 1:
                                header('Location: ../Administrator/home.php');
                                break;

                            case 4:
                                    $_SESSION['name']=$uname;
                                    header('Location: ../Faculty/home.php');
                            break;
                            case 8:
                                $_SESSION['name']=$uname;
                                //echo "locatin: student";
                                header('Location:../Student/home.php');
                                break;
                            case 16:
                                header('Location: ../Sales/home.php');
                            break;
                        }
                           }

                 }
                       //}
                ?>