将html选择表单的值插入到mysql数据库中 [英] insert value of html select form into mysql database

问题描述

我怎么才能得到这个正确的值？

我想将所选的'选择表单'的值插入到我的mysql数据库中。

 < 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> 
  

类似的东西？ （这一个没有明显的工作..）

$ pre $ code = $ sql =INSERT INTO条目（myoption1）VALUES（'$ _POST [myselectbox]'）;

解决方案

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

 < 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... */
}

这篇关于将html选择表单的值插入到mysql数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！