Online PHP editor | refs for 2emfO

<?php include_once("../includes/db_connect.php"); $topic = $_POST['topic']; $query = $mysqli->query("select * from topic_answer where topic_name = '$topic' "); echo "<form action='#' method='POST'>"; echo '<input type="hidden" name="topic" value="' . $topic . '"/>'; echo '<label> Question </label>'; echo '<input type="text" id="Question" name="Question">'; echo '<br>'; echo '<label> is this a yes or no response? </label>'; echo '<select name="yes_no"> <option value=""></option> <option value="yes">yes</option> <option value="no">no</option> </select> '; echo '<br>'; echo '<label> Parent question </label>'; echo "<select name='parent'>"; while($obj = $query->fetch_object()){ echo $obj->id; echo "<br>"; echo $obj->topic_name; echo "<br>"; echo $obj->topic_question; echo "<br>"; echo "<option value='" . $obj->id . "'>" . $obj->topic_question . "</option>"; } echo '</select>'; echo '<button type="submit" name="submit" id="submit" value="submit">Submit</button>'; echo "</form>"; echo "<br>"; if(isset($_POST['submit'])){ $question = isset($_POST['Question']); $yes_no = isset($_POST['yes_no']); $parent = isset($_POST['parent']); if(empty($question)){ echo "error: question not set"; var_dump($question); }elseif(empty($yes_no)){ echo "error: yes or no not set"; } elseif(empty($parent)){ echo "error: parent not set"; } else{ $question = $_POST['Question']; $yes_no = $_POST['yes_no']; $parent = $_POST['parent']; if($yes_no === "yes"){ $yes = 1; $no = 0; }else{ $yes = 0; $no = 1; } $creator = "jordan"; $start = 0; $end = 0; var_dump($question); var_dump($yes_no); var_dump($parent); $insert = $mysqli->prepare("INSERT INTO topic_answer (topic_name, topic_creator, topic_question, load_yes, start, load_no, end, parent) values(?,?,?,?,?,?,?,?)"); $insert->bind_param('sssiiiii', $topic, $creator ,$question,$yes,$start,$no,$end,$parent); $insert->execute(); $insert->close(); } }