-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathscratch.php
More file actions
36 lines (35 loc) · 2.06 KB
/
scratch.php
File metadata and controls
36 lines (35 loc) · 2.06 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
<!-- <div class = "card mb-4">
<div class="card-header">You Might Like</div>
<?php
$user = $_SESSION['username'];
$conn = connect_db();
$result = $conn->query("SELECT id FROM users WHERE `username` = '{$user}'");
$row = mysqli_fetch_array($result);
$user_id = $row['id'];
$sql = $conn->query("SELECT distinct `user` FROM followers_table WHERE follower_id = '{$user_id}'");
$arr = array();
$counter = 0;
if($sql->num_rows > 0){
while($row = mysqli_fetch_array($sql)) {
$arr[$counter] = $row['user'];
$counter++;
}
//$arr[$counter] = $user;
//var_dump($arr);
}
$list = implode("' ,'", $arr);
$sql_query = $conn->query("SELECT * FROM `users` Where `username` NOT IN ('{$list}') and username != '{$user}' ORDER BY Rand() LIMIT 3 ");
echo '<div class ="card-body">';
if($sql_query->num_rows > 0){
while($row = mysqli_fetch_array($sql_query)){
echo $row['username'];
echo '<form method="POST" action="backend.php">
<input type="hidden" name="user" value="'. $row['username'].'" />
<button id = followerButton class = "btn btn-outline-info" type="submit" name="followbtn" value= "follower">+ Follow</button>
</form>';
echo '<br>';
}
}
echo '</div>';
?>
</div> -->