Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include 'konek.php';
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <title></title>
- <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
- <link rel="stylesheet" href="css/bootstrap.min.css">
- <script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
- </head>
- <body>
- <script src="js/jquery-3.3.1.min.js"></script>
- <script src="js/bootstrap.min.js"></script>
- <nav class="navbar navbar-inverse">
- <div class="container-fluid">
- <div class="navbar-header">
- <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#myNavbar">
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="navbar-brand" href="#">WebSiteName</a>
- </div>
- <div class="collapse navbar-collapse" id="myNavbar">
- <ul class="nav navbar-nav navbar-right">
- <li class="active"><a href="#">Home</a></li>
- <li class="dropdown">
- <a class="dropdown-toggle" data-toggle="dropdown" href="#">pilih<span class="caret"></span></a>
- <ul class="dropdown-menu">
- <li><a href="#">menu 1 ke 1</a></li>
- <li><a href="#">menu 1 ke 2</a></li>
- <li><a href="#">menu 1 ke 3</a></li>
- </ul>
- </li>
- <li><a href="#">Help</a></li>
- <li><a href="#">About</a></li>
- </ul>
- </div>
- </div>
- </nav>
- <div class="jumbotron container">
- <h1>Input Data</h1>
- </div>
- <div class="container">
- <div class="row">
- <div class="col-md-6">
- <form method="POST" action="actdata.php">
- <div class="form-group">
- <label for="id">ID : </label>
- <input type="text" class="form-control" id="id" name="id">
- </div>
- <div class="form-group">
- <label for="usr">User : </label>
- <input type="text" class="form-control" id="usr" name="user">
- </div>
- <div class="form-group">
- <label for="pwd">Password:</label>
- <input type="password" class="form-control" id="pwd" name="pass">
- </div>
- <input type="submit" name="sub" value="simpan" id="button" class="btn btn-success">
- </form>
- </div>
- <div class="col-md-6">
- <form action="" method="POST">
- <select name="choose">
- <option>pilih - </option>
- <option value="id">id</option>
- <option value="user">user</option>
- <option value="password">password</option>
- </select>
- <label for="scr"> cari :</label>
- <input type="text" class="form-control" id="src" name="src">
- </form>
- <table class="table table-bordered">
- <thead>
- <tr>
- <th>ID</th>
- <th>User</th>
- <th>Password</th>
- <th>option</th>
- </tr>
- </thead>
- <tbody>
- <?php
- if (isset($_POST['src'])) {
- $cari = $_POST['src'];
- $op_id = $_POST['choose'];
- $sql = "SELECT * FROM user WHERE id LIKE '%".$cari."%'";
- $run = mysqli_query($connect,$sql);
- }elseif (isset($_POST['src'])) {
- $cari = $_POST['src'];
- $op_user = $_POST['choose'];
- $sql = "SELECT * FROM user WHERE user LIKE '%".$cari."%'";
- $run = mysqli_query($connect,$sql);
- }elseif (isset($_POST['src'])) {
- $cari = $_POST['src'];
- $op_pass = $_POST['choose'];
- $sql = "SELECT * FROM user WHERE password LIKE '%".$cari."%'";
- $run = mysqli_query($connect,$sql);
- }else{
- $query = "SELECT * FROM user";
- $run = mysqli_query($connect,$query);
- }
- while($row = mysqli_fetch_array($run)){
- ?>
- <tr>
- <th><?php echo $row[0]; ?></th>
- <th><?php echo $row[1]; ?></th>
- <th><?php echo $row[2]; ?></th>
- <th><a href="edit.php?id=<?=$row[0]?>" class="btn btn-primary">edit</a>
- <a href="hapus.php?id=<?=$row[0]?>" class="btn btn-primary">hapus</a></th>
- </tr>
- <?php }?>
- </tbody>
- </table>
- </div>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement