<?php
session_start();
ini_set('display_errors', 1); 
ini_set('display_startup_errors', 1); 
error_reporting(E_ALL);
include_once('../../includes/db_connect.php');
header("Content-Type:application/json");
$date = date("Y-m-d H:i:s");
$year = date("Y");
// if(isset($_SESSION["OPENUNI^###DHSG"])){
//     $email = $_SESSION["OPENUNI^###DHSG"];
    // $chkuser = mysqli_query($con,"SELECT * FROM admins WHERE admin_email='$email'");
    // while($row = mysqli_fetch_assoc($chkuser)){
    //   $uid = $row["id"];
    //   $name = $row["admin_name"];
    // }
/*<===========================category Management=================================>*/
if(isset($_POST["name"])){
 $id = trim(mysqli_real_escape_string($con, $_POST["categoryid"]));
 $name = trim(mysqli_real_escape_string($con, $_POST["name"]));
 $schoolid = trim(mysqli_real_escape_string($con, $_POST["schoolid"]));
 $description = trim(mysqli_real_escape_string($con, $_POST["description"]));
 $url = strtolower(preg_replace("#[^0-9a-zA-Z()!,.?'\"]#i","-",$name));
  if($_FILES['image']['name']!=""){
  $image = str_replace(" ","",$_FILES['image']['name']); 
  $file_tmp =$_FILES['image']['tmp_name'];
  move_uploaded_file($file_tmp,"../../category-images/".$image);
  }else{
   $image="ic_launcher.png";  
 }
    //New category
    if($id == ""){
     if(mysqli_query($con,"INSERT INTO categories(name,icon,url,schoolid,description) VALUES('$name','$image','$url','$schoolid','$description')")){
       echo json_encode(array("status" => 200, "message" => "SUCCESS"));
      }
      else{
        echo json_encode(array('status' => 300,'message' => mysqli_error($con)));
      }
    }
    else{
    if(mysqli_query($con,"UPDATE categories SET name='$name',schoolid='$schoolid',description='$description' WHERE id = '$id'")){
         echo json_encode(array('status' => 200,'message' => 'SUCCESS'));
        }
        else{
          echo json_encode(array('status' => 300,'message' => 'ERROR'));
      }
    }
  }


//}
?>
<?php mysqli_close($con) ?>