query(" SELECT * FROM places WHERE name LIKE '%" . strtolower($meta) . "%' ");
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
// Wenn die suche leer ist, sollen auch keine Ergebnisse kommen (siehe Vorschläge ignorieren)
if($meta == "") {
return;
}
?>
'); search('results');">
Vorschläge ignorieren
$measurement) {
if(!str_contains(strtolower($measurement["program_id_string"]), strtolower($meta))) {
continue;
}
print('
');
$i = 0;
foreach($measurement["program_id_bits"] as $programIDChar) {
echo '' . $programIDChar . '';
$i++;
}
print('
' . date("d.m.Y H:i:s", $measurement["timestamp"]) . '
');
?>
');
if(!empty($measurement["comment"])) {
print('
');
echo $measurement["comment"];
print('
');
}
}
?>
query("
SELECT
m.id AS measurement_id,
m.comment AS comment,
m.timestamp AS timestamp,
m.place_name AS place_name,
b.value AS bit_value,
b.position AS bit_position
FROM
measurements m
JOIN places p ON p.name = m.place_name
JOIN measurement_program_id_bits b ON b.measurement_id = m.id
ORDER BY m.id
");
// Die Datenbank wird als dreifach indexiertes Array gespeichert
$database_db = [];
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
$database_db[$row["place_name"]][$row["measurement_id"]]["program_id_bits"][$row["bit_position"]] = $row["bit_value"];
$database_db[$row["place_name"]][$row["measurement_id"]]["comment"] = $row["comment"];
$database_db[$row["place_name"]][$row["measurement_id"]]["timestamp"] = $row["timestamp"];
}
/*
$database_db
└── $row["place_name"]
└── $row["measurement_id"]
├── "program_id_bits"
│ └── $row["bit_position"]
│ └── $row["bit_value"]
├── "program_id_string"
│ └── implode('', $bits)
├── "comment"
│ └── $row["comment"]
└── "timestamp"
└── $row["timestamp"]
*/
foreach($database_db as $place_name => $measurements) {
?>
[]
$measurement) {
print('
');
foreach($measurement["program_id_bits"] as $programIDChar) {
echo '
' . $programIDChar . '';
}
print('
' . date("d.m.Y H:i:s", $measurement["timestamp"]) . '
');
?>
');
if(!empty($measurement["comment"])) {
print('
');
echo $measurement["comment"];
print('
');
}
}
?>
