Membuat web E - Ticketing Peswat
1. Membuat database
Tabel Flight
Tabel User
Lanjut ke codinganya
Connect
<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);
class Libcore
{
public $pdo = null;
/**
* Melakukan koneksi ke database
*/
function connect()
{
// Database credentials
$host = 'localhost'; // your database host
$username = 'root'; // your database username
$password = ''; // your database password
$database = 'tugas_udintiket'; // your database name
try {
$this->pdo = new PDO("mysql:host=$host;dbname=$database", $username, $password);
} catch (PDOException $e) {
die("Connection failed: " . $e->getMessage());
}
}
/**
*`
*/
function insertFlight($a, $file)
{
$sql = "INSERT INTO Flight (foto,maskapai, tanggal_penerbangan, kuota, bandara_asal, jam_kedatangan, tujuan_akhir, sektor, harga, jam_berangkat, jam_tiba)
VALUES (:foto, :maskapai, :tanggal_penerbangan, :kuota, :bandara_asal, :jam_kedatangan, :tujuan_akhir, :sektor, :harga, :jam_berangkat, :jam_tiba)";
// Prepare and execute the SQL statement
$stmt = $this->pdo->prepare($sql);
$stmt->bindParam(':maskapai', $a["maskapai"]);
$stmt->bindParam(':tanggal_penerbangan', $a["tanggal_penerbangan"]);
$stmt->bindParam(':kuota', $a["kuota"]);
$stmt->bindParam(':bandara_asal', $a["bandara_asal"]);
$stmt->bindParam(':jam_kedatangan', $a["jam_kedatangan"]);
$stmt->bindParam(':tujuan_akhir', $a["tujuan_akhir"]);
$stmt->bindParam(':sektor', $a["sektor"]);
$stmt->bindParam(':harga', $a["harga"]);
$stmt->bindParam(':jam_berangkat', $a["jam_berangkat"]);
$stmt->bindParam(':jam_tiba', $a["jam_tiba"]);
$namafoto = uniqid() . ".png";
$this->uploadFile($file, getcwd() . "/../public/foto/", $namafoto);
$stmt->bindParam(':foto', $namafoto);
return $stmt->execute();
}
function insertTicket($user_id, $kode_pnr, $tanggal, $flight_id)
{
$sql = "INSERT INTO Orders (user_id, kode_pnr, tanggal, flight_id) VALUES (:user_id, :kode_pnr, :tanggal, :flight_id) ";
// Prepare and execute the SQL statement
$stmt = $this->pdo->prepare($sql);
$stmt->bindParam(':user_id', $user_id);
$stmt->bindParam(':kode_pnr', $kode_pnr);
$stmt->bindParam(':tanggal', $tanggal);
$stmt->bindParam(':flight_id', $flight_id);
return $stmt->execute();
}
function deleteFlight($id)
{
$stmt = $this->pdo->prepare("DELETE FROM `Flight` WHERE `flight_id`=:id");
$stmt->bindParam(":id", $id);
return $stmt->execute();
}
function getTicket($user_id)
{
$stmt = $this->pdo->prepare("SELECT * FROM Orders INNER JOIN User INNER JOIN Flight ON Orders.user_id = User.user_id AND Flight.flight_id = Orders.flight_id WHERE Orders.user_id = :user_id");
$stmt->bindParam(":user_id", $user_id);
$stmt->execute();
return $stmt->fetchAll();
}
function getTicketList()
{
$stmt = $this->pdo->prepare("SELECT * FROM Orders INNER JOIN User INNER JOIN Flight ON Orders.user_id = User.user_id AND Flight.flight_id = Orders.flight_id");
$stmt->execute();
return $stmt->fetchAll();
}
function uploadFile($file, $targetDirectory, $nf)
{
$targetFile = $targetDirectory . $nf;
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($targetFile, PATHINFO_EXTENSION));
// Check if the file already exists
if (file_exists($targetFile)) {
return "Sorry, the file already exists.";
}
// Check file size (adjust as needed)
if ($file["size"] > 50000000) {
return "Sorry, your file is too large.";
}
// Allow certain file formats (you can customize this list)
$allowedExtensions = ["jpg", "jpeg", "png", "gif"];
if (!in_array($imageFileType, $allowedExtensions)) {
return "Sorry, only JPG, JPEG, PNG, and GIF files are allowed.";
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
return "Sorry, your file was not uploaded.";
} else {
// If everything is ok, try to upload the file
if (move_uploaded_file($file["tmp_name"], $targetFile)) {
return "The file " . htmlspecialchars(basename($file["name"])) . " has been uploaded.";
} else {
return "Sorry, there was an error uploading your file.";
}
}
}
function editFlight($a, $id)
{
$sql = "UPDATE Flight SET
maskapai = :maskapai,
tanggal_penerbangan = :tanggal_penerbangan,
kuota = :kuota,
bandara_asal = :bandara_asal,
jam_kedatangan = :jam_kedatangan,
tujuan_akhir = :tujuan_akhir,
sektor = :sektor,
harga = :harga,
jam_berangkat = :jam_berangkat,
jam_tiba = :jam_tiba
WHERE flight_id= :flight_id";
// Prepare and execute the SQL statement
$stmt = $this->pdo->prepare($sql);
$stmt->bindParam(':flight_id', $id);
$stmt->bindParam(':maskapai', $a["maskapai"]);
$stmt->bindParam(':tanggal_penerbangan', $a["tanggal_penerbangan"]);
$stmt->bindParam(':kuota', $a["kuota"]);
$stmt->bindParam(':bandara_asal', $a["bandara_asal"]);
$stmt->bindParam(':jam_kedatangan', $a["jam_kedatangan"]);
$stmt->bindParam(':tujuan_akhir', $a["tujuan_akhir"]);
$stmt->bindParam(':sektor', $a["sektor"]);
$stmt->bindParam(':harga', $a["harga"]);
$stmt->bindParam(':jam_berangkat', $a["jam_berangkat"]);
$stmt->bindParam(':jam_tiba', $a["jam_tiba"]);
return $stmt->execute();
}
function getFlightList()
{
$stmt = $this->pdo->prepare("SELECT * FROM `Flight`");
$stmt->execute();
return $stmt->fetchAll();
}
function getFlight($id)
{
$stmt = $this->pdo->prepare("SELECT * FROM `Flight` WHERE `flight_id`=:id");
$stmt->bindParam(":id", $id);
$stmt->execute();
return $stmt->fetch();
}
function getUser($email)
{
$stmt = $this->pdo->prepare("SELECT * FROM `User` WHERE `email`=:email");
$stmt->bindParam(":email", $email);
$stmt->execute();
return $stmt->fetch();
}
function loginUser($u, $p)
{
$stmt = $this->pdo->prepare("SELECT * FROM `User` WHERE `email`=:user AND `password`=:pass AND `role`=0");
$stmt->bindParam(':user', $u);
$stmt->bindParam(':pass', $p);
// Execute the statement
$stmt->execute();
// Fetch all rows as an associative array
$tickets = $stmt->fetch();
if (gettype($tickets) == "boolean") {
return false;
} else if (gettype($tickets) == "array" && count($tickets) > 0) {
setcookie("user", $u, time() + 3600);
setcookie('pass', $p, time() + 3600);
return count($tickets) > 0;
}
return false;
}
function loginStaff($u, $p)
{
$stmt = $this->pdo->prepare("SELECT * FROM `User` WHERE `email`=:user AND `password`=:pass AND `role`=1");
$stmt->bindParam(':user', $u);
$stmt->bindParam(':pass', $p);
// Execute the statement
$stmt->execute();
// Fetch all rows as an associative array
$tickets = $stmt->fetch();
if (gettype($tickets) == "boolean") {
return false;
} else if (gettype($tickets) == "array" && count($tickets) > 0) {
setcookie("user", $u, time() + 3600);
setcookie('pass', $p, time() + 3600);
return count($tickets) > 0;
}
return false;
}
function loginAdmin($u, $p)
{
$stmt = $this->pdo->prepare("SELECT * FROM `User` WHERE `email`=:user AND `password`=:pass AND `role`=2");
$stmt->bindParam(':user', $u);
$stmt->bindParam(':pass', $p);
// Execute the statement
$stmt->execute();
// Fetch all rows as an associative array
$tickets = $stmt->fetch();
if (gettype($tickets) == "boolean") {
return false;
} else if (gettype($tickets) == "array" && count($tickets) > 0) {
setcookie("user", "", time() - 3600, "/");
setcookie("pass", "", time() - 3600, "/");
setcookie("user", $u, time() + 3600);
setcookie('pass', $p, time() + 3600);
return count($tickets) > 0;
}
return false;
}
function registerUser($nama, $email, $pass)
{
$stmt = $this->pdo->prepare("INSERT INTO `User`(`nama`, `email`, `password`, role) VALUES (:nama, :email, :pass, 0) ");
$stmt->bindParam(':email', $email);
$stmt->bindParam(':nama', $nama);
$stmt->bindParam(':pass', $pass);
// Execute the statement
return $stmt->execute();
// Fetch all rows as an associative array
}
function confirmTicket($id)
{
$stmt = $this->pdo->prepare("UPDATE `Orders` SET `konfirmasi`=1 WHERE `order_id`=:order_id");
$stmt->bindParam(':order_id', $id);
// Execute the statement
return $stmt->execute();
// Fetch all rows as an associative array
}
function isUserLogin()
{
if (isset($_COOKIE["user"]) && isset($_COOKIE["pass"])) {
if (!$this->loginUser($_COOKIE["user"], $_COOKIE["pass"])) {
die("akun anda salah username atau password");
}
} else {
die("<script>alert('Anda belum login');window.location.href = 'login.php'</script>");
}
}
function isStaffLogin()
{
if (isset($_COOKIE["user"]) && isset($_COOKIE["pass"])) {
if (!$this->loginStaff($_COOKIE["user"], $_COOKIE["pass"])) {
die("<script>alert('Anda belum masuk sebagai petugas');window.location.href = 'login.php'</script>");
}
} else {
die("<script>alert('Anda belum login sebagai petugas');window.location.href = 'login.php'</script>");
}
}
function isAdminLogin()
{
if (isset($_COOKIE["user"]) && isset($_COOKIE["pass"])) {
if (!$this->loginAdmin($_COOKIE["user"], $_COOKIE["pass"])) {
die(var_dump($_COOKIE));
}
} else {
die("<script>alert('Anda belum login sebagai admin');window.location.href = 'login.php'</script>");
}
}
function logout()
{
setcookie("user", "", time() - 3600, "/");
setcookie("pass", "", time() - 3600, "/");
setcookie("user", "", time() - 3600);
setcookie("pass", "", time() - 3600);
setcookie("user", "", time() - 3600, "/admin");
setcookie("pass", "", time() - 3600, "/admin");
setcookie("user", "", time() - 3600, "/petugas");
setcookie("pass", "", time() - 3600, "/petugas");
}
}
Login
<?php
include "./core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$msg = '<div class="alert alert-warning p-2"><small>Masuk ke akun anda</small></div>';
if(isset($_POST["user"]) && isset($_POST["pass"])) {
if($core->loginUser($_POST["user"], $_POST["pass"])){
header("Location: index.php");
}
else {
$msg = '<div class="alert alert-danger p-2"><small>Email atau Passsword salah</small></div>';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Indonesia AirLines</title>
<link href="./styles/bootstrap.min.css" rel="stylesheet">
<link href="./styles/styles.css" rel="stylesheet">
</head>
<body class="container" style="background-image: url(./image/jet.jpg); background-repeat: no-repeat;background-size: cover;">
<center>
<form class=" p-3" action="" style="max-width: 500px;border: 2px solid #eee;border-radius: 10px;margin-top: 25vh;background: rgba(255,255,255,0.8)" method="post">
<center><h3 class="mb-0">Indonesia AirLines</h3></center>
<small class="text-muted">Harga Merakyat</small>
<hr>
<?= $msg; ?>
<input class="form-control" placeholder="Email" name="user">
<input class="form-control mt-3" placeholder="Password" name="pass">
<button class="btn btn-success mt-3 w-100">Login</button>
<hr>
<a href="register.php">Klik untuk mendaftar akun</a>
</form>
</center>
</body>
</html>
LogOut
<?php
$currentPath = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH);
$p= dirname($currentPath);
setcookie("user", "", time() - 3600, "$p/");
setcookie("pass", "", time() - 3600, "$p/");
setcookie("user", "", time() - 3600);
setcookie("pass", "", time() - 3600);
setcookie("user", "", time() - 3600, "$p/admin");
setcookie("pass", "", time() - 3600, "$p/admin");
setcookie("user", "", time() - 3600, "$p/petugas");
setcookie("pass", "", time() - 3600, "$p/petugas");
header("Location: index.php");
?>
Home User
<?php
include "./core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$core->isUserLogin();
$data = $core->getFlightList();
$x = $core->getUser($_COOKIE["user"]);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>RESERVASI PESAWAT</title>
<link href="./styles/bootstrap.min.css" rel="stylesheet">
<link href="./styles/styles.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark" style="background-color: #86B6F6;">
<div class="container-fluid ps-5">
<a class="navbar-brand" href="#">Indonesia AirLines</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav w-100 ms-auto" style="float: right;">
<li class="nav-item">
<a class="nav-link active" aria-current="page" href="#">Form Pemesanan</a>
</li>
<li class="nav-item w-75">
<a class="nav-link" aria-current="page" href="pesanan.php">Tiket Saya</a>
</li>
<li class="nav-item dropdown" style="margin-left: 3%;">
<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-bs-toggle="dropdown" aria-expanded="false">
<?= $x["nama"] ?>
</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
<li><a class="dropdown-item" href="#">Logout</a></li>
<li><a class="dropdown-item" href="admin/login.php">Login Admin</a></li>
<li><a class="dropdown-item" href="petugas/login.php">Login Staff</a></li>
</ul>
</li>
</ul>
</div>
</div>
</nav>
<div class="container mt-5 d-flex">
<?php foreach ($data as $flight) : ?>
<div class="col-md-3 mb-4 h-50 m-1">
<div class="card" style="height: 550px;">
<div class="card-body">
<img src="./public/foto/<?= $flight['foto']; ?>" class="card-img-top" alt="..." height="250">
<h5 class="card-title mb-0"><?= $flight['maskapai'] ?> #<?= $flight['flight_id'] ?></h5>
<p class="text-muted mb-3 h6"><?= $flight['bandara_asal'] ?> - <?= $flight['tujuan_akhir'] ?></p>
Jam Penerbangan: <?= $flight['tanggal_penerbangan'] ?><br>
Quota: <?= $flight['kuota'] ?><br>
<!-- Add other data fields as needed -->
<!-- Example: -->
Sektor: <?= $flight['sektor'] ?><br>
Waktu Kedatangan: <?= $flight['jam_kedatangan'] ?>
</p>
<!-- Add more fields as needed -->
<form method="post" action="booking.php">
<input name="id" value="<?= $flight['flight_id'] ?>" type="hidden">
<hr>
<small class="text-muted">harga: Rp<?= $flight['harga'] ?></small>
<button class="btn btn-success w-100">Pesan Tiket</a>
</form>
</div>
</div>
</div>
<?php endforeach; ?>
</div>
<script src="./styles/bootstrap.bundle.min.js"></script>
</body>
</html>
Register
<?php
include "./core/libcore_backend.php";
$core = new Libcore();
$core->connect();
if(isset($_POST["nama"]) && isset($_POST["email"]) && isset($_POST["pass"])) {
$x = $core->registerUser($_POST["nama"], $_POST["email"], $_POST["pass"]);
if($x){
$msg = '<div class="alert alert-success p-2"><small>Akun telah dibuat </small></div>';
}
else {
if($x){
$msg = '<div class="alert alert-success p-2"><small>Akun gagal dibuat </small></div>';
}
}
}
$msg = '<div class="alert alert-warning p-2"><small>Registrasi Akun</small></div>';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Indonesia Airlines</title>
<link href="./styles/bootstrap.min.css" rel="stylesheet">
<link href="./styles/styles.css" rel="stylesheet">
</head>
<body class="container" style="background-image: url(./image/jet.jpg); background-repeat: no-repeat;background-size: cover;">
<center>
<form class=" p-3" action="" style="max-width: 500px;border: 2px solid #eee;border-radius: 10px;margin-top: 20vh;background: rgba(255,255,255,0.8)" method="post">
<center><h3 class="mb-0">Indonesia Airlines</h3></center>
<small class="text-muted">Harga muurah merakyat</small>
<hr>
<?= $msg; ?>
<input class="form-control mt-3 w-100" placeholder="Nama" name="nama">
<div class="d-flex justify-content-start"><small class="text-muted" style="text-align: start;">Masukkan nama depan dan belakang anda</small></div>
<input class="form-control mt-3" placeholder="Email" name="email" type="email">
<div class="d-flex justify-content-start"><small class="text-muted" style="text-align: start;">Masukkan email yang valid (harus memiliki simbol '@')</small></div>
<input class="form-control mt-3" placeholder="Password" name="pass">
<div class="d-flex justify-content-start"><small class="text-muted" style="text-align: start;">Masukkan password yang ingin digunakan</small></div>
<button class="btn btn-success mt-3 w-100">Register</button>
</form>
</center>
</body>
</html>
Pesanan
<?php
include "./core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$core->isUserLogin();
$x = $core->getUser($_COOKIE["user"]);
$data = $core->getTicket($x["user_id"]);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>RESERVASI PESAWAT</title>
<link href="./styles/bootstrap.min.css" rel="stylesheet">
<link href="./styles/styles.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark" style="background-color: #86B6F6;">
<div class="container-fluid ps-5">
<a class="navbar-brand" href="#">Indonesia Airlines</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav w-100 ms-auto" style="float: right;">
<li class="nav-item">
<a class="nav-link" aria-current="page" href="index.php">Form Pemesanan</a>
</li>
<li class="nav-item w-75">
<a class="nav-link active" aria-current="page" href="pesanan.php">Tiket Saya</a>
</li>
<li class="nav-item dropdown" style="margin-left: 3%;">
<a class="nav-link active dropdown-toggle" href="#" id="navbarDropdown" role="button" data-bs-toggle="dropdown" aria-expanded="false">
<?= $x["nama"] ?>
</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
<li><a class="dropdown-item" href="#">Logout</a></li>
<li><a class="dropdown-item" href="admin/login.php">Login Adminf</a></li>
<li><a class="dropdown-item" href="petugas/login.php">Login Staff</a></li>
</ul>
</li>
</ul>
</div>
</div>
</nav>
<div class="container mt-5 ">
<h4 class="text-muted">User Area > Ticket Status</h4>
<table class="table table-sm table-striped table-bordered">
<thead>
<tr>
<th>Maskapai</th>
<th>Tujuan</th>
<th>Sektor</th>
<th>Tanggal Penerbangan</th>
<th>Jam Kedatangan</th>
<th>Jam Keberangkatan</th>
<th>Jam Tiba</th>
<th>Kode PNR</th>
<th>Harga</th>
<th>Konfirmasi</th>
</tr>
</thead>
<tbody>
<tr>
<?php
foreach ($data as $f) :
?>
<td><?= $f["maskapai"] ?></td>
<td><?= $f["bandara_asal"] ?> - <?= $f["tujuan_akhir"] ?> </td>
<td><?= $f["sektor"] ?></td>
<td><?= $f["tanggal_penerbangan"] ?></td>
<td><?= $f["jam_kedatangan"] ?></td>
<td><?= $f["jam_berangkat"] ?></td>
<td><?= $f["jam_tiba"] ?></td>
<td><?= $f["kode_pnr"]; ?></td>
<td><?= $f["harga"] ?></td>
<td><?= $f["konfirmasi"] == 0 ? "<small class='text-danger'>belum</small>" : "<a class='btn btn-sm btn-success'>Cetak tiket</a>"; ?></td>
</tr>
<?php
endforeach;
?>
</tbody>
</table>
</div>
<script src="./styles/bootstrap.bundle.min.js"></script>
</body>
</html>
Lanjut ke Admin
data_penerbangan
<?php
include "./../core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$core->isAdminLogin();
if(isset($_GET["del"])){
if($core->deleteFlight($_GET["del"])) echo "<script>alert('Data telah dihapus')</script>";
}
$data = $core->getFlightList();
$x = $core->getUser($_COOKIE["user"]);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>RESERVASI PESAWAT</title>
<link href="./../styles/bootstrap.min.css" rel="stylesheet">
<link href="./../styles/styles.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark" style="background-color: #86B6F6;">
<div class="container-fluid ps-5">
<a class="navbar-brand" href="#">Indonesia Airlines<small><i>staff</i></small></a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav w-100 ms-auto" style="float: right;">
<li class="nav-item" >
<a class="nav-link active" aria-current="page" href="data_penerbangan.php">Data</a>
</li>
<li class="nav-item" style="width: 85%;">
<a class="nav-link" aria-current="page" href="tambah_penerbangan.php">Tambah Penerbangan</a>
</li>
<li class="nav-item dropdown" style="margin-left: 3%;">
<a class="nav-link active dropdown-toggle" href="#" id="navbarDropdown" role="button" data-bs-toggle="dropdown" aria-expanded="false">
<?= $x["nama"] ?>
</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
<li><a class="dropdown-item" href="./../logout.php">Logout</a></li>
<li><a class="dropdown-item" href="./../admin/login.php">Login to Admin</a></li>
<li><a class="dropdown-item" href="./../petugas/login.php">Login to Staff</a></li>
</ul>
</li>
</ul>
</div>
</div></nav>
<div class="container mt-5">
<h2>Flight Data</h2>
<table class="table table-striped table-bordered">
<thead>
<tr>
<th>Maskapai</th>
<th>Tanggal Penerbangan</th>
<th>Kuota</th>
<th>Bandara Asal</th>
<th>Jam Kedatangan</th>
<th>Tujuan Akhir</th>
<th>Sektor</th>
<th>Harga</th>
<th>Jam Berangkat</th>
<th>Jam Tiba</th>
<th>Image</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php foreach ($data as $flight) : ?>
<tr>
<td><?= strval($flight['maskapai']); ?></td>
<td><?= strval( $flight['tanggal_penerbangan']); ?></td>
<td><?= strval( $flight['kuota']); ?></td>
<td><?= $flight['bandara_asal']; ?></td>
<td><?= $flight['jam_kedatangan']; ?></td>
<td><?= $flight['tujuan_akhir']; ?></td>
<td><?= $flight['sektor']; ?></td>
<td><?= $flight['harga']; ?></td>
<td><?= $flight['jam_berangkat']; ?></td>
<td><?= $flight['jam_tiba']; ?></td>
<td><img src="./../public/foto/<?= $flight['foto']; ?>" width="100" height="100"> </td>
<td><a class="btn btn-success btn-sm m-1" href="edit_penerbangan.php?id=<?= $flight['flight_id']; ?>">Edit</a><a class="btn btn-danger btn-sm m-1" href="?del=<?= $flight['flight_id'] ?>">Hapus</a></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
<script src="./../styles/bootstrap.bundle.min.js"></script>
</div>
</body>
</html>
edit_penerbangan
<?php
include "./../core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$core->isAdminLogin();
$f = $core->getFlight($_GET["id"]);
$msg = "";
if (isset($_POST["maskapai"]) && isset($_GET["edit"])) {
if ($core->editFlight($_POST, $_GET["id"]))
$msg = '<div class="alert alert-success p-2"><small>Data telah di edit </small></div>';
else
$msg = '<div class="alert alert-success p-2"><small>Data gagal di edit </small></div>';
}
$x = $core->getUser($_COOKIE["user"]);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>RESERVASI PESAWAT</title>
<link href="./../styles/bootstrap.min.css" rel="stylesheet">
<link href="./../styles/styles.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark" style="background-color: #86B6F6;">
<div class="container-fluid ps-5">
<a class="navbar-brand" href="#">Indonesia AirLines<small><i>staff</i></small></a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav w-100 ms-auto" style="float: right;">
<li class="nav-item" >
<a class="nav-link active" aria-current="page" href="data_penerbangan.php">Data</a>
</li>
<li class="nav-item" style="width: 85%;">
<a class="nav-link" aria-current="page" href="tambah_penerbangan.php">Tambah Penerbangan</a>
</li>
<li class="nav-item dropdown" style="margin-left: 3%;">
<a class="nav-link active dropdown-toggle" href="#" id="navbarDropdown" role="button" data-bs-toggle="dropdown" aria-expanded="false">
<?= $x["nama"] ?>
</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
<li><a class="dropdown-item" href="./../logout.php">Logout</a></li>
<li><a class="dropdown-item" href="./../admin/login.php">Login to Admin</a></li>
<li><a class="dropdown-item" href="./../petugas/login.php">Login to Staff</a></li>
</ul>
</li>
</ul>
</div>
</div></nav>
<div class="container mt-5">
<div class="container mt-5 m-5 p-3" style="border: 2px solid #eee;border-radius: 10px">
<h2>Edit Penerbangan</h2>
<?= $msg ?>
<form method="post" action="edit_penerbangan.php?id=<?= $_GET['id'] ?>&edit=true">
<!-- Dropdown for Maskapai -->
<div class="mb-3">
<label for="maskapai" class="form-label">Maskapai</label>
<select class="form-select" id="maskapai" name="maskapai" required>
<option value="ryan_air" <?= $f["maskapai"] == 'ryan_air' ? 'selected' :'' ?>>Ryan Air</option>
<option value="batik_air" <?= $f["maskapai"] == 'batik_air' ? 'selected' :'' ?>>Batik Air</option>
<option value="easyjet" <?= $f["maskapai"] == 'easyjet' ? 'selected' :'' ?>>EasyJet</option>
</select>
</div>
<!-- Date input for Tanggal Penerbangan -->
<div class="mb-3">
<label for="tanggal_penerbangan" class="form-label">Tanggal Penerbangan</label>
<input type="date" class="form-control" id="tanggal_penerbangan" name="tanggal_penerbangan" value="<?= $f["tanggal_penerbangan"] ?>" required>
</div>
<!-- Number input for Kuota -->
<div class="mb-3">
<label for="kuota" class="form-label">Kuota</label>
<input type="number" class="form-control" id="kuota" name="kuota" value="<?= $f["kuota"] ?>" required>
</div>
<!-- Time input for Jam Kedatangan -->
<div class="mb-3">
<label for="jam_kedatangan" class="form-label">Jam Kedatangan</label>
<input type="time" class="form-control" id="jam_kedatangan" name="jam_kedatangan" value="<?= $f["jam_kedatangan"] ?>" required>
</div>
<!-- Text input for bandara asal -->
<div class="mb-3">
<label for="tujuan_akhir" class="form-label">Bandara Asal</label>
<input type="text" class="form-control" id="bandara_asal" value=" <?= $f["bandara_asal"] ?>" name="bandara_asal" required>
</div>
<!-- Text input for Tujuan Akhir -->
<div class="mb-3">
<label for="tujuan_akhir" class="form-label">Tujuan</label>
<input type="text" class="form-control" id="tujuan_akhir" name="tujuan_akhir" value=" <?= $f["tujuan_akhir"] ?>" required>
</div>
<!-- Text input for Sektor -->
<div class="mb-3">
<label for="sektor" class="form-label">Sektor</label>
<input type="text" class="form-control" id="sektor" name="sektor" value=" <?= $f["sektor"] ?>" required>
</div>
<!-- Number input for Harga -->
<div class="mb-3">
<label for="harga" class="form-label">Harga</label>
<input type="number" class="form-control" id="harga" name="harga" value= <?= strval($f["harga"]) ?> required>
</div>
<!-- Time input for Jam Berangkat -->
<div class="mb-3">
<label for="jam_berangkat" class="form-label">Jam Berangkat</label>
<input type="time" class="form-control" id="jam_berangkat" name="jam_berangkat" value="<?= $f["jam_berangkat"] ?>"required>
</div>
<!-- Time input for Jam Tiba -->
<div class="mb-3">
<label for="jam_tiba" class="form-label">Jam Tiba</label>
<input type="time" class="form-control" id="jam_tiba" name="jam_tiba" value="<?= $f["jam_tiba"] ?>" required>
</div>
<!-- Submit button -->
<button type="submit" class="btn btn-primary">Submit</button>
</form>
</div>
</div>
<script src="./../styles/bootstrap.bundle.min.js"></script>
</body>
</html>
Login
<?php
include "./../core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$msg = '<div class="alert alert-warning p-2"><small>Masuk ke akun Admin</small></div>';
if(isset($_POST["user"]) && isset($_POST["pass"])) {
if($core->loginAdmin($_POST["user"], $_POST["pass"])){
header("Location: data_penerbangan.php");
}
else {
$msg = '<div class="alert alert-danger p-2"><small>Email atau Passsword salah</small></div>';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Indonesia AirLines</title>
<link href="./../styles/bootstrap.min.css" rel="stylesheet">
<link href="./../styles/styles.css" rel="stylesheet">
</head>
<body class="container" style="background-image: url(./../image/jet.jpg); background-repeat: no-repeat;background-size: cover;">
<center>
<form class=" p-3" action="" style="max-width: 500px;border: 2px solid #eee;border-radius: 10px;margin-top: 25vh;background: rgba(255,255,255,0.8)" method="post">
<center><h3 class="mb-0">Indonesia AirLines Admin</h3></center>
<hr>
<?= $msg; ?>
<input class="form-control" placeholder="Email" name="user">
<input class="form-control mt-3" placeholder="Password" name="pass">
<button class="btn btn-success mt-3 w-100">Login</button>
</form>
</center>
</body>
</html>
tambah_penerbangan
<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);
include "./../core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$core->isAdminLogin();
$msg = "";
$x = $core->getUser($_COOKIE["user"]);
if (isset($_POST["maskapai"])) {
if ($core->insertFlight($_POST, $_FILES["foto"]))
$msg = '<div class="alert alert-success p-2"><small>Data penerbangan telah dibuat </small></div>';
else
$msg = '<div class="alert alert-success p-2"><small>Data penerbangan gagal dibuat </small></div>';
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Reservasi</title>
<link href="./../styles/bootstrap.min.css" rel="stylesheet">
<link href="./../styles/styles.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark" style="background-color: #86B6F6;">
<div class="container-fluid ps-5">
<a class="navbar-brand" href="#">Indonesia Airlines<small><i>staff</i></small></a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav w-100 ms-auto" style="float: right;">
<li class="nav-item"">
<a class="nav-link" aria-current="page" href="data_penerbangan.php">Data</a>
</li>
<li class="nav-item" style="width: 85%;">
<a class="nav-link active" aria-current="page" href="tambah_penerbangan.php">Tambah Penerbangan</a>
</li>
<li class="nav-item dropdown" style="margin-left: 3%;">
<a class="nav-link active dropdown-toggle" href="#" id="navbarDropdown" role="button" data-bs-toggle="dropdown" aria-expanded="false">
<?= $x["nama"] ?>
</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
<li><a class="dropdown-item" href="./../logout.php">Logout</a></li>
<li><a class="dropdown-item" href="./../admin/login.php">Login to Admin</a></li>
<li><a class="dropdown-item" href="./../petugas/login.php">Login to Staff</a></li>
</ul>
</li>
</ul>
</div>
</div>
</nav>
<div class="container mt-3">
<h3 class="text-muted">Admin area > Tambah Penerbangan</h3>
<div class="container p-3" style="border: 2px solid #eee;border-radius: 10px">
<?= $msg ?>
<form method="post" action="tambah_penerbangan.php" enctype="multipart/form-data">
<div class="mb-3">
<label for="maskapai" class="form-label">Maskapai</label>
<select class="form-select" id="maskapai" name="maskapai" required>
<option value="ryan_air">Ryan Air</option>
<option value="batik_air">Batik Air</option>
<option value="easyjet">EasyJet</option>
<option value="garuda_indonesia">Garuda Indonesia</option>
<option value="lion_air">Lion Air</option>
</select>
</div>
<!-- Date input for Tanggal Penerbangan -->
<div class="mb-3">
<label for="tanggal_penerbangan" class="form-label">Tanggal Penerbangan</label>
<input type="date" class="form-control" id="tanggal_penerbangan" name="tanggal_penerbangan" required>
</div>
<!-- Number input for Kuota -->
<div class="mb-3">
<label for="kuota" class="form-label">Kuota</label>
<input type="number" class="form-control" id="kuota" name="kuota" required>
</div>
<!-- Time input for Jam Kedatangan -->
<div class="mb-3">
<label for="jam_kedatangan" class="form-label">Jam Kedatangan</label>
<input type="time" class="form-control" id="jam_kedatangan" name="jam_kedatangan" required>
</div>
<!-- Text input for bandara asal -->
<div class="mb-3">
<label for="tujuan_akhir" class="form-label">Bandara Asal</label>
<input type="text" class="form-control" id="bandara_asal" name="bandara_asal" required>
</div>
<!-- Text input for Tujuan Akhir -->
<div class="mb-3">
<label for="tujuan_akhir" class="form-label">Tujuan</label>
<input type="text" class="form-control" id="tujuan_akhir" name="tujuan_akhir" required>
</div>
<!-- Text input for Sektor -->
<div class="mb-3">
<label for="sektor" class="form-label">Sektor</label>
<input type="text" class="form-control" id="sektor" name="sektor" required>
</div>
<!-- Number input for Harga -->
<div class="mb-3">
<label for="harga" class="form-label">Harga</label>
<input type="number" class="form-control" id="harga" name="harga" required>
</div>
<!-- Time input for Jam Berangkat -->
<div class="mb-3">
<label for="jam_berangkat" class="form-label">Jam Berangkat</label>
<input type="time" class="form-control" id="jam_berangkat" name="jam_berangkat" required>
</div>
<!-- Time input for Jam Tiba -->
<div class="mb-3">
<label for="jam_tiba" class="form-label">Jam Tiba</label>
<input type="time" class="form-control" id="jam_tiba" name="jam_tiba" required>
</div>
<div class="mb-3">
<label for="jam_tiba" class="form-label">Foto</label>
<input type="file" class="form-control" id="foto" name="foto" required>
</div>
<!-- Submit button -->
<button type="submit" class="btn btn-primary">Submit</button>
</form>
</div>
</div>
<script src="./../styles/bootstrap.bundle.min.js"></script>
</body>
</html>
Lanjut ke Petugas
Login
<?php
include "./../core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$msg = '<div class="alert alert-warning p-2"><small>Masuk ke akun staff</small></div>';
if(isset($_POST["user"]) && isset($_POST["pass"])) {
if($core->loginStaff($_POST["user"], $_POST["pass"])){
header("Location: petugas.php");
}
else {
$msg = '<div class="alert alert-danger p-2"><small>Email atau Passsword salah</small></div>';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>LOGIN</title>
<link href="./../styles/bootstrap.min.css" rel="stylesheet">
<link href="./../styles/styles.css" rel="stylesheet">
</head>
<body class="container" style="background-image: url(./../image/jet.jpg); background-repeat: no-repeat;background-size: cover;">
<center>
<form class=" p-3" action="" style="max-width: 500px;border: 2px solid #eee;border-radius: 10px;margin-top: 25vh;background: rgba(255,255,255,0.8)" method="post">
<center><h3 class="mb-0">Indonesia Airlines</h3></center>
<hr>
<?= $msg; ?>
<input class="form-control" placeholder="Email" name="user">
<input class="form-control mt-3" placeholder="Password" name="pass">
<button class="btn btn-success mt-3 w-100">Login</button>
</form>
</center>
</body>
</html>
Petugas
<?php
include "./../core/libcore_backend.php";
$core = new Libcore();
$core->connect();
$core->isStaffLogin();
$x = $core->getUser($_COOKIE["user"]);
if(isset($_GET["confirm"])){
$core->confirmTicket(intval( $_GET["confirm"]));
}
$data = $core->getTicketList();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>STAFF AREA</title>
<link href="./../styles/bootstrap.min.css" rel="stylesheet">
<link href="./../styles/styles.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-expand-lg navbar-dark" style="background-color: #86B6F6;">
<div class="container-fluid ps-5">
<a class="navbar-brand" href="#">Indonesia AirLines<small><i>staff</i></small></a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav w-100 ms-auto" style="float: right;">
<li class="nav-item" style="width: 85%;">
<a class="nav-link active" aria-current="page" href="petugas.php">Konfirmasi Tiket</a>
</li>
<li class="nav-item dropdown" style="margin-left: 3%;">
<a class="nav-link active dropdown-toggle" href="#" id="navbarDropdown" role="button" data-bs-toggle="dropdown" aria-expanded="false">
<?= $x["nama"] ?>
</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
<li><a class="dropdown-item" href="./../logout.php">Logout</a></li>
<li><a class="dropdown-item" href="./../admin/login.php">Login to Admin</a></li>
<li><a class="dropdown-item" href="./../petugas/login.php">Login to Staff</a></li>
</ul>
</li>
</ul>
</div>
</div>
</nav>
<div class="container mt-4 ">
<h4 class="text-muted">Staff Area > Ticket Confirmation</h4>
<table class="table table-sm table-striped table-bordered">
<thead>
<tr>
<th>Atas nama</th>
<th>Maskapai</th>
<th>Tgl. Dipesan</th>
<th>Tujuan</th>
<th>Sektor</th>
<th>Tgl. Penerbangan</th>
<th>Jam Kedatangan</th>
<th>Jam Keberangkatan</th>
<th>Jam Tiba</th>
<th>Kode PNR</th>
<th>Harga</th>
<th>Konfirmasi</th>
</tr>
</thead>
<tbody>
<tr>
<?php
foreach ($data as $f) :
?>
<td><?= $f["nama"] ?></td>
<td><?= $f["maskapai"] ?></td>
<td><?= $f["tanggal"] ?></td>
<td><?= $f["bandara_asal"] ?> - <?= $f["tujuan_akhir"] ?> </td>
<td><?= $f["sektor"] ?></td>
<td><?= $f["tanggal_penerbangan"] ?></td>
<td><?= $f["jam_kedatangan"] ?></td>
<td><?= $f["jam_berangkat"] ?></td>
<td><?= $f["jam_tiba"] ?></td>
<td><?= $f["kode_pnr"]; ?></td>
<td><?= $f["harga"] ?></td>
<td><?= $f["konfirmasi"] == 0 ? "<a class='btn btn-sm btn-success' href='?confirm=".$f['order_id']."'>konfirmasi</a>" : "<small class='text-muted'>sudah digunakan</small>"; ?></td>
</tr>
<?php
endforeach;
?>
</tbody>
</table>
</div>
<script src="./../styles/bootstrap.bundle.min.js"></script>
</body>
</html>
Untuk menaruh foto pesawatnya di buat folder bernama public/foto
file bootstrapnya https://drive.google.com/drive/folders/1PyiKClNEZfXqx7DFBCNCUKY7GhKJBEsn?usp=sharing
Hasilnya:
User Page
Login
Pemesanan
Status Tiket
Petugas
Home
Admin
Tambah Penerbangan
Komentar
Posting Komentar