include 'config_file.php';

    $message = '';

    $connection = new mysqli($host_name, $host_user, $host_password, $database_name);
    
    
    if ($connection->connect_error)
    {
        die("Connection failed: " . $connection->connect_error);
    }
    
    $json = json_decode(file_get_contents('php://input'), true);
    $check_query = '';
    
    if ($json[add] == 0)
    {
    	//delete
        $message='yay';
    	$check_query = "DELETE FROM notification_quotes_table WHERE category = '$json[category]' AND username = '$json[username]'";
    }
    else{
    	//add
        $message='yay';
    	$check_query = "INSERT INTO notification_quotes_table (username, quotes, category) SELECT '$json[username]', quote as quotes, category from Category_Quotes where category = '$json[category]'";
    }
    
    $result = $connection->query($check_query);
    if ($result === true)
    {
    	$message = 'Success!';
    }
    else {
    	$message = 'Error';
    }

    echo json_encode($message);
        
    $connection->close();