Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class database{
- //properti
- private $dbHost = "localhost";
- private $dbUser = "root";
- private $dbPass = "";
- private $dbName = "testing";
- //method koneksi MySQL
- function connectMySQL(){
- $j = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);
- mysql_select_db($this->dbName) or die ("error membuat database!");
- if($j){
- echo ("database telah dibuat");
- }
- //method tambah data (insert)
- function tambahAnggota($Nama, $NIM, $Jurusan){
- $query = "INSERT INTO mahasiswa (Nama, NIM, Jurusan) VALUES ('$Nama', '$NIM', '$Jurusan')";
- $hasil = mysql_query($query);
- if ($hasil)
- echo ("Data mahasiswa berhasil tersimpan ke database");
- else
- echo ("Data mahasiswa gagal tersimpan ke database");
- }
- //method tampilkan data
- function template() {
- $query = mysql_query("SELECT * FROM mahasiswa ORDER BY id_mahasiswa");
- $data[] = $row;
- return $data;
- }
- }
- }?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement