<?php

$categoryName = $_POST['newCategoryName'];
$hexColor = $_POST['newCategoryColor'];

list($r,$g,$b) = sscanf($hexColor, "#%02x%02x%02x");

        $hostname = 'localhost';
        $username = 'narKampen';
        $pass = 'IfRLzj2HJBXA9eei';
        $database = 'narKampen';

        $conn = new mysqli($hostname, $username, $pass, $database);
        if (!$conn) {
                die("Connection Failed. ". mysqli_connect_error());
        }
        mysqli_set_charset($conn,'utf8');

$insertCategorySql = "INSERT INTO category (name, r, g, b, a) VALUES ('$categoryName', $r,$g, $b, 70)";
$result = $conn->query($insertCategorySql);

if (!$result) {
	echo $conn->error;
}
?>