Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads
<?php
session_start();
include "db.php";
// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
echo json_encode([
"status" => "error",
"message" => "Not logged in"
]);
exit();
}
$user_id = $_SESSION['user_id'];
// Get the JSON data from the request
$json_data = file_get_contents('php://input');
$data = json_decode($json_data, true);
if (!$data || !isset($data['original_dutch']) || !isset($data['original_english']) ||
!isset($data['new_dutch']) || !isset($data['new_english'])) {
echo json_encode([
"status" => "error",
"message" => "Invalid data provided"
]);
exit();
}
$original_dutch = $data['original_dutch'];
$original_english = $data['original_english'];
$new_dutch = $data['new_dutch'];
$new_english = $data['new_english'];
// Basic validation
if (empty($new_dutch) || empty($new_english)) {
echo json_encode([
"status" => "error",
"message" => "Both Dutch and English words are required"
]);
exit();
}
try {
// Update the specific word
$stmt = $conn->prepare("
UPDATE words
SET dutch = ?, english = ?
WHERE user_id = ? AND dutch = ? AND english = ?
LIMIT 1
");
$stmt->execute([$new_dutch, $new_english, $user_id, $original_dutch, $original_english]);
if ($stmt->rowCount() > 0) {
echo json_encode([
"status" => "success",
"message" => "Word updated successfully"
]);
} else {
echo json_encode([
"status" => "error",
"message" => "Word not found or no changes made"
]);
}
} catch (PDOException $e) {
echo json_encode([
"status" => "error",
"message" => "Database error: " . $e->getMessage()
]);
}
?>