mamayokero

Untitled

Jul 15th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.63 KB | None | 0 0
  1. <?php
  2. include 'konek.php';
  3. ?>
  4. <!DOCTYPE html>
  5. <html lang="en">
  6. <head>
  7. <title></title>
  8. <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
  9. <link rel="stylesheet" href="css/bootstrap.min.css">
  10. <script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
  11. </head>
  12. <body>
  13. <script src="js/jquery-3.3.1.min.js"></script>
  14. <script src="js/bootstrap.min.js"></script>
  15.  
  16. <nav class="navbar navbar-inverse">
  17. <div class="container-fluid">
  18. <div class="navbar-header">
  19. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#myNavbar">
  20. <span class="icon-bar"></span>
  21. <span class="icon-bar"></span>
  22. <span class="icon-bar"></span>
  23. </button>
  24. <a class="navbar-brand" href="#">WebSiteName</a>
  25. </div>
  26. <div class="collapse navbar-collapse" id="myNavbar">
  27. <ul class="nav navbar-nav navbar-right">
  28. <li class="active"><a href="#">Home</a></li>
  29. <li class="dropdown">
  30. <a class="dropdown-toggle" data-toggle="dropdown" href="#">pilih<span class="caret"></span></a>
  31. <ul class="dropdown-menu">
  32. <li><a href="#">menu 1 ke 1</a></li>
  33. <li><a href="#">menu 1 ke 2</a></li>
  34. <li><a href="#">menu 1 ke 3</a></li>
  35. </ul>
  36. </li>
  37. <li><a href="#">Help</a></li>
  38. <li><a href="#">About</a></li>
  39. </ul>
  40. </div>
  41. </div>
  42. </nav>
  43.  
  44. <div class="jumbotron container">
  45. <h1>Input Data</h1>
  46. </div>
  47.  
  48. <div class="container">
  49. <div class="row">
  50. <div class="col-md-6">
  51. <form method="POST" action="actdata.php">
  52. <div class="form-group">
  53. <label for="id">ID : </label>
  54. <input type="text" class="form-control" id="id" name="id">
  55. </div>
  56. <div class="form-group">
  57. <label for="usr">User : </label>
  58. <input type="text" class="form-control" id="usr" name="user">
  59. </div>
  60. <div class="form-group">
  61. <label for="pwd">Password:</label>
  62. <input type="password" class="form-control" id="pwd" name="pass">
  63. </div>
  64. <input type="submit" name="sub" value="simpan" id="button" class="btn btn-success">
  65. </form>
  66. </div>
  67. <div class="col-md-6">
  68. <form action="" method="POST">
  69. <select name="choose">
  70. <option>pilih - </option>
  71. <option value="id">id</option>
  72. <option value="user">user</option>
  73. <option value="password">password</option>
  74. </select>
  75. <label for="scr"> cari :</label>
  76. <input type="text" class="form-control" id="src" name="src">
  77. </form>
  78. <table class="table table-bordered">
  79. <thead>
  80. <tr>
  81. <th>ID</th>
  82. <th>User</th>
  83. <th>Password</th>
  84. <th>option</th>
  85. </tr>
  86. </thead>
  87. <tbody>
  88. <?php
  89. if (isset($_POST['src'])) {
  90. $cari = $_POST['src'];
  91. $op_id = $_POST['choose'];
  92. $sql = "SELECT * FROM user WHERE id LIKE '%".$cari."%'";
  93. $run = mysqli_query($connect,$sql);
  94.  
  95. }elseif (isset($_POST['src'])) {
  96. $cari = $_POST['src'];
  97. $op_user = $_POST['choose'];
  98. $sql = "SELECT * FROM user WHERE user LIKE '%".$cari."%'";
  99. $run = mysqli_query($connect,$sql);
  100.  
  101. }elseif (isset($_POST['src'])) {
  102. $cari = $_POST['src'];
  103. $op_pass = $_POST['choose'];
  104. $sql = "SELECT * FROM user WHERE password LIKE '%".$cari."%'";
  105. $run = mysqli_query($connect,$sql);
  106. }else{
  107. $query = "SELECT * FROM user";
  108. $run = mysqli_query($connect,$query);
  109. }
  110.  
  111. while($row = mysqli_fetch_array($run)){
  112. ?>
  113. <tr>
  114. <th><?php echo $row[0]; ?></th>
  115. <th><?php echo $row[1]; ?></th>
  116. <th><?php echo $row[2]; ?></th>
  117. <th><a href="edit.php?id=<?=$row[0]?>" class="btn btn-primary">edit</a>
  118. <a href="hapus.php?id=<?=$row[0]?>" class="btn btn-primary">hapus</a></th>
  119. </tr>
  120. <?php }?>
  121. </tbody>
  122. </table>
  123. </div>
  124. </div>
  125. </div>
  126.  
  127. </body>
  128. </html>
Add Comment
Please, Sign In to add comment