Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title> Data </title>
- </head>
- <body>
- <?
- //db
- define("DB_USER", "root");
- define("DB_PASSWORD", "");
- define("DB_DATABASE", "db_view");
- define("DB_HOST", "localhost");
- $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
- $sql = "INSERT INTO tb_siswa (nama, kelas, jurusan) VALUES ('" . $_POST['nama'] . "','" . $_POST['kelas'] . "','" . $_POST['jurusan'] . "')";
- $result = $mysqli->query($sql);
- $sql = "SELECT * FROM tb_siswa Order by id_siswa desc LIMIT 1";
- ?>
- <form method="POST">
- <div>
- <labelfor="nama">Nama</label>
- <input type="text" name="nama" required />
- </div>
- <br>
- <div>
- <labelfor="kelas">Kelas</label>
- <input name="kelas"required />
- </div>
- <br>
- <div >
- <label for="jurusan">Jurusan</label>
- <input type="text" name="jurusan" required />
- </div>
- <br>
- <div>
- <button type="submit">Submit</button>
- </div>
- </form>
- </div>
- <?php
- $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
- $select = "SELECT * FROM tb_siswa";
- $query = mysqli_query($mysqli, $select);
- $no=0;
- while ($data = mysqli_fetch_array($query)) {
- $nama = $data['nama'];
- $kelas = $data['kelas'];
- $jurusan = $data['jurusan'];
- $no++;}
- echo"
- <tr>
- <td> Nama : $nama </td>
- <td> Kelas : $kelas </td>
- <td> Jurusan: $jurusan </td>
- <td>
- ";
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement