$symptom_true = 1; update_symptom($symptom_true, $symptom, $table_urgent); } else { $notUrgent = $notUrgent + 1; update_parameter($notUrgent, $col_notUrgent, $table_general); $symptom_true = 1; update_symptom($symptom_true, $symptom, $table_notUrgent); } } $question_id = $question_id + 1; update_parameter($question_id, $col_qID, $table_general); } elseif ($question_id > $number_rows) { $id = $id + 1; update_parameter($id, $col_ID, $table_general); $question_id = $question_id = 1; update_parameter($question_id, $col_qID, $table_general); $use_table = $animal_table; update_table($use_table); header('Refresh: 0; url=question.php'); // refresh the page } } } else { header("Location: result_system.php"); //go to result page exit; } echo ' </div> <button class="play"></button> <button class="pause"></button>
$query = "SELECT notUrgent FROM {$table_general}"; $stmt = $con->prepare($query); $stmt->execute(); $notUrgent = $stmt->fetchColumn(); //print $notUrgent; $query = "SELECT urgent FROM {$table_general}"; $stmt = $con->prepare($query); $stmt->execute(); $urgent = $stmt->fetchColumn(); //print $urgent; if ($notUrgent >= 3 and $urgent == 1 or $urgent > 1) { $toVeterinarian_decision = 1; update_parameter($toVeterinarian_decision, $col_decision, $table_general); } else { $toVeterinarian_decision = 0; update_parameter($toVeterinarian_decision, $col_decision, $table_general); } if ($toVeterinarian_decision == 1) { print "<p>It is recommended to visit a veterinarian.</p>"; echo '<p>To contact one: press blue for yes, or yellow for no.</p>'; echo '<form action="contact.php">'; echo '<button type="submit" id="vet_blue"></button>'; echo '</form>'; echo '<form method="get" action="final.php">'; echo '<button type="submit" id="vet_yellow"></button>'; echo '</form>'; echo '<script> $(document).ready(function() { var audioElement = document.createElement("audio"); audioElement.setAttribute("src", "sounds/visitVet.mp3"); audioElement.setAttribute("autoplay", "autoplay");