<?php
$host="localhost";
$username="root";
$password="";
$db_name="florenato";

$con = mysql_connect("$host", "$username", "$password");
mysql_select_db("$db_name");

mysql_query("SET NAMES utf8");

$usr_username=$_POST['usr_username'];
$type=$_POST['type'];

$usr_username=stripslashes($usr_username);
$usr_username=mysql_real_escape_string($usr_username);
if(isset($_POST['name'])){
$name = $_POST['name'];
$repeating = $_POST['repeating'];
$reward = $_POST['reward'];
$category = $_POST['category'];

$name=stripslashes($name);
$name=mysql_real_escape_string($name);
$sql="INSERT INTO `ulohy`(`login`, `nazov`, `opakovanie`, `uloha`, `odmena`, `kategoria`) VALUES ('$usr_username','$name','$repeating','$type','$reward','$category')";
$result=mysql_query($sql);
if($result){
    echo "COMPLETED";
}
mysql_close($con);
exit();
}
?>