Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_host = '192.168.9.10'; // Nama Server
- $db_user = 'admin_admin'; // User Server
- $db_pass = 'bestari008'; // Password Server
- $db_name = 'admin_suratjalan'; // Nama Database
- $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
- if (!$conn)
- {
- die ('Gagal terhubung MySQL: ' . mysqli_connect_error());
- }
- //$id=$_GET['id_barang_keluar'];
- //$sql='select * from detail_keluar where id_barang_keluar=.$id';
- $sql = 'SELECT id_barang_keluar, nama_barang, qty, satuan, ket
- FROM detail_keluar';
- $query = mysqli_query($conn, $sql);
- if (!$query) {
- die ('SQL Error: ' . mysqli_error($conn));
- }
- echo ' <table border="1px" width="500">
- <thead>
- <tr>
- <th>ID Barang</th>
- <th>Nama Barang</th>
- <th>Qty</th>
- <th>Satuan</th>
- <th>Keterangan</th>
- </tr>
- </thead>
- <tbody>';
- while ($row = mysqli_fetch_array($query))
- {
- echo '<tr>
- <td>'.$row['id_barang_keluar'].'</td>
- <td>'.$row['nama_barang'].'</td>
- <td>'.$row['qty'].'</td>
- <td>'.$row['satuan'].'</td>
- <td>'.$row['ket'].'</td>
- </tr>';
- }
- echo '
- </tbody>
- </table>';
- // Apakah kita perlu menjalankan fungsi mysqli_free_result() ini? baca bagian VII
- mysqli_free_result($query);
- // Apakah kita perlu menjalankan fungsi mysqli_close() ini? baca bagian VII
- mysqli_close($conn);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement