Advertisement
Guest User

koneksi.php

a guest
Jan 24th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. <?php
  2. class database{
  3. //properti
  4. private $dbHost = "localhost";
  5. private $dbUser = "root";
  6. private $dbPass = "";
  7. private $dbName = "testing";
  8.  
  9. //method koneksi MySQL
  10. function connectMySQL(){
  11. $j = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);
  12. mysql_select_db($this->dbName) or die ("error membuat database!");
  13. if($j){
  14. echo ("database telah dibuat");
  15. }
  16.  
  17. //method tambah data (insert)
  18. function tambahAnggota($Nama, $NIM, $Jurusan){
  19. $query = "INSERT INTO mahasiswa (Nama, NIM, Jurusan) VALUES ('$Nama', '$NIM', '$Jurusan')";
  20.  
  21. $hasil = mysql_query($query);
  22.  
  23. if ($hasil)
  24. echo ("Data mahasiswa berhasil tersimpan ke database");
  25. else
  26. echo ("Data mahasiswa gagal tersimpan ke database");
  27. }
  28.  
  29. //method tampilkan data
  30. function template() {
  31. $query = mysql_query("SELECT * FROM mahasiswa ORDER BY id_mahasiswa");
  32. $data[] = $row;
  33. return $data;
  34. }
  35. }
  36. }?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement