<?php
include 'config.php';
$id = $_REQUEST['id'];

$EXAM_CATEGORY = "sp_exam_category";

//change status 
if (isset($_REQUEST["pageid"]) && isset($_REQUEST["pageid"]) == "category") {
     $click = $_REQUEST['clickid'];
     if ($click > 0) {
          $checkRecord = $db->prepare("Select cat_id,status from $EXAM_CATEGORY WHERE cat_id='$click'");
          $checkRecord->execute();
          $row = $checkRecord->fetch();

          if ($row['status'] == 0) {
               $runPost = $db->prepare("UPDATE $EXAM_CATEGORY SET status='1' WHERE cat_id =" . $click);
               $runPost->execute();
               echo 1;
          } else {
               $runPost = $db->prepare("UPDATE $EXAM_CATEGORY SET status='0' WHERE cat_id =" . $click);
               $runPost->execute();
               echo 0;
          }
          
     }
}