Skip to content
Permalink
1fc184b196
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Abc-Air-Website1/Project/home.php

Go to file
 
 
Cannot retrieve contributors at this time
186 lines (167 sloc) 8.21 KB
Raw Blame
<?php
session_start();
if (isset($_SESSION['user_id']) && isset($_SESSION['user_email']))
{
$mysqli = NEW MySQLi('localhost', 'root', '', 'test_db');
$af_list = $mysqli->query("select af_name, af_id from airframe");
$eng_list = $mysqli->query("select full_name from users where role='eng'");
$task_list = $mysqli->query("select task_name from task");
$log_hr = $mysqli->query("select af_name, af_num, af_flight_hr from airframe");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>ABC | LOG</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.7.2/font/bootstrap-icons.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-alpha3/dist/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.9.0/css/bootstrap-datepicker.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/js/bootstrap.bundle.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.9.0/js/bootstrap-datepicker.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-alpha3/dist/js/bootstrap.bundle.min.js"></script>
</head>
<body>
<style type="text/css">
.box{
display: none;
}
</style>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<div class="container-fluid">
<a class="navbar-brand">ABC AIR</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarText" aria-controls="navbarText" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarText">
<ul class="navbar-nav me-auto mb-2 mb-lg-0">
<li class="nav-item">
<i class="nav-link bi bi-person-fill"></i>
</li>
<li class="nav-item">
<a class="nav-link active" href="index.php"><?=$_SESSION['user_full_name']?></a>
</li>
<li class="nav-item">
<a class="nav-link" href="home.php">Log</a>
</li>
<li class="nav-item">
<a class="nav-link" href="manage.php">Manage</a>
</li>
</ul>
<span class="navbar-text">
<a href="logout.php" class="btn btn-warning">LOGOUT</a>
</span>
</div>
</div>
</nav>
<div class="d-flex justify-content-center align-items-center">
<form class="p-5 rounded shadow" action="logupdate.php" method="post" style="width: 40rem;">
<div class="input-group mb-3">
<label class="input-group-text" for="inputGroupSelect01">Select Air Frame</label>
<select class="form-select" id="inputGroupSelect01" name="airframe">
<?php
while ($rows = $af_list->fetch_assoc())
{
$af_name = $rows['af_name'];
echo "<option value='$af_name'>$af_name</option>";
}
?>
</select>
</div>
<div class="form-check mb-2">
<input class="form-check-input" type="radio" value="one" name="flexRadioDefault" id="flightHr">
<label class="form-check-label" for="flexRadioDefault1">
Log Flight Hours
</label>
</div>
<div class="form-check mb-2">
<input class="form-check-input" type="radio" value="two" name="flexRadioDefault" id="scheduleMain">
<label class="form-check-label" for="flexRadioDefault1">
Log Schedule Maintenence
</label>
</div>
<div class="box one">
<div class="input-group mb-3">
<span class="input-group-text" id="inputGroup-sizing-default">Log Flight Hours</span>
<input type="text" name="af_flight_hr" class="form-control" aria-label="Sizing example input" aria-describedby="inputGroup-sizing-default">
</div>
<input class="btn btn-primary" type="submit" name="update" value="Submit">
</div>
<div class="box two">
<div class="input-group mb-3">
<label class="input-group-text" for="inputGroupSelect01">Select Engineer</label>
<select class="form-select" id="inputGroupSelect01" name="users">
<?php
while ($rows = $eng_list->fetch_assoc())
{
$full_name = $rows['full_name'];
echo "<option value='$full_name'>$full_name</option>";
}
?>
</select>
</div>
<div class="input-group mb-3">
<label class="input-group-text" for="inputGroupSelect01">Select Maintenance Task</label>
<select class="form-select" id="inputGroupSelect01" name="task">
<?php
while ($row = $task_list->fetch_assoc())
{
$task_name = $row['task_name'];
echo "<option value='$task_name'>$task_name</option>";
}
?>
</select>
</div>
<div class="row form-group">
<label class="col-sm-3 col-from-label" for="date">Select Date</label>
<div class="col-sm-5">
<div class="input-group date" id="datepicker">
<input type="text" name="dat" class="form-control">
<span class="input-group-append">
<span class="input-group-text bg-white">
<i class="fa fa-calendar"></i>
</span>
</span>
</div>
</div>
</div>
<input class="btn btn-primary" type="submit" name="upd" value="Submit">
</div>
</form>
</div>
<div class="d-flex justify-content-center align-items-center" style="padding-top: 20px;">
<?php
if (isset($_SESSION['status']))
{
echo "<h4>".$_SESSION['status']."</h4>";
unset($_SESSION['status']);
}
?>
</div>
<script type="text/javascript">
$(document).ready(function(){
$('input[type="radio"]').click (function(){
var inputValue =$(this).attr("value");
var targetBox =$("."+ inputValue);
$(".box").not(targetBox).hide();
$(targetBox).show();
});
});
$(function(){
$('#datepicker').datepicker();
});
</script>
</body>
</html>
<?php
}else
{
header("Location: login.php");
}
?>