如何将下拉菜单数据写入MySQL数据库[重复]

Question

This question already has an answer here:

• “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP 28 answers

Currently trying to write data from my dropdown menu to a field on my database. All the text fields are populating perfectly, but not sure why the drop down data isn't.

This is my code:

</div>

Answer 1

You have invalid syntax here.

$returned = $_POST['returned']; // This returns null.

You can always change your loans table of the $returned field to nullable.

OR, you can just fix it by replacing..

<select>
  <option value="No"> No </option>
  <option value="Yes"> Yes</option>
</select>

To

<select name="returned">
  <option value="No"> No </option>
  <option value="Yes"> Yes</option>
</select>