php script to echo html form

7 replies
please i need help on this i am trying to echo HTML form in php script but i am having a logical error, the html checkbox control displays first before the variable $Question displays i dont understand why.

this is my code

<form action = "calculateResult.php" method = "post">
<?php

$con=mysqli_connect("localhost","root","","online_ exam");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM question");
//$AnsResult = mysqli_query($con,"SELECT * FROM answers");

$i = 1;
while($row = mysqli_fetch_array($result))
{
$i = $i + 1;
$question = $row['Quest'];
print("$question");
echo '<br/>';
$Q1 = $row['answer1'];
$Q2 = $row['answer2'];
$Q3 = $row['answer3'];
$Q4 = $row['answer4'];

echo '<input type = "checkbox" value = "hi" name = "answers"/>'.$Q1;
echo '<br/>';
echo '<input type = "checkbox">'.$Q2;
echo '<br/>';
echo '<input type = "checkbox">'.$Q3;
echo '<br/>';
echo '<input type = "checkbox">'.$Q4;
echo '<br/>';

}
mysqli_close($con);
?>
<input type = "submit" value = "SUBMIT"/>
</form>





this statement print("$question"); is suppose to execute before this other statements but the echo '<input type = "checkbox" value = "hi" name = "answers"/>'.$Q1; execute before the print("$question"); statement that is what i mean
echo '<input type = "checkbox" value = "hi" name = "answers"/>'.$Q1;
echo '<br/>';
echo '<input type = "checkbox">'.$Q2;
echo '<br/>';
echo '<input type = "checkbox">'.$Q3;
echo '<br/>';
echo '<input type = "checkbox">'.$Q4;
echo '<br/>';
#echo #form #html #php #script
  • Profile picture of the author Andrew H
    Because you are echo'ing out the checbbox input before the question


    echo $Q1.'<input type = "checkbox">';


    The questions you are asking are insanely simple (looking at your other question as well). Your script is broken in many other ways as well, learn some PHP (it's simple, i promise) before asking too many more question.
    Signature
    "You shouldn't come here and set yourself up as the resident wizard of oz."
    {{ DiscussionBoard.errors[8657590].message }}
    • Profile picture of the author lloydblinks
      this statement print("$question"); is suppose to execute before this other statements but the echo '<input type = "checkbox" value = "hi" name = "answers"/>'.$Q1; execute before the print("$question"); statement that is what i mean
      echo '<input type = "checkbox" value = "hi" name = "answers"/>'.$Q1;
      echo '<br/>';
      echo '<input type = "checkbox">'.$Q2;
      echo '<br/>';
      echo '<input type = "checkbox">'.$Q3;
      echo '<br/>';
      echo '<input type = "checkbox">'.$Q4;
      echo '<br/>';
      {{ DiscussionBoard.errors[8658833].message }}
  • Profile picture of the author Andrew H
    Not really sure what you are saying the problem is. Here is a good resource: PHP: Hypertext Preprocessor
    Signature
    "You shouldn't come here and set yourself up as the resident wizard of oz."
    {{ DiscussionBoard.errors[8659821].message }}
  • Profile picture of the author KirkMcD
    Are you sure the data in the table "question" is correct?
    {{ DiscussionBoard.errors[8661420].message }}
  • Profile picture of the author David Beroff
    Why are you mixing print and echo? There doesn't seem to be any reason for this. See this comment in the documentation.
    Signature
    Put MY voice on YOUR video: AwesomeAmericanAudio.com
    {{ DiscussionBoard.errors[8662356].message }}
  • Profile picture of the author drem
    I believe what you are saying is that for some reason print("$question"); prints after all of the rest. This would occur when the $row['Quest'] is null. So, during the first loop there is nothing inside of it to print. After, it goes into the loop again and prints out whatever is in the array.

    Otherwise, supply some more data so we can figure out what is going on.
    {{ DiscussionBoard.errors[8663118].message }}
  • {{ DiscussionBoard.errors[8663912].message }}

Trending Topics