<?php
if ($_SERVER["REQUEST_METHOD"] === "POST") {


    if (isset($_POST['data'])) {


   // Get the data as a concatenated string
    $dataString = $_POST['data'];
    $dataString = str_replace('&', '-LBR', $dataString);
    
    
        // Split the data using the delimiter (colon in this case)
    $dataParts = explode('«', $dataString);

    // Extract individual values from the array
    $projectname = $dataParts[1];
    $clientprogress = html_entity_decode($dataString);
       

    // Connect to the SQLite database
    $db = new SQLite3('database/projects.db');
	
	
	if (!$db) {
        die("Failed to connect to the database.");
    }
	
	
    // Prepare and execute the INSERT query to add the client to the database
    $updateQuery = "UPDATE projects SET clientprogress = :clientprogress WHERE projectname = :projectname";
   

	    $stmt = $db->prepare($updateQuery);

        if (!$stmt) {
            die("Prepare failed: " . $db->lastErrorMsg());
        }

        $stmt->bindValue(':clientprogress', $clientprogress, SQLITE3_TEXT);
        $stmt->bindValue(':projectname', $projectname, SQLITE3_TEXT);

        $result = $stmt->execute();



        if (!$result) {
            die("Execute failed: " . $db->lastErrorMsg());
        }

        // Close the database connection and the prepared statement
        $stmt->close();
        $db->close();


        $successfull = "Successfull";
		echo json_encode(['successfull' => $successfull]);

    } else {
		$successfull = "Not Successfull";
		echo json_encode(['successfull' => $successfull]);
    }
	
	
	}
?>