DrodXStore/userBlockProcess.php at main · DisanduRodrigo/DrodXStore · 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
<?php

include "connection.php";

if(isset($_GET["email"])){

    $user_email = $_GET["email"];

    $user_rs = Database::search("SELECT * FROM `user` WHERE `email`='".$user_email."'");
    $user_num = $user_rs->num_rows;

    if($user_num == 1){

        $user_data = $user_rs->fetch_assoc();

        if($user_data["status_status_id"] == 1){
            Database::iud("UPDATE `user` SET `status_status_id`='2' WHERE `email`='".$user_email."'");
            echo ($user_data["fname"]." ".$user_data["lname"]." blocked.");
        }else if($user_data["status_status_id"] == 2){
            Database::iud("UPDATE `user` SET `status_status_id`='1' WHERE `email`='".$user_email."'");
            echo ($user_data["fname"]." ".$user_data["lname"]." unblocked.");
        }

    }else{
        echo ("Cannot find the user. Please try again later.");
    }

}else{
    echo ("Something went wrong");
}

?>