-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathfunction.php
More file actions
46 lines (39 loc) · 1.22 KB
/
Copy pathfunction.php
File metadata and controls
46 lines (39 loc) · 1.22 KB
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
require 'koneksi.php';
function getFollowing($conn,$idUser){
$sql = "SELECT * , roommenfess.id as roomid FROM roommenfess INNER JOIN following ON following.idRoom = roommenfess.id WHERE following.idUser = '$idUser'";
$result = mysqli_query($conn,$sql);
if($result){
return $result;
}else{
return;
}
}
function isPageActive($currentPage, $pageToCheck) {
return ($currentPage == $pageToCheck);
}
function isLogin($throw){
if(isset($_SESSION['login'])){
return;
}else{
header("location:$throw");
}
}
function getUserId($conn,$email){
$sql = "SELECT id FROM users WHERE email = '$email'";
return mysqli_fetch_assoc(mysqli_query($conn,$sql))['id'];
}
function isFollowRoom($idRoom,$idUser,$conn){
$sql = "SELECT * FROM `following` INNER JOIN roommenfess ON following.idRoom = roommenfess.id WHERE following.idRoom = '$idRoom' AND following.idUser = '$idUser'";
return mysqli_num_rows(mysqli_query($conn,$sql));
}
function convertToKFormat($number) {
if ($number < 1000) {
return $number;
} elseif ($number < 1000000) {
return sprintf('%0.1fk', $number / 1000);
} else {
return sprintf('%0.1fM', $number / 1000000);
}
}
?>