且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将html选择表单的值插入到mysql数据库中

更新时间:1970-01-01 07:56:06

您必须将选择标记包装到表单标记中。

 < form action =''method ='post'> 
< select name =myselectbox>
< option name =myoption1value =myoption1> myoption1< / option>
< option name =myoption2value =myoption2> myoption2< / option>
< option name =myoption3value =myoption3> myoption3< / option>
< option name =myoption4value =myoption4> myoption4< / option>
< / select>
< input type ='submit'value ='submit'/>
< / form>

一旦您提交表单,您将获得后变量为 $ _ POST ['myselectbox'] 可以像你已经做的那样附加到mysql查询中。但为更好的方式不只是追加它,但检查表单提交和后附加变量是否可用。
例如:

  if(!empty($ _ POST ['myselectbox'])){
/ * ...做你的查询部分... * /
}


I want to insert the value of a selected 'select form' into my mysql database.

How can i get the right value of this?

<form action='' method='post'>
 <select name="myselectbox">
  <option name="myoption1" value="myoption1">myoption1</option>
  <option name="myoption2" value="myoption2">myoption2</option>
  <option name="myoption3" value="myoption3">myoption3</option>
  <option name="myoption4" value="myoption4">myoption4</option>
 </select>
<input type='submit' value='submit'/>
</form>

something like that? (this one didn't work obviously..)

$sql = "INSERT INTO Entries (myoption1) VALUES ('$_POST[myselectbox]')";

you have to wrap your select tag into a form tag .

<form action='' method='post'>
<select name="myselectbox">
   <option name="myoption1" value="myoption1">myoption1</option>
   <option name="myoption2" value="myoption2">myoption2</option>
   <option name="myoption3" value="myoption3">myoption3</option>
   <option name="myoption4" value="myoption4">myoption4</option>
</select>
<input type='submit' value='submit'/>
</form>

once you submit the form, you will get the post variable as $_POST['myselectbox'] that could be appended into a mysql query as you have already did. but for a better way dont just append it like that but check the form is submitted and post variables are available or not before appending. eg:

if(!empty($_POST['myselectbox'])){
    /*.. do your query section... */
}