Coding
Login Re
<!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>
Login 1
<?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='ຊື່ແລະລະຫັດບໍ່ຖືກຕ້ອງ';}
}
}
?>
Login 2
<?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='ຊື່ແລະລະຫັດບໍ່ຖືກຕ້ອງ';}
}
}
?>
Delete (ນັກສຶກສາສ້າງຟາຍ ຊື່ວ່າ: DelLog.php ແລ້ວກອບປີ້ຂໍ້ທີ່ 4 ໄປວາງໃສ່)
<?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';}
?>
Update (ນັກສຶກສາສ້າງຟາຍ ຊື່ວ່າ: UpdateLog.php ແລ້ວກອບປີ້ຂໍ້ທີ່ 5 ໄປວາງໃສ່)
<?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>