Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/deguzmandentalclinic.com/public_html/main

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: appointment2.php

<?php
session_start();
include("../controller/config.php");

$get_data = $_GET['id'];

$get_record = mysqli_query($conn, "select * from services, service_category where services.sc_id = service_category.sc_id and service_id ='$get_data'");
$row2 = mysqli_fetch_assoc($get_record);
$data_service = $row2['service_name'];
$data_id = $row2['service_id'];
$db_sc_id = $row2['sc_id'];
$db_category1 = $row2['category'];

if (isset($_SESSION['customer_login'])) {
    $customer_id = $_SESSION['customer_login'];

$get_record = mysqli_query($conn, "select * from customer where customer_id ='$customer_id'");
    $row = mysqli_fetch_assoc($get_record);
    $customer_name = $row['name'];
    $customer_id = $row['customer_id'];
}

$db_category = "";

$sum1 = 0;

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

$services = $_POST['services'];
    $time = $_POST['time'];
    $date = $_POST['date'];
    $branch = $_POST['branch'];

$sql = "INSERT INTO `appointment`(`customer_id`, `service_id`, `branch_id`, `date`, `time`, `status`) 
    VALUES ('$customer_id','$services','$branch]','$date','$time','Pending')";
    $result = mysqli_query($conn, $sql);

header('location: appointment.php');
}

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
    <meta name="description" content="" />
    <meta name="author" content="" />
    <title>VAIN AESTHETIC</title>
    
    <link rel="icon" type="image/x-icon" href="../img/logo.png" />
    
    <script src="https://use.fontawesome.com/releases/v6.3.0/js/all.js" crossorigin="anonymous"></script>
    
    <link href="https://fonts.googleapis.com/css?family=Montserrat:400,700" rel="stylesheet" type="text/css" />
    <link href="https://fonts.googleapis.com/css?family=Roboto+Slab:400,100,300,700" rel="stylesheet" type="text/css" />
    
    <link href="css/styles.css" rel="stylesheet" />

</head>

<body id="page-top">
    
    <nav class="navbar navbar-expand-lg navbar-dark bg-dark" id="mainNav">
        <div class="container">
            <a class="navbar-brand text-white" href="#page-top"><img src="../img/logo_black.png" alt="" /> VAIN AESTHETIC & SPA</a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
                Menu
                <i class="fas fa-bars ms-1"></i>
            </button>
            <div class="collapse navbar-collapse" id="navbarResponsive">
                <ul class="navbar-nav text-uppercase ms-auto py-4 py-lg-0">

<<li class="nav-item"><a class="nav-link" href="../index.php">Home</a></li>
                        <li class="nav-item"><a class="nav-link" href="services.php">Services</a></li>

<?php if (isset($_SESSION['customer_login'])) { ?>
                            <li class="nav-item"><a class="nav-link fw-bold active" href="appointment.php">Appointment</a></li>
                        <?php } else { ?>
                            <li class="nav-item"><a class="nav-link" href="login.php">Appointment</a></li>
                        <?php } ?>
                        <li class="nav-item"><a class="nav-link" href="about_us.php">Contact Us</a></li>
                </ul>
                <?php
                if (isset($_SESSION['customer_login'])) { ?>
                    <span class="nav-item text-white mx-4"> <small>Welcome, </small> <?php echo $customer_name ?></span>

<a href="../controller/customerLogout.php"><button class="btn btn-danger btn-sm mx-3 ml-2" type="button">Logout</button></a>
                <?php } else { ?>

<?php } ?>

</div>

</nav>

<div class="container">
        <div class="row bg-light float-start mt-3">
            <div class="col">
                <a href="appointment.php"><button class="btn btn-primary"> Pending Appointment</button></a>
                <a href="approved.php"><button class="btn btn-secondary"> Completed Appointment</button></a>
                <a href="declined.php"><button class="btn btn-secondary"> Declined Appointment</button></a>
            </div>
        </div>
    </div>

<section class="page-section bg-light" id="team" style="height: 100vh;">
        <div class="container mx-auto">
            <div class="row gl-3">

<div class="col-lg-4">
                    <div class="card">
                        <div class="card-header fw-bold bg-dark text-white text-center py-3" style="font-family: Arial, Helvetica, sans-serif;">
                            APPOINTMENT
                        </div>
                        <div class="card-body">

<label for="" class="mt-2"><strong>Service Category:</strong></label>
                                <select class="form-select" onchange="select()" name="category" id="select1" required disabled>
                                    <option selected value="<?php echo $db_sc_id ?>"><?php echo $db_category1 ?></option>
                                    <?php
                                    $sql = "select * from service_category";
                                    $res = $conn->query($sql);
                                    while ($row = $res->fetch_assoc()) {

?>
                                        <option value="<?php echo $row['sc_id']; ?>"><?php echo $row['category']; ?></option>

<?php }
                                    ?>
                                </select>

<div class="col">
                                    <label for="" class="mt-2"><strong>Services:</strong></label>
                                    <select class="form-select" name="services" id="services" required disabled>

<option selected value="<?php echo $data_id ?>"><?php echo $data_service ?></option>
                                        <?php
                                        $sql = "select * from services";
                                        $res = $conn->query($sql);
                                        while ($row = $res->fetch_assoc()) {

?>
                                            <option value="<?php echo $row['service_id']; ?>" data-sid="<?php echo $row['service_id']; ?>" data-price="<?php echo $row['price']; ?>"><?php echo $row['service_name']; ?></option>

<?php }
                                        ?>
                                    </select>

</div>
                                <div class="row">
                                    <div class="col">
                                        <label for="" class="mt-2"><strong>Date:</strong></label>
                                        <input type="date" name="date" class="form-control" required>
                                    </div>
                                    <div class="col">
                                        <label for="" class="mt-2"><strong>Time:</strong></label>
                                        <select class="form-select" name="time" id="item" required>
                                            <option value=""> </option>
                                            <option value="8:00 AM">8:00 AM </option>
                                            <option value="9:00 AM">9:00 AM </option>
                                            <option value="10:00 AM">10:00 AM </option>
                                            <option value="11:00 AM">11:00 AM </option>
                                            <option value="1:00 AM">1:00 PM </option>
                                            <option value="2:00 AM">2:00 PM </option>
                                            <option value="3:00 AM">3:00 PM </option>
                                            <option value="4:00 AM">4:00 PM </option>
                                        </select>
                                    </div>
                                </div>
                                <div class="col">
                                    <label for="" class="mt-2"><strong>Branch:</strong></label>
                                    <select class="form-select" name="branch" required onclick="">
                                        <option value=""> </option>
                                        <?php
                                        $sql = "select * from branch ";
                                        $res = $conn->query($sql);
                                        while ($row = $res->fetch_assoc()) {

?>
                                            <option value="<?php echo $row['branch_id']; ?>" data-price="<?php echo $row['branch_id']; ?>"><?php echo $row['branch']; ?></option>

<?php }
                                        ?>
                                    </select>
                                </div>

<button type="submit" name="submit" class="btn btn-block py-2 text-white" style="background-color: green;">Submit</button>
                                </div>

</form>
                        </div>

</div>
                </div>
            </div>
            <div class="col-lg-8">

<div class="card">
                    <div class="card-header fw-bold bg-dark text-white text-center py-3" style="font-family: Arial, Helvetica, sans-serif;">
                        SERVICES
                    </div>
                    <div class="card-body">
                        <table class="table table-striped table-hover table-bordered">
                            <thead class="text-white bg-dark">
                                <tr>
                                    <th>Date</th>
                                    <th>Time</th>
                                    <th>Services</th>
                                    <th>Branch</th>
                                    <th class="col-2 text-center">Price</th>
                                    <th>Status</th>
                                </tr>
                            </thead>

<tbody>
                                <?php
                                $sql = "select * from appointment, services, branch where appointment.branch_id = branch.branch_id and appointment.service_id = services.service_id and customer_id ='$customer_id' and appointment.status ='Pending'";
                                $res = $conn->query($sql);
                                while ($row = $res->fetch_assoc()) {
                                    $sum1 += $row['price'];
                                    $_SESSION['sum'] = $sum1;
                                ?>
                                    <tr>
                                        <td><?php echo $row['date'] ?></td>
                                        <td><?php echo $row['time'] ?></td>
                                        <td><?php echo $row['service_name'] ?></td>
                                        <td><?php echo $row['branch'] ?></td>
                                        <td><?php echo $row['price'] ?></td>
                                        <td>
                                            <span class="right badge bg-warning">
                                                <?php echo $row['status'] ?>
                                            </span>
                                        </td>

</tr>
                                <?php } ?>
                            </tbody>
                        </table>
                    </div>
                    <div class="card-footer">

<strong class="float-end " style="margin-right: 100px;">Total: <?php echo $_SESSION['sum']; ?> </strong>
                    </div>
                </div>
            </div>
        </div>
    </section>

<footer class="footer py-4 bg-dark">
        <div class="container text-white">
            <div class="row align-items-center">
                <div class="col-lg-4 text-lg-start">De Guzman Dental Clinic &copy; All rights Reserved 2023.</div>
                <div class="col-lg-4 my-3 my-lg-0">
                    
                </div>
                <div class="col-lg-4 text-lg-end">
                    <a class="link-dark text-decoration-none me-3" href="#!">Privacy Policy</a>
                    <a class="link-dark text-decoration-none" href="#!">Terms of Use</a>
                </div>
            </div>
        </div>
    </footer>

<script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"></script>
    
    <script src="js/scripts.js"></script>
    <script src="https://cdn.startbootstrap.com/sb-forms-latest.js"></script>

$("#cat_id").val(v1);
        }
    </script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: appointment2.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation