93 lines
2.2 KiB
PHP
93 lines
2.2 KiB
PHP
<?PHP
|
|
|
|
require_once "./admin/db/config.php";
|
|
|
|
if (isset($_POST['subscriberEMAIL']) == 'subscriberEMAIL') {
|
|
|
|
$email = $_POST['email'];
|
|
|
|
if (isset($connection)) {
|
|
$checkEmail = $connection->query("SELECT * FROM `subscribers` WHERE `email` = '$email'");
|
|
if ($checkEmail) {
|
|
if ($checkEmail->num_rows > 0) {
|
|
echo "EXISTS";
|
|
} else {
|
|
$addSubscriber = $connection->query("INSERT INTO `subscribers`(`email`) VALUES ('$email')");
|
|
if ($addSubscriber) {
|
|
echo "SUCCESS";
|
|
} else {
|
|
echo "ERROR";
|
|
}
|
|
}
|
|
} else {
|
|
echo "ERROR";
|
|
}
|
|
} else {
|
|
echo "ERROR";
|
|
}
|
|
}
|
|
|
|
if (isset($_POST['category__change__status']) == 'category__change__status') {
|
|
$id = (int)$_POST['id'];
|
|
if (isset($connection)) {
|
|
$getStatus = (int)$connection->query("SELECT `status` FROM `category` WHERE `id` = $id")->fetch_object()->status;
|
|
$changeTo = 1;
|
|
if ($getStatus == 1) {
|
|
$changeTo = 0;
|
|
}
|
|
$changeStatus = $connection->query("UPDATE `category` SET `status` = $changeTo WHERE `id` = $id");
|
|
if ($changeStatus) {
|
|
echo "TRUE";
|
|
} else {
|
|
echo "FALSE";
|
|
}
|
|
} else {
|
|
echo "FALSE";
|
|
}
|
|
|
|
}
|
|
|
|
|
|
if (isset($_POST['sub_category__change__status']) == 'sub_category__change__status') {
|
|
$id = (int)$_POST['id'];
|
|
if (isset($connection)) {
|
|
$getStatus = (int)$connection->query("SELECT `status` FROM `sub_category` WHERE `id` = $id")->fetch_object()->status;
|
|
$changeTo = 1;
|
|
if ($getStatus == 1) {
|
|
$changeTo = 0;
|
|
}
|
|
$changeStatus = $connection->query("UPDATE `sub_category` SET `status` = $changeTo WHERE `id` = $id");
|
|
if ($changeStatus) {
|
|
echo "TRUE";
|
|
} else {
|
|
echo "FALSE";
|
|
}
|
|
} else {
|
|
echo "FALSE";
|
|
}
|
|
|
|
}
|
|
|
|
|
|
if (isset($_POST['services__change__status']) == 'services__change__status') {
|
|
$id = (int)$_POST['id'];
|
|
if (isset($connection)) {
|
|
$getStatus = (int)$connection->query("SELECT `status` FROM `page` WHERE `id` = $id")->fetch_object()->status;
|
|
$changeTo = 1;
|
|
if ($getStatus == 1) {
|
|
$changeTo = 0;
|
|
}
|
|
$changeStatus = $connection->query("UPDATE `page` SET `status` = $changeTo WHERE `id` = $id");
|
|
if ($changeStatus) {
|
|
echo "TRUE";
|
|
} else {
|
|
echo "FALSE";
|
|
}
|
|
} else {
|
|
echo "FALSE";
|
|
}
|
|
|
|
}
|
|
|
|
|