form page

<?php
$servername = "localhost";
$username = "plandvmg_sam";
$password = "testing123";
$dbname = "plandvmg_seedtraders";

$conn = new mysqli($servername, $username, $password, $dbname);
?>

<form action="/process.php" method="post">

<select name="plant_type">
<?php

$result=mysqli_query($conn, "SELECT name FROM plant_type");
while($row=mysqli_fetch_array($result))

{
?><option><?php echo $row["name"]; ?></option>

<?php

}

?>
</select><br />
<label id="plant_name">Plant name<input name="plant_name" type="text" /></label><br />

<label id="annual_perennial"><input value="Annual" name="annual_perennial[]" type="checkbox" />Annual<input value="Perennial" name="annual_perennial[]" type="checkbox" />Perennial<input value="Biennial" name="annual_perennial[]" type="checkbox" />Biennial</label><br />

<label id="edible">Edible? <input value="Yes" name="edible[]" type="checkbox" />Yes <input value="No" name="edible[]" type="checkbox" />No</label><br />

<label id="medicinal">Medicinal? <input value="Yes" name="medicinal[]" type="checkbox" />Yes <input value="No" name="medicinal[]" type="checkbox" />No</label><br />

<label id="zone">What zone?<br />
1a<input name="zone[] "value="1a" type="checkbox" />
1b<input name="zone[] "value="1b" type="checkbox" />
2a<input name="zone[] "value="2a" type="checkbox" />
2b<input name="zone[] "value="2b" type="checkbox" />
3a<input name="zone[] "value="3a" type="checkbox" />
3b<input name="zone[] "value="3b" type="checkbox" />
4a<input name="zone[] "value="4a" type="checkbox" />
4b<input name="zone[] "value="4b" type="checkbox" />
5a<input name="zone[] "value="5a" type="checkbox" />
5b<input name="zone[] "value="5b" type="checkbox" />
6a<input name="zone[] "value="6a" type="checkbox" />
6b<input name="zone[] "value="6b" type="checkbox" />
7a<input name="zone[] "value="7a" type="checkbox" />
7b<input name="zone[] "value="7b" type="checkbox" /> <br />
8a<input name="zone[] "value="8a" type="checkbox" />
8b<input name="zone[] "value="8b" type="checkbox" />
9a<input name="zone[] "value="9a" type="checkbox" />
9b<input name="zone[] "value="9b" type="checkbox" />
10a<input name="zone[] "value="10a" type="checkbox" />
10b<input name="zone[] "value="10b" type="checkbox" />
11a<input name="zone[] "value="11a" type="checkbox" />
11b<input name="zone[] "value="11b" type="checkbox" />
12a<input name="zone[] "value="12a" type="checkbox" />
12b<input name="zone[] "value="12b" type="checkbox" />
13a<input name="zone[] "value="13a" type="checkbox" />
13b<input name="zone[] "value="13b" type="checkbox" />

}
</label>
<br />
<label id="invasive">Invasive?</label><input value="Yes" name="invasive[]" type="checkbox" />Yes<input value="No" name="invasive[]" type="checkbox" />No
<br />
Plant Notes<br />
<textarea name="notes" cols="75" rows="10"></textarea>
<br />
<input name="Submit1" type="submit" value="submit" />
</form>