-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathupdateFollowingCategoryProcess.php
More file actions
27 lines (24 loc) · 1.08 KB
/
updateFollowingCategoryProcess.php
File metadata and controls
27 lines (24 loc) · 1.08 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
<?php
session_start();
require "connection.php";
if(isset($_SESSION["user"]) & !empty($_SESSION["user"])){
if(isset($_GET["ctgId"]) & !empty($_GET)){
$categoryId = $_GET["ctgId"];
$userHasCategoryResultset = Database::search("SELECT * FROM `user_has_category` WHERE `category_id`='" . $categoryId . "' AND `user_email`='" . $_SESSION["user"]["email"] . "'");
$userHasCategoryRownumber = $userHasCategoryResultset->num_rows;
$userHasCategoryData = $userHasCategoryResultset->fetch_assoc();
if($userHasCategoryRownumber > 0){
Database::insertUpdateDelete("DELETE FROM `user_has_category` WHERE `id`='" . $userHasCategoryData["id"] . "'");
echo("category removed");
}else{
Database::insertUpdateDelete("INSERT INTO `user_has_category` (`user_email`,`category_id`) VALUES
('" . $_SESSION["user"]["email"] . "','" . $categoryId . "')");
echo("category added");
}
}else{
echo("Something went wrong");
}
}else{
echo("user rejected");
}
?>