<?php
// Database file
$db_file = 'database/clients.db';

// Get the selected client ID from the request
$selectedClientId = $_GET['selectedClientId'];

// Open the SQLite database
$db = new SQLite3($db_file);

// Prepare the SQL query
$stmt = $db->prepare('SELECT name, email FROM clients WHERE id = :id');
$stmt->bindValue(':id', $selectedClientId, SQLITE3_INTEGER);

// Execute the query
$result = $stmt->execute();

// Fetch the data
$row = $result->fetchArray(SQLITE3_ASSOC);

// Return the data as JSON
echo json_encode($row);

// Close the database connection
$db->close();
?>