connect_error) { die("Connection failure:" . $conn->connect_error); } $Beginning_activity_id = isset($_POST['Beginning_activity_id']) ? $_POST['Beginning_activity_id'] : 'default_value'; $Cease_activity_id = isset($_POST['Cease_activity_id']) ? $_POST['Cease_activity_id'] : 'default_value'; $sql = "SELECT STOPS.id_activ, A1.reading_time AS reading_time_id_activ, STOPS.type, STOPS.id_activ2, A2.reading_time AS reading_time_id_activ2, A1.Sensor FROM STOPS JOIN ACTIVITY AS A1 ON STOPS.id_activ = A1.id JOIN ACTIVITY AS A2 ON STOPS.id_activ2 = A2.id WHERE STOPS.id_activ = ? AND STOPS.id_activ2 = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("ii", $Beginning_activity_id, $Cease_activity_id); $stmt->execute(); $result = $stmt->get_result(); while($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; $start = new DateTime($row['reading_time_id_activ']); $end = new DateTime($row['reading_time_id_activ2']); $interval = $start->diff($end); $minutes = $interval->days * 24 * 60; $minutes += $interval->h * 60; $minutes += $interval->i; echo ""; echo ""; echo ""; } $stmt->close(); ?>

Sensor	Start Time	End Time	Duration	Ishikawa Cat.
" . $row['Sensor'] . "	" . date('Y-m-d H:i', strtotime($row['reading_time_id_activ'])) . "	" . date('Y-m-d H:i', strtotime($row['reading_time_id_activ2'])) . "	" . $minutes . " min	" . $row['type'] . "