set_charset("utf8");
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Get the ID parameter from the URL
if (!isset($_GET['ID'])) {
die("ID parameter not specified");
}
$id = $conn->real_escape_string($_GET['ID']);
// SQL query to retrieve the record with the specified ID
$query = "SELECT * FROM `TABLE 1` WHERE `COL 1` = '$id'";
// Execute the SQL query
$result = $conn->query($query);
if ($result->num_rows == 0) {
die("Record not found");
}
$row = $result->fetch_assoc();
?>
<?= $row['COL 5'] ?>