PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/aqjktxqw/topcelebconnect.com/book.php

<?php
require "include/header.php";
session_start();

if (isset($_GET["id"])) {
    $id = $_GET["id"];
    $sql = "SELECT * FROM celeb WHERE id = $id";
    $query = mysqli_query($connection, $sql);
    $celeb = mysqli_fetch_assoc($query);
}

// Process booking form
if (isset($_POST["book"])) {
    $name = mysqli_real_escape_string($connection, $_POST["name"]);
    $email = mysqli_real_escape_string($connection, $_POST["email"]);
    $phone = mysqli_real_escape_string($connection, $_POST["phone"]);
    $street = mysqli_real_escape_string($connection, $_POST["street"]);
    $city = mysqli_real_escape_string($connection, $_POST["city"]);
    $state = mysqli_real_escape_string($connection, $_POST["state"]);
    $country = mysqli_real_escape_string($connection, $_POST["country"]);
    $celeb_id = $_POST["celeb"];
    $book_type = $_POST["book_type"];
    $date = $_POST["date"];
    $time = $_POST["time"];
    $note = mysqli_real_escape_string($connection, $_POST["note"]);

    // Get celeb fee
    $sql_celeb = "SELECT * FROM celeb WHERE id = $celeb_id";
    $result_celeb = mysqli_query($connection, $sql_celeb);
    $celeb_data = mysqli_fetch_assoc($result_celeb);
    $appearance_fee = $celeb_data["appearance_fee"];

    // Get booking type fee
    $sql_type = "SELECT * FROM type WHERE id = $book_type";
    $result_type = mysqli_query($connection, $sql_type);
    $type_data = mysqli_fetch_assoc($result_type);
    $type_fee = $type_data["price"];

    // Calculate total
    $total_fee = $appearance_fee + $type_fee;

    // Create booking reference
    $booking_ref = strtoupper(substr(md5(time()), 0, 10));

    // Insert into booking table
    $sql_insert = "INSERT INTO booking (booking_ref, name, email, phone, street, city, state, country, celeb_id, book_type, date, time, note, total_amount)
                   VALUES ('$booking_ref', '$name', '$email', '$phone', '$street', '$city', '$state', '$country', '$celeb_id', '$book_type', '$date', '$time', '$note', '$total_fee')";
    
    if (mysqli_query($connection, $sql_insert)) {
        $_SESSION["booking"] = $booking_ref;
        header("Location: pay.php");
        exit();
    } else {
        $error = "Failed to create booking. Please try again.";
    }
}
?>

<main id="main">

    <!-- ======= Breadcrumbs ======= -->
    <div class="breadcrumbs d-flex align-items-center" style="background-image: url('assets/img/blog-header.jpg');">
        <div class="container position-relative d-flex flex-column align-items-center">

            <h2>Book Celebrity </h2>
            <ol>
                <li><a href="index.php">Home</a></li>
                <li><a href="">celebrity details</a></li>
                <li>book Celebrity </li>
            </ol>

        </div>
    </div><!-- End Breadcrumbs -->
    <style>
    input,
    select {

        margin-top: 3px;
        margin-bottom: 14px;
        height: 50px;

    }

    label {
        font-size: 18px;
    }
    </style>
    <!-- alert start -->
    
    <?php 

if(isset($success)){
    ?>
            <div class="alert alert-success" role="alert">
                <?php echo $success;?>
            </div>
            <?php
}else{
    if(isset($error)){
        ?>
            <div class="alert alert-danger" role="alert">
                <?php echo $error;?>
            </div>
            <?php
    }
}
?>
    <!-- ======= Blog Details Section ======= -->
    <div class="container">
        <section class="form">

            <form action="" id="bookingForm" method="POST">
                <label for="">FullName</label>
                <input type="text" placeholder="Enter your name" name="name" required style="border-radius:0:"
                    class="form-control">
                <div class="row">
                    <div class="col-md">
                        <label for="">Email</label>
                        <input type="text" required placeholder="Enter your email" name="email" class="form-control">
                    </div>
                    <div class="col-md">
                        <label for="">Phone Number</label>
                        <input type="text" required name="phone" placeholder="Enter your Contact Number"
                            class="form-control">
                    </div>
                </div>
                <div class="row">
                    <div class="col-md">
                        <label for="">Street Name</label>
                        <input type="text" required name="street" class="form-control">
                    </div>
                    <div class="col-md">
                        <label for="">City</label>
                        <input type="text" required name="city" class="form-control">
                    </div>
                </div>
                <div class="row">
                    <div class="col-md">
                        <label for="">State/Province</label>
                        <input type="text" required name="state" class="form-control">
                    </div>
                    <div class="col-md">
                        <label for="">Country</label>
                        <select name="country" class="form-control" id="">
                            <option value="">Select Your Country</option>
                            <?php
$sql_country= "SELECT * FROM countries";
$quary_country= mysqli_query($connection,$sql_country);
while($country= mysqli_fetch_assoc($quary_country))
{
?>
                            <option value="<?php echo $country["name"];?>"><?php echo $country["name"];?></option>
                            <?php
}
?>
                        </select>
                    </div>

                </div>
                <div class="row">
                    <div class="col-md">
                        <label for="">Choose Your Celebrity</label>
                        <select type="text" required name="celeb" class="form-control">
                            <?php

    $sql= "SELECT * FROM celeb WHERE id= $id";
    $quary= mysqli_query($connection,$sql);
    if($celeb= mysqli_fetch_assoc($quary)){
        $celeb_name =$celeb["name"];
        $celeb_id =$celeb["id"];
    }else{
        $celeb_name ="";
        $celeb_id ="";  
    }
  
                    ?>
                            <option value="<?php echo $celeb_id; ?>"><?php echo $celeb_name; ?></option>
                            <option value=""></option>
                            <?php
$sql_c= "SELECT * FROM celeb";
$quary_c= mysqli_query($connection,$sql_c);
while($celeb_c= mysqli_fetch_assoc($quary_c))
{
?>
                            <option value="<?php echo $celeb_c["id"];?>"><?php echo $celeb_c["name"];?></option>
                            <?php
}
?>
                        </select>
                    </div>
                    <div class="col-md">
                        <label for="">Booking Type</label>
                        <select type="text" required name="book_type" class="form-control">
                            <option value="">Select Booking Type</option>
                            <?php
$sql_type= "SELECT * FROM type";
$quary_type= mysqli_query($connection,$sql_type);
while($type= mysqli_fetch_assoc($quary_type))
{
?>
                            <option value="<?php echo $type["id"];?>"><?php echo $type["name"];?> -
                                $<?php echo $type["price"];?> </option>
                            <?php
}
?>
                        </select>

                    </div>
                </div>


                <div class="row">
                    <div class="col-md">
                        <label for="">Date to Meet</label>
                        <input type="date" required name="date" class="form-control">
                    </div>
                    <div class="col-md">
                        <label for="">Time to Meet</label>
                        <input type="time" required name="time" class="form-control">
                    </div>

                </div>
                <label for="">Note</label>
                <textarea name="note" class="form-control" id="" cols="30" rows="10"></textarea>
                <br>
                <button class="btn btn-success btn-lg" name="book" id="submitBtn" style="border-radius:0;">Submit Booking</button>
                <div class="processing-container">


                </div>
            </form>

           
        </section>
    </div>
    
</main><!-- End #main -->

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<!-- ======= Footer ======= -->
<?php
require "include/footer.php";
?>
Back to Directory=ceiIENDB`