Server IP : 108.170.25.35 / Your IP : 3.139.97.161 Web Server : Apache/2 System : Linux gains.winzonesoftech.com 4.18.0-513.24.1.el8_9.x86_64 #1 SMP Mon Apr 8 11:23:13 EDT 2024 x86_64 User : brindhavan ( 1477) PHP Version : 8.1.28 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/brindhavan/domains/brindhavanresidency.com/public_html/bfrtYyuzqhPkRrwz/ |
Upload File : |
<?php include('session.php')?> <?php include('header.php')?> <link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet"> <style> img.banner { width: auto; height: 86px; } </style> <script> function show_confirm() { return confirm("Are You Sure"); } </script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <script> $(document).ready(function(){ $("input[type='radio']").change(function(){ if($(this).val()=="Single") { $("#otherAnswer1").hide(); $("#otherAnswer").show(); } else if($(this).val()=="Multiple") { $("#otherAnswer").hide(); $("#otherAnswer1").show(); } }); }); </script> <script> Filevalidation = () => { const fi = document.getElementById('otherAnswer'); // Check if any file is selected. if (fi.files.length > 0) { for (const i = 0; i <= fi.files.length - 1; i++) { const fsize = fi.files.item(i).size; const file = Math.round((fsize / 1024)); // The size of the file. if (file >= 300) { alert( "File too Big, please select a file less than 300kb"); } else if (file < 10) { alert( "File too small, please select a file greater than 10kb"); } else { document.getElementById('size').innerHTML = '<b>' + file + '</b> KB'; } } } } </script> <?php if(isset($_POST['submit'])) { $name=$_POST['name']; $price=$_POST['price']; $content=$_POST['content']; $image="img/".$_FILES['image']['name']; move_uploaded_file($_FILES['image']['tmp_name'],$image); $sql=mysqli_query($conn,"INSERT INTO rooms(name,price,content,image) VALUES('$name','$price','$content','$image')"); if($sql) { echo "<script>alert('Data submitted successfully')</script>"; } else{ echo "<script>alert('Failed to submit data')</script>"; } } ?> <body id="page-top"> <!-- Page Wrapper --> <div id="wrapper"> <!-- Sidebar --> <?php include('sidebar.php')?> <!-- End of Sidebar --> <!-- Content Wrapper --> <div id="content-wrapper" class="d-flex flex-column"> <!-- Main Content --> <div id="content"> <!-- Topbar --> <?php include('topbar.php')?> <!-- End of Topbar --> <!-- Begin Page Content --> <div class="container-fluid"> <!-- Page Heading --> <div class="d-sm-flex align-items-center justify-content-between mb-4"> <h1 class="h3 mb-0 text-gray-800">Rooms</h1> </div> <div class="card shadow mb-4"> <div class="col-lg-7"> <div class="p-5"> <div class="text-center"> </div> <form class="user" action="" method="post" enctype="multipart/form-data"> <div class="form-group row"> <div class="col-sm-12 mb-3 mb-sm-0"> <label for="exampleInputFile">Room Name</label> <input type="text" class="form-control" id="exampleFirstName" placeholder="Project name" name="name"> </div> </div> <div class="form-group row"> <div class="col-sm-12 mb-3 mb-sm-0"> <label for="exampleInputFile">Room Price</label> <input type="text" class="form-control" id="exampleFirstName" placeholder="Price" name="price"> </div> </div> <div class="form-group row"> <div class="col-sm-12 mb-3 mb-sm-0"> <label for="exampleInputFile">Content</label> <textarea class="form-control" id="exampleFirstName" placeholder="Content" name="content"></textarea> </div> </div> <div class="form-group row"> <div class="col-sm-12 mb-3 mb-sm-0 mt-3"> <label for="exampleInputFile">Room Image</label> <input class="form-control" type="file" name="image" id="otherAnswer"> </div> </div> <input type="submit" class="btn btn-primary btn-user btn-block" name="submit" value="UPLOAD" style="background-color:#016224 ; border:1px solid #016224;"> </div> </div> </div> <!-- DataTales Example --> <!-- DataTales Example --> <div class="card shadow mb-4"> <div class="card-header py-3"> <h6 class="m-0 font-weight-bold text-primary">DataTable</h6> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0"> <thead> <tr> <th>S.No</th> <th> Room Name</th> <th> Room Price</th> <th> Room Content</th> <th> Image</th> <th>Edit</th> <th>Delete</th> </tr> </thead> <tbody> <?php $x = 1; $sql=mysqli_query($conn,"SELECT * FROM rooms"); while($row=mysqli_fetch_array($sql)) { ?> <tr> <td><?php echo $x; ?></td> <td><?php echo $row['name']; ?></td> <td><?php echo $row['price']; ?></td> <td><?php echo $row['content']; ?></td> <td><img src="<?php echo $row['image']; ?>" class="banner"></td> <td> <a title="Delete" href="rooms-edit.php?id=<?php echo $row['id']; ?>"><img class="" src="img/pencil.png"></a></td> <td> <a title="Delete" href="rooms-delete.php?id=<?php echo $row['id']; ?>" class="" onclick='return show_confirm();'><img class="" src="img/del.png"></a></td> </tr> <?php $x++; } echo '<script type="text/javascript"> drawChart(); </script>'; ?> </tbody> </table> </div> </div> </div> </div> <!-- /.container-fluid --> </div> <!-- End of Main Content --> <?php include('footer.php')?>