<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

require_once("config.php");
require_once("user/protect.php");
require_once("user/user-lib.php");

$db = new PDO(
      "mysql:host=".USER_DB_HOST.";dbname=".USER_DB_NAME.";charset=".USER_DB_CHARSET,
      USER_DB_USER, USER_DB_PASSWORD, [
      PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, 
      PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
    ]);


extract($_POST, EXTR_SKIP);

for ($i = 1; $i <= 9; $i++) {
    $varName = 's' . $i;
    $$varName = base64_decode($$varName);
}

if ($id == 0) {
    $sql = "
    INSERT INTO projects (
        user_id, project_name, date_created, last_edited, category, language, audience, p1_input,product_name, summary, editor_store, longtail,s1,s2,s3,s4,s5,s6,s7,s8,s9
    ) 
    VALUES (
        :user_id, :project_name, NOW(), NOW(), :category, :language, :audience, :p1_input, :product_name, :summary, :editor_store, :longtail,:s1,:s2,:s3,:s4,:s5,:s6,:s7,:s8,:s9
    )

";
	$stmt = $db->prepare($sql);
	$stmt->bindParam(':user_id', $userid);
	$stmt->bindParam(':project_name', $projectname);
	$stmt->bindParam(':category', $category);
	$stmt->bindParam(':language', $language);
	$stmt->bindParam(':audience', $audience);
	$stmt->bindParam(':p1_input', $p1_input);
	$stmt->bindParam(':product_name', $product_name);
	$stmt->bindParam(':summary', $summary);
	$stmt->bindParam(':editor_store', $editor_store);
	$stmt->bindParam(':longtail', $longtail);
	for ($i = 1; $i <= 9; $i++) {
		$stmt->bindParam(":s$i", ${"s$i"});
	}
    $stmt->execute();
    $lastId = $db->lastInsertId();
    echo $lastId;
	exit();
} else {
    $sql = "SELECT * FROM projects WHERE id = :projectid AND user_id = :user_id";
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':projectid', $id);
    $stmt->bindParam(':user_id', $userid);
    $stmt->execute();

    if($stmt->rowCount() > 0) {
		$sql = "
			UPDATE projects 
			SET project_name=:project_name, last_edited = NOW(), category=:category, language=:language, audience=:audience, p1_input=:p1_input,product_name=:product_name, summary=:summary, editor_store=:editor_store, longtail=:longtail,s1=:s1, s2=:s2, s3=:s3, s4=:s4, s5=:s5, s6=:s6, s7=:s7, s8=:s8, s9=:s9 WHERE id = :projectid AND user_id=:user_id
		";

        $stmt = $db->prepare($sql);
		$stmt->bindParam(':project_name', $projectname);
		$stmt->bindParam(':category', $category);
		$stmt->bindParam(':language', $language);
		$stmt->bindParam(':audience', $audience);
		$stmt->bindParam(':p1_input', $p1_input);
		$stmt->bindParam(':projectid', $id);
		$stmt->bindParam(':user_id', $userid);
		$stmt->bindParam(':product_name', $product_name);
		$stmt->bindParam(':summary', $summary);
		$stmt->bindParam(':editor_store', $editor_store);
		$stmt->bindParam(':longtail', $longtail);
		for ($i = 1; $i <= 9; $i++) {
			$stmt->bindParam(":s$i", ${"s$i"});
		}
        $stmt->execute();
        
        echo $id;
		exit();
        
    } else {
        echo "ERROR";
    }
}

?>
