-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.php
36 lines (34 loc) · 1.06 KB
/
database.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<?php
class database {
var $host = "localhost";
var $username = "root";
var $password = "";
var $database = "kosan";
var $koneksi = "";
function __construct() {
$this->koneksi = mysqli_connect($this->host, $this->username, $this->password, $this->database);
if (mysqli_connect_errno()) {
echo "Koneksi database gagal : " . mysqli_connect_error();
}
}
function tampil_data($query) {
$sql = mysqli_query($this->koneksi, $query);
while ($data = mysqli_fetch_array($sql)) {
$hasil[] = $data;
}
return $hasil;
}
function query_data($query) {
$sql = mysqli_query($this->koneksi, $query);
if($sql = true) {
return true;
} else {
return false;
}
}
function get_data($query) {
$sql = mysqli_query($this->koneksi, $query);
return $sql->fetch_assoc();
}
}
?>