What do you want to do today?

How it works?

Consult super specialists online with very easy process

For new second opinion, click on Get second opinion

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } pg_free_result($stmt2); } ?>
Doctor Patient Date Status
' . $row['doctor_name'] . '' . $row['patient_name'] . '' . $row['log_timestamp'] . '' . $row['status'] . ''; if ($row['login_email'] == $_SESSION['smiley_uid']) { if ($row['status'] == 'Payment successful' || $row['status'] == 'Waiting for doctor response') echo 'Next step'; else if ($row['status'] == 'Second opinion sent to patient') echo 'View opinion'; } else { if ($row['status'] == 'Waiting for doctor response') echo 'View Case'; else if ($row['status'] == 'Second opinion sent to patient') echo 'View Case'; } echo '

Upload Documents


'; if (!empty($all_tags)) echo '
View documents related to:
'; $i = 1; foreach ($all_tags as $this_tag) { if ($i > 20) break; else echo '
' . $this_tag . '
'; $i = $i + 1; } if (!empty($all_tags)) echo '
ALL
'; echo '
'; pg_result_seek($stmt, 0); echo '
'; while ($row = pg_fetch_row($stmt)) { $salt = hash('sha256', $row[0]); $salt = hash('sha256', $salt); $time = new DateTime($row[5]); $shared_with = $row[7]; $owner_hover = $row[8]; $owner = $row[10]; $tags = $row[11]; if (($allow && $_SESSION['smiley_uid'] === $row[1]) || (!$allow && $_SESSION['smiley_cid'] == $row[9])) { if ($row[7] == null) { $shared_with_info = 'info'; } else { $shared_with_info = 'info'; } echo ' '; } else { echo ' '; } } echo '
SELECT NAME DATE DESCRIPTION SENDER SHARED WITH ACTION Tags
' . $row[2] . ' ' . $row[5] . ' ' . $row[4] . ' ' . $owner . 'sent ' . $shared_with . ' share ' . $shared_with_info . ' ' . $tags . '
' . $row[2] . ' ' . $row[5] . ' ' . $row[4] . ' ' . $owner . 'sent ' . $shared_with . ' ' . $tags . '
'; pg_free_result($stmt); $stmt1 = pg_query_params($conn, "SELECT login_email, first_name FROM health.view_patient_connected where login_email <> $1 and company_id=$2", array($_SESSION['smiley_uid'], $_SESSION['smiley_cid'])); if (!$stmt1) { echo "An query error occurred.\n"; echo pg_last_error($conn); exit; } $users_list = ''; while ($row1 = pg_fetch_row($stmt1)) { $users_list = $users_list . ''; } echo ' ' . $users_list . ' '; pg_free_result($stmt1); } pg_close($conn); ?>