phpnative/koneksi.php at master · diyarcodes/phpnative · GitHub

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
37
38
39
40
41
42
43
44
45
46
<?php
$koneksi = mysqli_connect('localhost', 'root', '', 'phpnative');

function tambahDataMahasiswa($data)
{
    global $koneksi;

    $nrp = htmlspecialchars($data["nrp"]);
    $nama = htmlspecialchars($data["nama"]);
    $email = htmlspecialchars($data["email"]);
    $jurusan = htmlspecialchars($data["jurusan"]);
    $gambar = htmlspecialchars($data["gambar"]);

    $query = mysqli_query($koneksi, "INSERT INTO mahasiswa VALUES('','$nrp','$nama','$email','$jurusan', '$gambar')");
    return mysqli_affected_rows($koneksi);
}

function hapusDataMahasiswa($id)
{
    global $koneksi;

    mysqli_query($koneksi, "DELETE FROM mahasiswa WHERE id='$id'");
    return mysqli_affected_rows($koneksi);
}

function ubahDataMahasiswa($data)
{
    global $koneksi;

    $id = $data["id"];
    $nrp = htmlspecialchars($data["nrp"]);
    $nama = htmlspecialchars($data["nama"]);
    $email = htmlspecialchars($data["email"]);
    $jurusan = htmlspecialchars($data["jurusan"]);
    $gambar = htmlspecialchars($data["gambar"]);

    $query = mysqli_query($koneksi, "UPDATE mahasiswa SET
                                        nrp = '$nrp',
                                        nama = '$nama',
                                        email = '$email',
                                        jurusan = '$jurusan',
                                        gambar = '$gambar'
                                        WHERE id = $id
                                        ");
    return mysqli_affected_rows($koneksi);
}