true, 'data' => $project]);
} else {
throw new Exception("Project not found or access denied.");
}
} catch (Exception $e) {
echo json_encode(['success' => false, 'message' => $e->getMessage()]);
}
exit();
}
// Fetch all projects for the table
$projects = [];
try {
$stmt = mysqli_prepare($conn, "
SELECT p.id, p.project_name, c.client_name, p.status, p.start_date, p.document_file
FROM projects p
JOIN clients c ON p.client_id = c.id
ORDER BY p.created_at DESC
");
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$projects = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_stmt_close($stmt);
} catch (Exception $e) {
// Silently handle
}
?>
Project List - ConstructCRM
