Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $which=$_POST['which'];
- $applicant=$_POST['applicant'];
- session_start();
- require_once 'functions.php';
- if(!isset($_SESSION['name'])){
- session_destroy();
- header('Location:register.php');
- }
- try{
- $pdo=connect();
- if($which='y'){
- $sql="SELECT * from friend_table where friend1=? and friend2=?";
- $stmt=$pdo->prepare($sql);
- $stmt->execute(array($_SESSION['name'],$applicant));
- $result=$stmt->fetch(PDO::FETCH_ASSOC);
- if($result==NULL){
- $sql="INSERT into friend_table(friend1,friend2) values(?,?)";
- $stmt=$pdo->prepare($sql);
- $stmt->execute(array($_SESSION['name'],$applicant));
- $sql="INSERT into friend_table(friend1,friend2) values(?,?)";
- $stmt=$pdo->prepare($sql);
- $stmt->execute(array($applicant,$_SESSION['name']));
- $sql="DELETE from friend_apply_table where applicant=? and receiver=?";
- $stmt=$pdo->prepare($sql);
- $stmt->execute(array($applicant,$_SESSION['name']));
- $sql="DELETE from friend_apply_table where applicant=? and receiver=?";
- $stmt=$pdo->prepare($sql);
- $stmt->execute(array($_SESSION['name'],$applicant));
- }
- }else if($which='n'){
- $sql="DELETE from friend_apply_table where applicant=? and receiver=?";
- $stmt=$pdo->prepare($sql);
- $stmt->execute(array($applicant,$_SESSION['name']));
- }
- header('Location:friend_receive.php');
- }catch (PDOException $e){
- echo $e->getMessage();
- exit;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement