-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathfollow.php
55 lines (54 loc) · 2.18 KB
/
follow.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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<?php
include 'pdo.php';
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
if(empty($_SESSION['user'])){
echo 'error occured';
}
if(empty($_SESSION['to'])){
echo 'error occured';
}
if(isset($_POST['follow'])&&!empty($_POST['follow'])){
$user=$_SESSION['user'];
$to=$_SESSION['to'];
$stmt=$db->prepare("INSERT INTO followings (username,following) VALUES(:username,:following)");
$stmt->bindParam(':username',$user);
$stmt->bindParam(':following',$to);
$stmt->execute();
$stmt2=$db->prepare("INSERT INTO followers (username,follower) VALUES(:username,:follower)");
$stmt2->bindParam(':username',$to);
$stmt2->bindParam(':follower',$user);
$stmt2->execute();
}
if(isset($_POST['following'])&&!empty($_POST['following'])){
$stmt=$db->prepare("DELETE FROM followings WHERE username=:user AND following=:following");
$stmt->bindParam(':user',$_SESSION['user']);
$stmt->bindParam(':following',$_POST['following']);
$stmt->execute();
$stmt2=$db->prepare("DELETE FROM followers WHERE username=:user AND follower=:follower");
$stmt2->bindParam(':user',$_SESSION['user']);
$stmt2->bindParam(':follower',$_POST['following']);
$stmt2->execute();
}if(isset($_POST['follow_btn'])){
$user=$_SESSION['user'];
$stmt=$db->prepare("INSERT INTO followings (username,following) VALUES(:username,:following)");
$stmt->bindParam(':username',$user);
$stmt->bindParam(':following',$_POST['follow_btn']);
$stmt->execute();
$stmt2=$db->prepare("INSERT INTO followers (username,follower) VALUES(:username,:follower)");
$stmt2->bindParam(':username',$_POST['follow_btn']);
$stmt2->bindParam(':follower',$user);
$stmt2->execute();
}
if(isset($_POST['following_btn'])){
$stmt=$db->prepare("DELETE FROM followings WHERE username=:user AND following=:following");
$stmt->bindParam(':user',$_SESSION['user']);
$stmt->bindParam(':following',$_POST['following_btn']);
$stmt->execute();
$stmt2=$db->prepare("DELETE FROM followers WHERE username=:user AND follower=:follower");
$stmt2->bindParam(':user',$_SESSION['user']);
$stmt2->bindParam(':follower',$_POST['following_btn']);
$stmt2->execute();
}
?>