Advertisement
mrkutux

asdasd

Jun 20th, 2019
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title> Data </title>
  5. </head>
  6. <body>
  7.  
  8. <?
  9. //db
  10. define("DB_USER", "root");
  11. define("DB_PASSWORD", "");
  12. define("DB_DATABASE", "db_view");
  13. define("DB_HOST", "localhost");
  14. $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
  15. $sql = "INSERT INTO tb_siswa (nama, kelas, jurusan) VALUES ('" . $_POST['nama'] . "','" . $_POST['kelas'] . "','" . $_POST['jurusan'] . "')";
  16. $result = $mysqli->query($sql);
  17. $sql = "SELECT * FROM tb_siswa Order by id_siswa desc LIMIT 1";
  18. ?>
  19. <form method="POST">
  20. <div>
  21. <labelfor="nama">Nama</label>
  22. <input type="text" name="nama" required />
  23. </div>
  24. <br>
  25. <div>
  26. <labelfor="kelas">Kelas</label>
  27. <input name="kelas"required />
  28. </div>
  29. <br>
  30. <div >
  31. <label for="jurusan">Jurusan</label>
  32. <input type="text" name="jurusan" required />
  33. </div>
  34. <br>
  35. <div>
  36. <button type="submit">Submit</button>
  37. </div>
  38. </form>
  39. </div>
  40. <?php
  41. $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
  42. $select = "SELECT * FROM tb_siswa";
  43. $query = mysqli_query($mysqli, $select);
  44. $no=0;
  45. while ($data = mysqli_fetch_array($query)) {
  46. $nama = $data['nama'];
  47. $kelas = $data['kelas'];
  48. $jurusan = $data['jurusan'];
  49. $no++;}
  50. echo"
  51. <tr>
  52. <td> Nama : $nama </td>
  53. <td> Kelas : $kelas </td>
  54. <td> Jurusan: $jurusan </td>
  55. <td>
  56. ";
  57. ?>
  58. </body>
  59. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement