notif-php/function.php at master · efrizall/notif-php · 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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<?php

include('db.php');

$query = "SELECT * FROM `pesan` WHERE `statusAVP` LIKE 'unread' ";
$data = mysqli_query($conn, $query);
$result = mysqli_num_rows($data); //jumlah pesan yg belum dibaca

function countNotif()
{
    global $result;
    return $result;
}

// function cekUser()
// {
//     if ($_SESSION['user'] == 1) {
//         return true;
//     } else {
//         return false;
//     }
// }

function fetchData($id)
{
    global $conn;
    $query = "SELECT * FROM `pesan` WHERE `id` = $id";
    $data = mysqli_query($conn, $query);
    $result = mysqli_fetch_assoc($data);
    return $result;
}

function allData()
{
    global $conn;
    $query = "SELECT * FROM `pesan` WHERE `statusAVP` LIKE 'unread' ";
    $data = mysqli_query($conn, $query);
    return mysqli_fetch_assoc($data);
}

function updateData($id)
{
    global $conn;
    $query = "UPDATE `pesan` SET `statusAVP` = 'read' WHERE `pesan`.`id` = $id";
    return mysqli_query($conn, $query);
}

function readData($id)
{
    global $conn;
    $query = "UPDATE `pesan` SET `statusAVP` = 'read' WHERE `pesan`.`id` LIKE $id";
    return mysqli_query($conn, $query);
}

function isRead($id)
{
    global $conn;
    $query = "SELECT `statusAVP` FROM `pesan` WHERE `id` = $id";
    $data = mysqli_query($conn, $query);
    $result = mysqli_fetch_assoc($data);
    return $result['statusAVP'];
}

function changeButton($id)
{

    if (isRead($id) == 'read') {
        echo 'success';
    } else {
        echo 'danger';
    }
}