<?php
if ((isset($_POST['project'])) && (isset($_POST['user']))){

		$project = mysql_escape_string($_POST['project']);
		$user = mysql_escape_string($_POST['user']);
		$taskLength = $_POST['taskLength'];
		
		$conexion = mysql_connect("localhost", "USERNAME", "PASSWORD");
		mysql_select_db("DATABASE", $conexion);
		
		//GET OR SET PROJECT
		$query = "SELECT * FROM projects as p WHERE p.project_name = '$project' ";

		$res = mysql_query($query, $conexion) or die(mysql_error());
	
		if ($row = mysql_fetch_assoc($res)) {
			$projectId=    $row['project_id']; 
		}else{
			$query = "INSERT INTO projects (`project_id`, `project_name`) VALUES (NULL, '$project')";
			$res = mysql_query($query, $conexion) or die(mysql_error());
			
			$query = "SELECT * FROM projects as p WHERE p.project_name = '$project' ";
			$res = mysql_query($query, $conexion) or die(mysql_error());
			if ($row = mysql_fetch_assoc($res)){
				$projectId= $row['project_id'];
			}
		}

		//GET OR SET USER
		$query = "SELECT * FROM users as u WHERE u.user_name = '$user' ";
		$res = mysql_query($query, $conexion) or die(mysql_error());
	
		if ($row = mysql_fetch_assoc($res)) {
			$userId=    $row['user_id']; 
		}else{
			$query = "INSERT INTO users (`user_id`, `user_name`) VALUES (NULL, '$user')";
			$res = mysql_query($query, $conexion) or die(mysql_error());
			
			$query = "SELECT * FROM users as u WHERE u.user_name = '$user' ";
			$res = mysql_query($query, $conexion) or die(mysql_error());
			if ($row = mysql_fetch_assoc($res)){
				$userId=    $row['user_id'];
			}
		}

		for ($i=0; $i< $taskLength; $i++) {
		 	$query= "INSERT INTO tasks VALUES (NULL,'".mysql_escape_string($_POST['task-name-'.$i])."',".$_POST['task-time-'.$i].",'".mysql_escape_string($_POST['task-result-'.$i])."','".mysql_escape_string($_POST['task-coment-'.$i])."',$userId,$projectId,".mysql_escape_string($_POST['task-question-'.$i]).",".$_POST['task-id-'.$i].")";
			$res = mysql_query($query, $conexion) or die(mysql_error());
		}

}

?>