Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <meta name="description" content="">
- <meta name="author" content="">
- <title>Passing Data To Modal</title>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
- </head>
- <body>
- <div class="container">
- <div class="row">
- <table class="table table-bordered">
- <tr>
- <th>No</th>
- <th>Nama Pengguna</th>
- <th>Email Pengguna</th>
- <th>Password Pengguna</th>
- <th>Opsi</th>
- </tr>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "db_guide";
- // Membuat Koneksi
- $koneksi = new mysqli($servername, $username, $password, $dbname);
- // Melakukan Cek Koneksi
- if ($koneksi->connect_error) {
- die("Koneksi Gagal : " . $koneksi->connect_error);
- }
- //Melakukan query
- $sql = "SELECT * FROM user";
- $hasil = $koneksi->query($sql);
- $no = 1;
- if ($hasil->num_rows > 0) {
- foreach ($hasil as $row) { ?>
- <tr>
- <td><?php echo $no; ?></td>
- <td><?php echo $row['nama']; ?></td>
- <td><?php echo $row['email']; ?></td>
- <td><?php echo $row['psw']; ?></td>
- <?php echo "<td><a href='updateuser.php' class='btn btn-default btn-small' id='custId' data-toggle='modal' data-id=".$row['kode_user'].">Detail</a></td>"; ?>
- </tr>
- <?php
- $no++;
- }
- } else {
- echo "0 results";
- } $koneksi->close();
- ?>
- </table>
- </div>
- </div>
- <div class="modal fade" id="myModal" role="dialog">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal">×</button>
- <h4 class="modal-title">User Detail</h4>
- </div>
- <div class="modal-body">
- <div class="fetched-data"></div>
- </div>
- <div class="modal-footer">
- <button type="button" class="btn btn-default" data-dismiss="modal">Keluar</button>
- </div>
- </div>
- </div>
- </div>
- <script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
- <script type="text/javascript">
- $(document).ready(function(){
- $('#myModal').on('show.bs.modal', function (e) {
- var rowid = $(e.relatedTarget).data('id');
- //menggunakan fungsi ajax untuk pengambilan data
- $.ajax({
- type : 'post',
- url : 'detail.php',
- data : 'rowid='+ rowid,
- success : function(data){
- $('.fetched-data').html(data);//menampilkan data ke dalam modal
- }
- });
- });
- });
- </script>
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement