我想如果一个下拉选项被选中我的下拉菜单不能工作,如果你点击提交。所以在我的下拉菜单上填充的其他东西,不能添加到MySQL。
我该怎么做?我尝试了几个我在网上找到的选项,但它不起作用。因此,如果选择了值day,它将无法工作如果选择值month,则无法工作如果选择值year,则无法工作。
所有其他选项都可以工作!
这是我的表单:
<form action="e2admin.php" method="post">
<div class="input-group">
<select name="dag">
<option value="day">Dag</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="Month">
<option value="maand">Maand</option>
<option value="1">Januari</option>
<option value="2">Februari</option>
<option value="3">Maart</option>
<option value="4">April</option>
<option value="5">Mei</option>
<option value="6">Juni</option>
<option value="7">Juli</option>
<option value="8">Augustus</option>
<option value="9">September</option>
<option value="10">Oktober</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="year">
<option value="jaar">Jaar</option>
<option value="1">2014</option>
<option value="2">2015</option>
<option value="3">2016</option>
<option value="4">2017</option>
</select><br>
<select name="thuisteam1">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select>
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scorethuis1" placeholder="0" />
-
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scoreuit1" placeholder="0" />
<select name="uitteam1">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select><br>
<select name="thuisteam2">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select>
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scorethuis2" placeholder="0" />
-
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scoreuit2" placeholder="0" />
<select name="uitteam2">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select><br>
<select name="thuisteam3">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select>
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scorethuis3" placeholder="0" />
-
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scoreuit3" placeholder="0" />
<select name="uitteam3">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select><br>
<select name="thuisteam4">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select>
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scorethuis4" placeholder="0" />
-
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scoreuit4" placeholder="0" />
<select name="uitteam4">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select><br>
<select name="thuisteam5">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select>
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scorethuis5" placeholder="0" />
-
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scoreuit5" placeholder="0" />
<select name="uitteam5">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select><br>
<select name="thuisteam6">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select>
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scorethuis6" placeholder="0" />
-
<input onKeyPress="return alpha(event)" style="width:20px; text-align:center;" type="text" maxlength="2" class="form-control" name="scoreuit6" placeholder="0" />
<select name="uitteam6">
<option value=""></option>
<?php
mysql_data_seek($result, 0);
if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['Team'] . '">' . $row['Team'] . '</option>';
}
}
?>
</select><br>
<input style="margin-left:330px;" type="submit" class="form-control" value="Toevoegen" />
</div>
</form>
试试这个像这样使用jquery
$("#check").click(function(e){
if($("[name=dag]").val() == "day")
{
alert("day is selected");
return false;
}
else if($("[name=Month]").val() == "maand")
{
alert("maand is selected");
return false;
}
});
在html
的<head>
中添加这一行<script type="text/javascript" src="http://code.jquery.com/jquery-1.10.2.min.js"></script>
演示像这样?
<select name="dag" style="">
<option disabled="" selected="">Dag</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<!-- ...and so on... -->
</select>
即使它们看起来像被禁用了,它们仍然显示,但你不能选择它们。这意味着,用户被迫选择一些东西。
其余的必须在JS或你验证你的形式之前,你把它写进数据库。你喜欢:
if(empty($_POST['month']) || empty($_POST['day'])){
echo "ERROR AT DATE";
}else{
//HANDLE POST REQUEST
}
可以在这里找到一个例子:http://jsfiddle.net/Ye88R/
你总是可以使用禁用的value=",它不会让你发送。
<form method="POST">
<select required>
<option disabled value="">Day</option>
<option>1</option>
<option>2</option>
</select>
<button type="submit">Send</button>
</form>