<?php
$pdo = new PDO('mysql:host=127.0.0.1;dbname=telegaruda_v2;charset=utf8', 'root', '');
$subjectRef = "vallika v";
$stmt = $pdo->prepare("SELECT * FROM users WHERE LOWER(CONCAT(first_name, ' ', last_name)) = ?");
$stmt->execute([strtolower(trim($subjectRef))]);
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if ($row) {
    echo "Found patient ID: " . $row['id'] . "\n";
} else {
    echo "Patient not found by name.\n";
}