Advertisement
riansaadillah

Untitled

Jul 1st, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.52 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.   <head>
  4.     <meta charset="utf-8">
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1">
  7.     <meta name="description" content="">
  8.     <meta name="author" content="">
  9.     <title>Passing Data To Modal</title>
  10.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
  11.   </head>
  12.  
  13.   <body>
  14.     <div class="container">
  15.       <div class="row">
  16.         <table class="table table-bordered">
  17.           <tr>
  18.             <th>No</th>
  19.             <th>Nama Barang</th>
  20.             <th colspan="2">Opsi</th>
  21.           </tr>
  22.           <?php
  23.             $servername = "localhost";
  24.             $username = "root";
  25.             $password = "root";
  26.             $dbname = "test";
  27.  
  28.             // Membuat Koneksi
  29.             $koneksi = new mysqli($servername, $username, $password, $dbname);
  30.            
  31.             // Melakukan Cek Koneksi
  32.             if ($koneksi->connect_error) {
  33.                 die("Koneksi Gagal : " . $koneksi->connect_error);
  34.             }
  35.  
  36.             //Melakukan query
  37.             $sql = "SELECT * FROM barang";
  38.             $hasil = $koneksi->query($sql);
  39.             $no = 1;
  40.             if ($hasil->num_rows > 0) {
  41.                 foreach ($hasil as $row) { ?>
  42.                   <tr>    
  43.                   <td><?php echo $no; ?></td>
  44.                   <td><?php echo $row['nama_barang']; ?></td>
  45.                   <?php echo "<td><a href='#myModal' class='btn btn-default btn-small' id='custId' data-toggle='modal' data-id=".$row['id'].">Detail</a></td>"; ?>
  46.                   </tr>
  47.             <?php
  48.             $no++;
  49.             }
  50.               } else {
  51.             echo "0 results";
  52.               } $koneksi->close();
  53.             ?>
  54.  
  55.         </table>
  56.       </div>
  57.     </div>
  58.  
  59.     <div class="modal fade" id="myModal" role="dialog">
  60.         <div class="modal-dialog" role="document">
  61.             <div class="modal-content">
  62.                 <div class="modal-header">
  63.                     <button type="button" class="close" data-dismiss="modal">&times;</button>
  64.                     <h4 class="modal-title">Detail Barang</h4>
  65.                 </div>
  66.                 <div class="modal-body">
  67.                     <div class="fetched-data"></div>
  68.                 </div>
  69.                 <div class="modal-footer">
  70.                     <button type="button" class="btn btn-default" data-dismiss="modal">Keluar</button>
  71.                 </div>
  72.             </div>
  73.         </div>
  74.     </div>
  75.  
  76.   <script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
  77.   <script type="text/javascript">
  78.     $(document).ready(function(){
  79.         $('#myModal').on('show.bs.modal', function (e) {
  80.             var rowid = $(e.relatedTarget).data('id');
  81.             //menggunakan fungsi ajax untuk pengambilan data
  82.             $.ajax({
  83.                 type : 'post',
  84.                 url : 'detail.php',
  85.                 data :  'rowid='+ rowid,
  86.                 success : function(data){
  87.                 $('.fetched-data').html(data);//menampilkan data ke dalam modal
  88.                 }
  89.             });
  90.          });
  91.     });
  92.   </script>
  93.     <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
  94.   </body>
  95. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement