File manager

File manager - Edit - /home/asiatechinc/public_html/asiatechinc-websites/hotelbilwapalace.com/admin/room.php

Back
<?php include 'core/init.php'; protect_page($mysqli); $qs = $_SERVER['QUERY_STRING']; $get = $_GET['id']; $actual_link = "http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]"; if($get != ''){ $sql = mysqli_query($mysqli, "SELECT * FROM room WHERE id = '$get'"); $result = mysqli_fetch_array($sql); $name0 = $result['name']; $description0 = $result['description']; $amenities0 = $result['amenities']; $amenities01 = explode(":", $amenities0); } if (empty($_POST) === false && empty($errors) === true) { if($get == ''){ $user_id = $_POST['user_id']; $name = sanitize($mysqli, $_POST['name']); $description = $_POST['description']; $amenities = $_POST['amenities']; $amenities1 = sanitize($mysqli, implode(":",$amenities)); mysqli_query($mysqli, "INSERT INTO `room`(`user_id`, `name`, `description`, `overview`, `amenities`, `status`) VALUES ('$user_id', '$name', '$description', '', '$amenities1', 1)"); $abcd = mysqli_insert_id($mysqli); mysqli_query($mysqli, "INSERT INTO `tariff` (`user_id`, `room_id`, `ep`, `cp`, `map`, `ap`) VALUES ('$user_id', '$abcd', '0', '0', '0', '0')"); header('Location: room?success'); exit(); } } else if (empty($errors) === false) { $error = output_errors($errors); } ?> <!DOCTYPE html> <html lang="en" xmlns="http://www.w3.org/1999/html"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="shortcut icon" href="../images/favicon.PNG"> <title><?php if($name0 != ''){ echo $name0.' - '; } ?>Room - <?=$user_data['name'];?></title> <link href="bs3/css/bootstrap.min.css" rel="stylesheet"> <link href="css/bootstrap-reset.css" rel="stylesheet"> <link href="css/table-responsive.css" rel="stylesheet" /> <link href="font-awesome/css/font-awesome.css" rel="stylesheet" /> <link href="css/style.css" rel="stylesheet"> <link href="css/style-responsive.css" rel="stylesheet" /> <script src="//cdn.ckeditor.com/4.4.7/standard/ckeditor.js"></script> </head> <body> <section id="container" > <?php include 'include/top.php';?> <section id="main-content" class=""> <section class="wrapper"> <div class="row"> <div class="col-lg-12"> <section class="panel"> <header class="panel-heading"> Add Room Details <span class="tools pull-right"> <a href="javascript:;" class="fa fa-chevron-down"></a> </span> </header> <div class="panel-body"> <div class="position-center"> <?php if($qs == 'success'){ echo '<div class="alert alert-success alert-block fade in"> <h4> <i class="icon-ok-sign"></i> Success! </h4> <p>Add New Room Detail <a href="room" style="color:blue">Click Here</a></p> </div>'; }else{ echo $error; ?> <form class="form-horizontal" role="form" method="post" action=<?php if($get != ''){ echo '"room_image.php" enctype="multipart/form-data"'; }else{ echo '""'; } ?> autocomplete="off"> <div class="form-group"> <label for="inputEmail1" class="col-lg-2 col-sm-2 control-label">Name </label> <div class="col-lg-10"> <input type="hidden" name="id" value="<?=$get; ?>" > <input type="hidden" name="user_id" value="<?=$user_id;?>"> <input type="text" class="form-control" name="name" placeholder="Name" <?php if($get != '') { echo 'value="'.$name0.'"'; } ?> required> </div> </div> <div class="form-group"> <label for="inputPassword1" class="col-lg-2 col-sm-2 control-label">Description</label> <div class="col-lg-10"> <textarea name="description" class="form-control"><?=$description0;?></textarea> <script> CKEDITOR.replace('description'); </script> </div> </div> <div class="form-group"> <label for="inputPassword1" class="col-lg-2 col-sm-2 control-label">Amenities </label> <div class="col-lg-10"> <div class="input_fields_wrap"> <?php if($get == ''){ echo '<div class="row"> <div class="col-lg-6"> <input type="text" name="amenities[]" class="form-control" required > </div> <div class="col-lg-6"> <button class="add_field_button btn btn-info btn-sm">Add More Fields</button> </div> </div>'; }else{ $ccnt = 1; foreach (array_chunk($amenities01, 1) as $row) { echo '<span><div class="row">'; foreach ($row as $value) { echo '<div class="col-lg-6"><input type="text" value="'.htmlentities($value).'" name="amenities[]" class="form-control" required ></div><div class="col-lg-6"><a href="#" class="remove_field btn btn-danger btn-sm"'; if($ccnt == 1){ echo 'disabled'; } echo '>Remove</a></div>'; } echo '</div></span>'; $ccnt++; } echo '<div class="col-lg-12" style="margin-top:5px;margin-bottom:5px;"> <button class="add_field_button btn btn-info btn-sm" style="width: 60%;">Add More Fields</button> </div><br/>'; } ?> </div> </div> </div> <?php if($get != '') { ?> <div class="form-group"> <label for="inputEmail1" class="col-lg-2 col-sm-2 control-label">Images (Multiple & Less Than 1 MB)</label> <div class="col-lg-10"> <input type="file" id="file" name="files[]" multiple="true"> </div> </div> <?php } ?> <div class="form-group"> <div class="col-lg-offset-2 col-lg-10"> <input type="submit" class="btn btn-primary" name="submit" id="submit" value="Submit"> </div> </div> </form> <?php echo '<br/>'; if($get != ''){ $sql1 = mysqli_query($mysqli, "SELECT * FROM `roomimage` WHERE `room_id` = '$get'"); echo '<div class="row">'; while($result1 = mysqli_fetch_array($sql1)){ $id = $result1['id']; $image = $result1['image']; $status = $result1['status']; echo '<div class="col-lg-3" id="response_'.$id.'"> <img src="'.$image.'" style="width: 100%; height: 90px;"> <span id="status_id'.$id.'"> <a href="#" id="status_id" data-id="'.$id.'" data-status="'.$status.'">'; if($status == '1'){ echo '<span class="label label-success label-mini"><i class="fa fa-check"></i> Active</span>'; }else{ echo '<span class="label label-danger label-mini"><i class="fa fa-times"></i> Inactive</span>'; } echo '</a> </span> <span> <a href="#" class="btn btn-danger del_button btn-xs" id="del-'.$id.'"><i class="fa fa-trash-o"></i> Delete</a> </span> </div>'; $count++; } echo '</div>'; } ?> <?php } ?> </div> </div> </section> <?php if($get == ''){ ?> <section class="panel"> <?php $sql1 = mysqli_query($mysqli, "SELECT * FROM `room` WHERE `user_id` = '$user_id'"); $rows1 = mysqli_num_rows($sql1); ?> <header class="panel-heading">Currently Added Rooms : <?=$rows1;?> </header> <div class="panel-body"> <section id="flip-scroll"> <?php if($rows1==0){ ?> No Entries Till Now... <?php }else{ echo '<table class="table table-bordered table-striped table-condensed cf"> <thead class="cf"> <tr> <th>SR No</th> <th>Name</th> <th>Image</th> <th>Status</th> <th>Action</th> </tr> </thead> <tbody>'; $count = 1; while($result1 = mysqli_fetch_array($sql1)){ $id = $result1['id']; $name = $result1['name']; $status = $result1['status']; echo '<tr> <td>'.$count.'</td> <td>'.$name.'</td> <td>'; $query31 = mysqli_query($mysqli, "SELECT * FROM `roomimage` WHERE `room_id` = '$id' LIMIT 2"); while($result31 = mysqli_fetch_array($query31)){ echo '<img src="'.$result31['image'].'" style="height: 50px; width: 100px;">'; } echo '</td> <td id="status_ids'.$id.'"><a href="#" id="status_ids" data-id1="'.$id.'" data-status="'.$status.'">'; if($status == '1'){ echo '<span class="label label-success label-mini"><i class="fa fa-check"></i> Active</span>'; }else{ echo '<span class="label label-danger label-mini"><i class="fa fa-times"></i> Inactive</span>'; } echo '</a></td> <td> <a target="_blank" class="btn btn-primary btn-xs" href="../room?'.$id.'"><i class="fa fa-eye"></i> View</a>    <a class="btn btn-info btn-xs" href="room?id='.$id.'"><i class="fa fa-refresh"></i> Update</a></td> </tr>'; $count++; } echo '</tbody> </table>'; } ?> </section> </div> </section> <?php } ?> </div> </div> </section> </section> <div class="right-sidebar"><div class="right-stat-bar"><ul class="right-side-accordion"><li class="widget-collapsible"><ul class="widget-container"><li><div class="prog-row side-mini-stat clearfix"><div class="side-mini-graph"><div class="target-sell"></div></div></div></li></ul></li></ul></div></div> </section> <script src="js/jquery.js"></script> <script src="bs3/js/bootstrap.min.js"></script> <script class="include" type="text/javascript" src="js/jquery.dcjqaccordion.2.7.js"></script> <script src="js/jquery.scrollTo.min.js"></script> <script src="js/jQuery-slimScroll-1.3.0/jquery.slimscroll.js"></script> <script src="js/jquery.nicescroll.js"></script> <script src="js/scripts.js"></script> <script> $(document).ready(function() { var max_fields = 50; var wrapper = $(".input_fields_wrap"); var add_button = $(".add_field_button"); var x = 1; $(add_button).click(function(e){ e.preventDefault(); if(x < max_fields){ x++; $(wrapper).append('<span><div class="row"><div class="col-lg-6"><input type="text" name="amenities[]" class="form-control" required /></div><div class="col-lg-6"><a href="#" class="remove_field btn btn-danger btn-sm">Remove</a></div></div></span>'); } }); $(wrapper).on("click",".remove_field", function(e){ e.preventDefault(); $(this).parentsUntil('span').remove(); x--; }) }); $(document).ready(function() { $("body").on("click", " #status_ids", function(e) { e.preventDefault(); var id=$(this).data("id1") var status="status="+$(this).data("status"); var updatestatus="id1="+id+"&"+status; jQuery.ajax({ type: "POST", url: "ajax/room.php", dataType:"text", data:updatestatus, success:function(response){ $("#status_ids"+id).html(response).stop(); } }); }); $("body").on("click", " #status_id", function(e) { e.preventDefault(); var id=$(this).data("id") var status="status="+$(this).data("status"); var updatestatus="id="+id+"&"+status; jQuery.ajax({ type: "POST", url: "ajax/room.php", dataType:"text", data:updatestatus, success:function(response){ $("#status_id"+id).html(response).stop(); } }); }); $("body").on("click", " .del_button", function(e) { e.preventDefault(); var clickedID = this.id.split('-'); var DbNumberID = clickedID[1]; var myData = 'Delete='+ DbNumberID; var con = confirm('Are you sure to delete this event permanently?'); if(con == true) { $(this).hide(); jQuery.ajax({ type: "POST", url: "ajax/room.php", dataType:"text", data:myData, success:function(response){ $('#response_'+DbNumberID).fadeOut(); }, error:function (xhr, ajaxOptions, thrownError){ alert(thrownError); } }); return false; } }); }); </script> </body> </html>

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0.02 | proxy | phpinfo | Settings