Coding

<!DOCTYPE html>

<head>

<meta charset=utf-8" />

<title>ຂໍ້ມູນການເຂົ້າລະບົບ</title>

<style>

body{

margin-top:0px;

padding:0px;

background-color:#009;}

#opt{

width: 18%;

height:35px;

border-radius:5px;

border-color:#F00;

margin-left:4%;

font-family:"Phetsarath OT";

font-size:18px;

color:#00C;

}

.opt{

width: 18%;

height:35px;

border-radius:5px;

border-color:#F00;

margin-left:11%;

font-family:"Phetsarath OT";

font-size:18px;

color:#00C;

}

#opt2{

width: 10%;

height:35px;

border-radius:5px;

border-color:#F00;

margin-left:4%;

font-family:"Phetsarath OT";

font-size:18px;

color:#00C;

}

input{

width: 60%;

height:40px;

border-radius:8px;

border-color:#F00;

margin-left:20%;

font-family:"Phetsarath OT";

font-size:18px;

color:#00C;

}

.inp{

width: 60%;

height:40px;

border-radius:8px;

border-color:#F00;

margin-left:20%;

font-family:"Phetsarath OT";

font-size:18px;

color:#00C;

}

#bt{

background:#039;

border: 5px #FFCC00;

width: 30%;

height:45px;

border-radius:5px;

border-top-color: 5px #FF0000;

border-color:#F00;

margin-left:35%;

font-family:"Phetsarath OT";

font-size: 24px;

color:#FFF;

text-align:center;

}

#td{

background:#00C;

font-family:"Phetsarath OT";

    font-size: 16px;

color:#FFF;

}

#td2{

background:#CFF;

font-family:"Phetsarath OT";

    font-size: 14px;

color:#009;

}

#td3{

background:#CFF;

width:100%;

border:none;

font-family:"Phetsarath OT";

    font-size: 14px;

color:#009;

text-align:center;

}

</style>

</head>

<body>

<script>

function disp1(){

var a = document.getElementById("aa").value;

document.getElementById("bb").value = a;

   }

   </script>

<div style=" background-color:#09C; width:90%; height:180px; margin-left:5%;"><center><img src="banner.jpg" style="width:100%; height:180px;"></center></div>

<div style="width:90%; margin-left:5%; background-color:#99F;"><br>

<form action="" method="POST" enctype="multipart/form-data">

<input type="text" name="t1" placeholder="ຜູ້ໃຊ້"> <br><br>

 <select id="aa" class="inp" style="height:35px;" required name="t4" onChange="">

            <option value="" disabled selected>ເລືອກສະຖານະ</option>          

           <option>Admin</option> 

               <option>Teacher</option> 

                <option>Student</option>   

        </select><br /> <br />

<input type="text" name="t2" placeholder="ລະຫັດເຂົ້າລະບົບ"> <br><br>

<input type="text" name="t3" placeholder="ຢືນຢັນລະຫັດເຂົ້າລະບົບ"> <br><br>

<button name="b1" id="bt">ເພີ່ມຂໍ້ມູນເຂົ້າລະບົບ</button> <br><br><br><br><br>

<?php

require_once('DBC.php'); 

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

$t1=$_POST['t1'];

$t2=$_POST['t2'];

$t3=$_POST['t3'];

$sql = "insert into login (User, Password, Status) values ('$t1', '$t2', '$t3')";

mysqli_query($con, $sql);

}

?>

<table border="1" cellpadding="5" cellspacing="0" width="90%" align="center">

  <tr>

    <td style=" background-color:#9FF; text-align:center; font-family:'Saysettha OT'; font-size:24px; color:red;" width="10%" height="45px;" align="center">ລໍາດັບ</td>

    <td style=" background-color:#9FF; font-family:'Saysettha OT'; font-size:24px; color:red;" align="center" width="25%">ຜູ້ໃຊ້</td>

    <td style=" background-color:#9FF; font-family:'Saysettha OT'; font-size:24px; color:red;" align="center" width="25%">ລະຫັດ</td>

    <td style=" background-color:#9FF; font-family:'Saysettha OT'; font-size:24px; color:red;" align="center" width="10%">ສະຖານະ</td>  

   <td colspan="2" style=" background-color:#9FF; text-align:center; font-family:'Saysettha OT'; font-size:24px; color:red; width:20%;">ແກ້ໄຂຂໍ້ມູນ</td>

  </tr>

  <?php

  //require_once('DCon.php');

  $sql = "select * from login "; 

  $query=mysqli_query($con, $sql);

 if($query){

$i = 0;

  while ($row_MyRecord = mysqli_fetch_object($query)) { ?>

    <tr>

$i++;

      <td style="text-align:center;"><?php echo $i;?></td>

      <td><?php echo $row_MyRecord->User?></td>

      <td><?php echo $row_MyRecord->Password?></td>

      <td><?php echo $row_MyRecord->Status?></td>

   <td width="5%" style="text-align:center;"><a href="UpdateLog.php?Edit=<?php echo $row_MyRecord->User; ?>">

   ແກ້ໄຂ</a></td>

   <td style="font-weight:300; text-align:center;" width="5%"><a href="DelLog.php?i=<?php echo $row_MyRecord->User; ?>">

   ລົບ</a></td>

    </tr>

    <?php

}

  }?>

</table>

</form>

</div>

</body>

</html>

<?php

include('DBC.php');

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

if(empty($_POST['User']) || empty($_POST['Pass'])){

    echo' Pass and name needed';

    }

else{

    $User = $_POST['User'];

    $Pass = $_POST['Pass'];

$sql = "select * from login where User = '$User' and Password = '$Pass' ";

$query = mysqli_query($con, $sql);

if($row = mysqli_fetch_object($query)){ 

    if($row->Status == 'Admin'){

    header("location: MainAdmin.php");

    mysql_close($con);

    }

    else if($row->Status == 'Teacher'){

        header("location: MainTeacher.php");

        }

    else if($row->Status == 'Student'){

        header("location: Report.php");

        }

        else{$error='ຂໍ້ມູນບໍ່ຖືກຕ້ອງ';}

}

    else{$error='ຊື່ແລະລະຫັດບໍ່ຖືກຕ້ອງ';}

  }     

    }

        ?>

<?php

include('DBC.php');

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

if(empty($_POST['User']) || empty($_POST['Pass'])){

    echo' Pass and name needed';

    }

else{

    $User = $_POST['User'];

    $Pass = $_POST['Pass'];

$sql = "select * from login where User = '$User' and Password = '$Pass' ";

$query = mysqli_query($con, $sql);

if($row = mysqli_fetch_object($query)){ 

    if($row->Status == 'Admin'){

    header("location: MainAdmin.php");

    mysql_close($con);

    }

    else if($row->Status == 'Teacher'){

        header("location: MainTeacher.php");

        }

    else if($row->Status == 'Student'){

        header("location: Report.php");

        }

        else{$error='ຂໍ້ມູນບໍ່ຖືກຕ້ອງ';}

}

    else{$error='ຊື່ແລະລະຫັດບໍ່ຖືກຕ້ອງ';}

  }     

    }

        ?>

<?php

include('DBC.php');

    $S = $_GET['i'];

    $sql1 = "delete from login where User = '$S' ";

if(mysqli_query($con, $sql1)){

    header("refresh:0; url=User.php");

    }

    else{echo'Not Delete';}

?>

<?php

include('DBC.php');

$dd = $_GET['Edit'];

    $sql = "select * from login where User = '$dd'";

    $query = mysqli_query($con, $sql);

    if($query){

        if($row=mysqli_fetch_assoc($query)){

        ?>

<div class="container">      

        <form method="post" enctype="multipart/form-data" class="form">

     <input type="text" name="u1" value="<?php echo $row['User']; ?>" ><br><br>

    <input type="text" name="u2" value="<?php echo $row['Password']; ?>" ><br><br>

    <input type="text" name="u3" value="<?php echo $row['Status']; ?>" ><br><br>

    <input type="submit" name="update" value="ແກ້ໄຂ" id="button">

    </form></div>

    <?php  

    try{

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

        $pp1=$_POST['u1'];

        $pp2=$_POST['u2'];

        $pp3=$_POST['u3'];

  // $sq ="update login set User = '$_POST[u1]', Password = '$_POST[u2]', Status = '$_POST[u3]' where User = '$pp1' ";

  $sq ="update login set User = '$_POST[u1]', Password = '$_POST[u2]', Status = '$_POST[u3]' where User = '$pp1' ";

if(mysqli_query($con, $sq)){

   header("refresh:0; User.php");

       }

       else{echo'Not Update';}

}

    }

    catch(Exception $ex){}

    }   }?>

</body>

</html>