function addcategory() {
 $serverWIBLname = getConn("servername");
  $userWOBLname = getConn("username");
  $passBABLword = getConn("password");

  $categoryrecord = json_decode(file_get_contents('php://input'));  //get user from

  $categoryid = $categoryrecord->CategoryID;
  $category = $categoryrecord->Category;
  $categorydescription = $categoryrecord->Description;
  $categorydisplay = $categoryrecord->Display;
  $categoryoffers = $categoryrecord->Offers;
  $categoryordering = $categoryrecord->Ordering;

  // Connect
  $mysqli = new mysqli($serverWIBLname, $userWOBLname, $passBABLword, $userWOBLname);

  if(!$mysqli) die('Could not connect: ' . mysql_error());
  // Prepare parameters
  $mysqli->query("set names 'utf8'");
  $mysqli->query("SET @categoryid = " . "'" . $mysqli->real_escape_string($categoryid) . "'");
  $mysqli->query("SET @category = " . "'" . $mysqli->real_escape_string($category) . "'");
  $mysqli->query("SET @categorydescription = " . "'" . $mysqli->real_escape_string($categorydescription) . "'");
  $mysqli->query("SET @categorydisplay = " . "'" . $mysqli->real_escape_string($categorydisplay) . "'");
  $mysqli->query("SET @categoryoffers = " . "'" . $mysqli->real_escape_string($categoryoffers) . "'");
  $mysqli->query("SET @categoryordering = " . "'" . $mysqli->real_escape_string($categoryordering) . "'");

  // IF(500<1000, "YES", "NO")

  // Call sproc
  if ($categoryid > 0) {
    // edit
    if ($category <> "") {
      $result = $mysqli->query(" UPDATE Categories"
            ." SET Category = @category,"
            ." Description = @categorydescription,"
            ." Offers = @categoryoffers,"
            ." Ordering = @categoryordering,"
            ." Display = @categorydisplay"
            ." WHERE CategoryID = @categoryid");
      if(!$result) die("Fail: (" . $mysqli->errno . ") " . $mysqli->error);
    };
  } else {
    // add
    if ($category <> "") {
      $result = $mysqli->query( " INSERT INTO Categories"
            ." (Category, Description, Offers, Ordering, Display)"
            ." VALUES (@category, @categorydescription, IFNULL(@categoryoffers,0), IFNULL(@categoryordering,0), IFNULL(@categorydisplay,0))");
      if(!$result) die("Fail: (" . $mysqli->errno . ") " . $mysqli->error);
    };
  };

  //echo "saved";

  $mysqli->close();
};