File manager - Edit - /home/asiatechinc/public_html/asiatechinc-websites/dhyeyaprakashan.com/admin/testing.php
Back
<?php $conn = mysqli_connect("localhost","asiatechinc_dhyeyaprakashan", "dhyeyaprakashan@321","asiatechinc_dhyeyaprakashan"); ?> <!DOCTYPE html> <html lang="en"> <head> <link rel="manifest" href="manifest.json" /> <link rel="icon" href="assets/images/favicon/2.png" type="image/x-icon" /> <link rel="apple-touch-icon" href="assets/images/favicon/2.png" /> <meta name="theme-color" content="#e22454" /> <meta name="apple-mobile-web-app-capable" content="yes" /> <meta name="apple-mobile-web-app-status-bar-style" content="black" /> <meta name="apple-mobile-web-app-title" content="Voxo" /> <meta name="msapplication-TileImage" content="assets/images/favicon/2.png" /> <meta name="msapplication-TileColor" content="#FFFFFF" /> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <link rel="preconnect" href="https://fonts.googleapis.com/" /> <link rel="preconnect" href="https://fonts.gstatic.com/" crossorigin /> <link rel="preconnect" href="https://fonts.googleapis.com/" /> <link rel="preconnect" href="https://fonts.gstatic.com/" crossorigin /> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="description" content="Voxo"> <meta name="keywords" content="Voxo"> <meta name="author" content="Voxo"> <link rel="icon" href="assets/images/favicon/2.png" type="image/x-icon" /> <title>Admin Page</title> <!-- Google font --> <link rel="preconnect" href="https://fonts.gstatic.com/"> <link href="https://fonts.googleapis.com/css2?family=Rubik:wght@400;500;600;700&display=swap" rel="stylesheet"> <!-- bootstrap css --> <link id="rtl-link" rel="stylesheet" type="text/css" href="assets/css/vendors/bootstrap.css"> <!-- font-awesome css --> <link rel="stylesheet" type="text/css" href="assets/css/vendors/font-awesome.css"> <!-- feather icon css --> <link rel="stylesheet" type="text/css" href="assets/css/vendors/feather-icon.css"> <!-- animation css --> <link rel="stylesheet" type="text/css" href="assets/css/vendors/animate.css"> <!-- slick css --> <link rel="stylesheet" type="text/css" href="assets/css/vendors/slick/slick.css"> <link rel="stylesheet" type="text/css" href="assets/css/vendors/slick/slick-theme.css"> <!-- Theme css --> <link id="color-link" rel="stylesheet" type="text/css" href="assets/css/demo2.css"> <style> ul{ margin:15px; } .pagination{ font-size:14px; justify-content: center; display: flex; } </style> </head> <body class="theme-color2 light ltr"> <!-- Cart Section Start --> <div class="container"> <div class="row"> <div class="col-md-12"> <section class="panel"> <header class="panel-heading"><b>USER FORM</b></header><br> <div class="panel-body"> <div class="row"> <div class="col-md-12 form-group"> <div id="errorinput_up" style="width:720px"></div> </div> <form autocomplete="off"> <div class="row"> <div class="col-md-4 form-group">Name <br> <input class="form-control" type="text" name="name" id="name" placeholder="Name" /> </div><br> <div class="col-md-4 form-group">EmailID <br> <input class="form-control" type="text" name="email" id="email" placeholder="EmailID" /> </div> </div><br> <div class="row"> <div class="col-md-4 form-group"> Mobile No<br> <input class="form-control" type="text" name="mobile" id="mobile" placeholder="Mobile" /> </div><br> <div class="col-md-4 form-group"> City<br> <input class="form-control" type="text" name="City" id="City" placeholder="Designation"> </div> </div><br> <div class="row"> <div class="col-md-6 form-group"> Address<br> <input class="form-control" type="text" name="address" id="address" placeholder="UserName" /> </div> </div><br> <div class="col-lg-12"> <button type="button" id="add_new_user_login" class="btn btn-warning">Add User</button> </div> </form> </div> </div> </section> </div> </div> <div class="row"> <div class="col-md-12"> <section class="panel"> <header class="panel-heading"><b>Search Criteria</b></header><br> <div class="panel-body"> <div id="errorinput_up" style="display: none;"> <div class="alert alert-warning fade in"><strong><i class="fa fa-frown-o"></i></strong></div> </div> <div class="form"> <form method="post" action="posorders-export" id="form2_cntent" autocomplete="off"> <div class="row"> <div class="col-md-12"> <div class="row"> <div class="col-md-4 form-group"> <input class="form-control" type="text" name="username" id="username" placeholder="Username"> </div> <div class="col-md-4 form-group"> <input class="form-control" type="text" name="email" id="emailss" placeholder="Email"> </div> <div class="col-md-4 form-group"> <input class="form-control" type="text" name="mobile" id="mobileee" placeholder="mobile no"> </div> </div> </div> </div> </form> </div> </div> </section> </div> </div> <div class="row"> <div class="col-md-12"> <section class="panel"> <header class="panel-heading"><b>User List</b></header> <div class="panel-body"> <section id="unseen"> <?php $selectuser = mysqli_query($conn,"SELECT * FROM `user`"); if(mysqli_num_rows($selectuser)>0){ ?> <table class="table table-bordered table-striped table-condensed" id="tbl"> <thead> <tr> <th>#</th> <th>Name</th> <th>Email</th> <th>Mobile No</th> <th>City</th> <th>Address</th> <th colspan = "2">Action</th> </tr> </thead> <tbody> <?php $count = 1; while($selectuserresult = mysqli_fetch_assoc($selectuser)){ echo '<tr class= "delete_id" id="respond_'.$selectuserresult['id'].'"> <td>'.$count.'</td> <td>'.$selectuserresult['name'].'</td> <td>'.$selectuserresult['email'].'</td> <td>'.$selectuserresult['mobile'].'</td> <td>'.$selectuserresult['city'].'</td> <td>'.$selectuserresult['address'].'</td> <td><button type="button" class="btn btn-success" data-id = "'.$selectuserresult['id'].'" data-bs-toggle="modal" data-bs-target="#exampleModal" id="update">Edit</button></td><td><button type="button" class="btn btn-danger" id="delete">Delete</button></td> </tr> '; $count++; } ?> </tbody> </table> <?php }else{ echo'<div class="alert alert-warning" role="alert">No User Is Added</div>'; } ?> </section> </div> </section> </div> </div> </div> <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <div class="modal-content" id="modaldata"> </div> </div> </div> <!-- Cart Section End--> <!-- tap to top Section Start --> <div class="tap-to-top"> <a href="#home"> <i class="fas fa-chevron-up"></i> </a> </div> <!-- tap to top Section End --> <div class="bg-overlay"></div> <!-- latest jquery--> <script src="assets/js/jquery-3.5.1.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <!-- Add To Home js --> <script src="assets/js/pwa.js"></script> <!-- Bootstrap js --> <script src="assets/js/bootstrap/bootstrap.bundle.min.js"></script> <!-- feather icon js --> <script src="assets/js/feather/feather.min.js"></script> <!-- lazyload js --> <script src="assets/js/lazysizes.min.js"></script> <!-- Slick js --> <script src="assets/js/slick/slick.js"></script> <script src="assets/js/slick/slick-animation.min.js"></script> <script src="assets/js/slick/custom_slick.js"></script> <!-- timer js --> <script src="assets/js/count-down-timer.js"></script> <!-- Notify js --> <script src="assets/js/bootstrap/bootstrap-notify.min.js"></script> <!-- script js --> <script src="assets/js/theme-setting.js"></script> <script src="assets/js/script.js"> </script> <script> $('#username').keyup(function(){ call_ajax(); }); $('#emailss').keyup(function(){ call_ajax(); }); $('#mobileee').keyup(function(){ call_ajax(); }); function call_ajax(){ var username = $('#username').val(); var email = $('#emailss').val(); var mobile = $('#mobileee').val(); var sendata = "allsearch=allsearch&username="+username+"&email="+email+"&mobile="+mobile; $.ajax({ type:"post", url:"testing_update.php", datatype:"text", data:sendata, success:function(data){ $('#unseen').html(data); }, }); } </script> <script> $(document).ready(function(){ $('#add_new_user_login').click(function(){ var name = $('#name').val(); var email = $('#email').val(); var mobile = $('#mobile').val(); var MobileLength = mobile.length; var City = $('#City').val(); var address = $('#address').val(); if(name == ''){ $('#errorinput_up').html('<div class="alert alert-danger" role="alert">Name is Empty</div>').delay(3000).show().fadeOut("slow"); return false; } if(email == ''){ $('#errorinput_up').html('<div class="alert alert-danger" role="alert">Email Is Empty</div>').delay(3000).show().fadeOut("slow"); return false; } if(mobile == ''){ $('#errorinput_up').html('<div class="alert alert-danger" role="alert">Mobile Cannot Be Blank</div>').delay(3000).show().fadeOut("slow"); return false; } if (MobileLength < 10) { $("#errorinput_up").html('<div class="alert alert-warning fade in"><strong><i class="fa fa-frown-o"></i></strong>Wrong Mobile Number</div>').delay(3000).show().fadeOut("slow"); return false; } if(City == ''){ $('#errorinput_up').html('<div class="alert alert-danger" role="alert">City Cannot Be Blank</div>').delay(3000).show().fadeOut("slow"); return false; } if(address == ''){ $('#errorinput_up').html('<div class="alert alert-danger" role="alert">address Cannot Be Blank</div>').delay(3000).show().fadeOut("slow"); return false; } var sendata = "name="+name+"&email="+email+"&mobile="+mobile+"&City="+City+"&address="+address; $.ajax({ type:"post", url:"ajax/testing.php", datatype:"text", data:sendata, success:function(response){ $('#unseen').html(response); window.location.href= "testing.php"; } }); }); }); </script> <script> $('#delete').click(function(){ var trid = $(this).closest('tr').attr('id'); console.log(trid); var sendata = "delete_user= delete_user&deleteid="+trid; $.ajax({ type:"post", url:"ajax/testing.php", datatype:"text", data:sendata, success: function(data) { if (data == 'success') { // $(this).closest('tr').remove(); $('.delete_id').css('display', 'none').html(data); } console.log(data); }, }); }); </script> <script> $('#update').click(function(){ var id = $(this).data("id"); var sendata = "modal=modal&id="+id; $.ajax({ type:"post", url:"ajax/testing.php", datatype:"text", data:sendata, success:function(response){ $('#modaldata').html(response); } }); }); </script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings