12 lines
420 B
PHP
12 lines
420 B
PHP
<?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";
|
|
}
|