41 lines
1.2 KiB
PHP
41 lines
1.2 KiB
PHP
<?php
|
|
$mysqli = new mysqli('localhost', 'root', '', 'hms_data_ci4');
|
|
|
|
if ($mysqli->connect_error) {
|
|
die("Connect Error: " . $mysqli->connect_error);
|
|
}
|
|
|
|
echo "=== patient_doc with ID 5 ===\n";
|
|
$res = $mysqli->query("SELECT * FROM patient_doc WHERE id = 5");
|
|
if ($row = $res->fetch_assoc()) {
|
|
print_r($row);
|
|
} else {
|
|
echo "No row with id=5 in patient_doc\n";
|
|
}
|
|
|
|
echo "\n=== recent patient_doc rows ===\n";
|
|
$res = $mysqli->query("SELECT id, p_id, dr_id, doc_format_id, created_at FROM patient_doc ORDER BY id DESC LIMIT 5");
|
|
while ($r = $res->fetch_assoc()) {
|
|
print_r($r);
|
|
}
|
|
|
|
echo "\n=== file_upload_data with ID 5 ===\n";
|
|
$res = $mysqli->query("SELECT * FROM file_upload_data WHERE id = 5");
|
|
if ($row = $res->fetch_assoc()) {
|
|
print_r($row);
|
|
} else {
|
|
echo "No row with id=5 in file_upload_data\n";
|
|
}
|
|
|
|
echo "\n=== recent file_upload_data rows ===\n";
|
|
$res = $mysqli->query("SELECT id, pid, insert_date FROM file_upload_data ORDER BY id DESC LIMIT 5");
|
|
while ($r = $res->fetch_assoc()) {
|
|
print_r($r);
|
|
}
|
|
|
|
echo "\n=== abdm_work_tasks with ID 585 ===\n";
|
|
$res = $mysqli->query("SELECT * FROM abdm_work_tasks WHERE id = 585");
|
|
if ($row = $res->fetch_assoc()) {
|
|
print_r($row);
|
|
}
|