循环从 PHP 中的下拉列表中获取值
get values from dropdown list in php in a loop?
我也想从下拉列表和值索引中获取值。每次循环以不同的长度运行，例如一次循环运行 5 次并创建 5 行。下一次可能是 30 次并创建 30 行。每行有 2 个下拉列表。请帮助我如何获取每个下拉列表和索引的值。这是代码：
'
<div>
<form name="viewdata" method="post" onChange="this.form.submit()">
<table>
<tr colspan=2>
<td><input type="checkbox" name="BSSE" value="BSSE" >BSSE      </input></td>
<td><input type="checkbox" name="BCS" value="BCS" >      BCS      </input></td>
<td><input type="checkbox" name="BSTN" value="BSTN" >      BSTN      </input></td>
</tr>
<tr>
<td><input type="checkbox" name="MTH" value="MTH" >MTH      </input></td>
<td><input type="checkbox" name="MGT" value="MGT" >      MGT      </input></td>
<td><input type="checkbox" name="EEE" value="EEE" >      EEE      </input></td>
<td><input type="checkbox" name="CSC" value="CSC" >      CSC      </input></td>
<td><input type="checkbox" name="HUM" value="HUM" >      HUM      </input></td>
</tr>
<tr>
<td>
<button type="submit" class="btn btn-success btn-sm">View</button>
</td>
</tr>
</table>
</form>
</div>
<form method = "post">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<?php
$programs_title = array();
$programs_id = array();
$courses_title = array();
$courses_id = array();
$classes = array();
$time_table = array();
$sections_id = array();
$faculty_selected_course = array();
$allocation1 = array();
$allocation2 = array();
$course_loop_array = array();
if(isset($_POST['BSSE'])) {$programs_title[]=$_POST['BSSE'];}
if(isset($_POST['BCS'])) {$programs_title[]=$_POST['BCS'];}
if(isset($_POST['BSTN'])) {$programs_title[]=$_POST['BSTN'];}
if(isset($_POST['MTH'])) {$courses_id[]=$_POST['MTH'];}
if(isset($_POST['MGT'])) {$courses_id[]=$_POST['MGT'];}
if(isset($_POST['EEE'])) {$courses_id[]=$_POST['EEE'];}
if(isset($_POST['CSC'])) {$courses_id[]=$_POST['CSC'];}
if(isset($_POST['HUM'])) {$courses_id[]=$_POST['HUM'];}
$conn = mysql_connect("localhost","root","") or die ("cannot connect");
mysql_select_db('dims') or die("cannot connect to database");
$sql = "SELECT * FROM `user` WHERE email_id='hhh@comsats.edu.pk'";
$result = mysql_query($sql);
while($row1 = mysql_fetch_array($result)){
$other_faculty[] = $row1['first_name'];
}
foreach ($programs_title as $prog) {
$sql = "SELECT * FROM program WHERE program_title = '$prog'";
$result1 = mysql_query($sql);
if(is_null($result1)){
echo die(mysql_error());
}
while($row = mysql_fetch_array($result1)){
$programs_id[] = $row['program_id'];
}
}
foreach ($programs_id as $prog_id) {
$sql = "SELECT * FROM time_table WHERE program_id = '$prog_id'";
$result = mysql_query($sql);
if(is_null($result)){
echo die(mysql_error());
}
while($row = mysql_fetch_array($result)){
if(is_array($sections_id)){
if(!in_array($prog_id."-".$row['section_id'],$sections_id)){
$sections_id[] = $prog_id."-".$row['section_id'];
}
}
else{
$sections_id[] = $prog_id."-".$row['section_id'];
}
}
}
$section_loop = 1;
foreach ($sections_id as $class) {
$courses = array();
$split = preg_split('/-/', $class);
$program = $split[0];
$section = $split[1];
$sql = "SELECT * FROM time_table WHERE program_id = '$program' AND section_id = '$section'";
$result = mysql_query($sql);
if(is_null($result)){
echo die(mysql_error());
}
while($row = mysql_fetch_array($result)){
if(is_array($courses)){
if(!in_array($row['course_code'], $courses)){
$courses[] = $row['course_code'];
}
}
else{
$courses[] = $row['course_code'];
}
}
$sql = "SELECT * FROM program WHERE program_id = '$program'";
$result = mysql_query($sql);
if(is_null($result)){
echo die(mysql_error());
}
while($row = mysql_fetch_array($result)){
$program = $row['program_title'];
}
$sql = "SELECT * FROM section WHERE section_id = '$section'";
$result = mysql_query($sql);
if(is_null($result)){
echo die(mysql_error());
}
while($row = mysql_fetch_array($result)){
$section = $row['section_title'];
}
if(!in_array($program."-".$section, $classes)){
$classes[] = $program."-".$section;
}
/*foreach ($courses_id as $course) {
if(!in_array($program."-".$section."-".$course, $time_table)){
$time_table[] = $program."-".$section."-".$course;
}
}*/
?>
<thead>
<tr class="odd gradeX">
<th colspan=6><?php echo $program."-".$section."<br>"; ?></th>
</tr>
<tr class="odd gradeX">
<th>#</th>
<th>Course Code</th>
<th>Course Title</th>
<th>Class/Lab</th>
<th>Faculty</th>
<th>Other Faculty</th>
</tr>
</thead>
<?php
$course_loop =1;
foreach ($courses as $course) {
unset($faculty_selected_course);
if($course!='JUMMA'){
foreach ($courses_id as $value) {
if(stristr($course, $value)){ ?>
<tbody>
<?php
$sql = "SELECT * FROM course WHERE course_code='$course'";
$result2 = mysql_query($sql);
if(is_null($result2)){
echo die(mysql_error());
}
while($row2 = mysql_fetch_array($result2)){
$course_title = $row2['course_title'];
$course_credit_hour = $row2['course_credit_hour'];
}
$sql = "SELECT * FROM faculty_course_choice WHERE course_choice1='$course' OR course_choice2='$course' OR course_choice3='$course'";
$result3 = mysql_query($sql);
if(is_null($result3)){
echo die(mysql_error());
}
while($row3 = mysql_fetch_array($result3)){
if($course == $row3['course_choice1']){
$course_priority = 1;
$user = $row3['user_id'];
}
elseif($course == $row3['course_choice2']){
$course_priority = 2;
$user = $row3['user_id']."<br>";
}
elseif($course == $row3['course_choice3']){
$course_priority = 3;
$user = $row3['user_id']."<br>";
}
$sql = "SELECT * FROM `user` WHERE user_id='$user'";
$result4 = mysql_query($sql);
while($row4 = mysql_fetch_array($result4)){
$faculty_selected_course[] = $course_priority."::".$row4['first_name'];
}
}
again:
?>
<tr class="odd gradeX">
<th><?php echo $course_loop++; ?></th>
<th><?php echo $course; ?></th>
<th><?php echo $course_title; ?></th>
<th><?php
if($course_credit_hour==3){
echo "Class";
$allocation1 [] = $program."-".$section."-".$course."-Class";
$allocation2 [] = $program."-".$section."-".$course."-Class";
}
elseif($course_credit_hour==4){
echo "Lab";
$allocation1 [] = $program."-".$section."-".$course."-Lab";
$allocation2 [] = $program."-".$section."-".$course."-Lab";
$course_credit_hour--; ?>
</th>
<th>
<select name= "allocation1[]" class="form-control ">
<option>Select Faculty</option>
<?php
foreach ($faculty_selected_course as $faculty) { ?>
<option><?php echo $faculty; ?></option>
<?php
}
?>
</select>
</th>
<th>
<select name= "allocation2[]" class="form-control ">
<option>Select Other Faculty</option>
<?php
foreach ($other_faculty as $otherfaculty) { ?>
<option><?php echo $otherfaculty; ?></option>
<?php
}
?>
</select>
</th>
</tr>
<?php goto again;
}
?>
</th>
<th>
<select name= "allocation1[]" class="form-control ">
<option>Select Faculty</option>
<?php
foreach ($faculty_selected_course as $faculty) { ?>
<option><?php echo $faculty; ?></option>
<?php
}
?>
</select>
</th>
<th>
<select name= "allocation2[]" class="form-control ">
<option>Select Other Faculty</option>
<?php
foreach ($other_faculty as $otherfaculty) { ?>
<option><?php echo $otherfaculty; ?></option>
<?php
}
?>
</select>
</th>
</tr>
<?php
}
}
}
}
$get_index = $program."-".$section."-".$course_loop;
$course_loop_array [] = $get_index;
}
?>
<tr>
<th colspan="7" >
<button type="submit" class="btn btn-success btn-sm">Allocate</button>
</th>
</tr>
</tbody>
</table>
</form>
<?php
if(isset($_POST['allocation1'])){
$output = count($_POST['allocation1']);
echo $output;
foreach ($_POST['allocation1'] as $value) {
if($value == 'Select Other Faculty' OR $value == 'Select Faculty'){
}
else{
echo $value."<br>";
}
}
}
$allocation1 = $_POST['allocation1'];
foreach ($allocation1 as $value) {
echo $value."<br>";
}
foreach ($course_loop_array as $lue) {
echo $lue."<br>";
}
?>
</div>'
循环结束
'
应从name属性值中删除美元符号，并为两列使用不同的名称：
<select name="allocation1[]" ...
<select name="allocation2[]" ...
然后，当用户提交表单时，您可以访问：
$allocations1 = $_POST['allocation1'];
$allocations2 = $_POST['allocation2'];
这些数组的索引表示行号减 1（因为它从零开始）。
不完全确定您要问什么，但代码应该看起来像这样才有意义：
<th>
<select name="first_allocation[<?=$rowId?>]">
<option>Select Faculty</option>
<? foreach ($faculties as $faculty) { ?>
<option value="<?=$faculty?>"><?=$faculty?></option>
<? } ?>
</select>
</th>
<th>
<select name="second_allocation[<?=$rowId?>]">
<option>Select Other Faculty</option>
<? foreach ($faculties as $faculty) { ?>
<option value="<?=$faculty?>"><?=$faculty?></option>
<? } ?>
</select>
</th>
这样，当用户提交表单时，您将收到如下内容：
$_POST = array(
'first_allocation' = array(
232 => 'BCS-IIIB-CSC509-Class',
372 => 'BCS-IIIB-CSC509-Class',
// ...
),
'second_allocation' = array(
232 => 'BCS-IIIB-CSC509-Class',
372 => 'BCS-IIIB-CSC509-Class',
// ...
),
);
其中 232 和 373 是各自的 $rowId 值，在外部循环的每次迭代中都会发生变化。
如果您已经拥有选定的院系并希望将它们标记为这样，请使用以下内容：
<option value="<?=$faculty?>"<?=($first_allocation[$rowId] === $faculty ? ' selected' : '')?>>
<?=$faculty?>
</option>
这可能是你所追求的
主文件，也许是"mainListOfStuff.php"你可以有这样的东西
<form action="processForm.php" method="post">
<table>
<tr>
<th>Main faculty members</th>
<th>Other factulty members</th>
</tr>
<!-- Start of your loop for table rows -->
<?php
// YOUR LOOP FOR THE ROWS OF THE TABLE
// My example loop for this explanation: for (var $i = 0; $i < count([SOME LENGTH OF ROWS]); $i++) {
// My example start of row: echo "<tr>";
?>
<td>
<select name="allocationMain[]" class="form-control mainFaculty">
<option selected value="0">Not from this faculty</option>
<?php
foreach ($faculty_selected_course as $faculty) {
echo "<option value='"". $faculty ."'">". $faculty ."</option>";
}
?>
</select>
</td><td>
<select name="allocationOther[]" class="form-control otherFaculty">
<option selected value="0">Not from this faculty</option>
<?php
foreach ($other_faculty as $otherfaculty) {
echo "<option value='"". $otherfaculty ."'">". $otherfaculty ."</option>";
}
?>
</select>
</td>
<!-- End of your loop for table rows -->
<?php
// My example end of row: echo "<tr>";
}
?>
</table>
</form>
你可以清理上面的页面"mainListOfStuff.php"，方法是在有人交换选择框时将选定的答案交换为"不是来自这个教师"
<script>
$(function() {
$("select.otherFaculty").on("change keyup", function(){ // If they choose something in a row in the other faculty
// Then change the main select to the first "0" value option
$(this).closest("tr").find("select.mainFaculty").val(0);
});
$("select.mainFaculty").on("change keyup", function(){
$(this).closest("tr").find("select.otherFaculty").val(0);
});
});
</script>
上面的代码示例在这里> https://jsfiddle.net/9n4ypboj/
然后在 processForm 中.php你这样做：
<?php
if (!isset($_POST["allocationMain"])) exit(); // If no data was submitted then stop the php script here.
$mainAllocations = $_POST["allocationMain"]; // Both of these arrays should be the same length
$otherAllocations = $_POST["allocationOther"]; // if the form was submitted properly
$chosenAllocations = [];
for( $i = 0; $i < count($mainAllocations); $i++ ) {
if ( $mainAllocations[$i] == 0 ) { // If they have not selected "Not from this faculty" for the main select column,
// then select the value in the other select column
$chosenAllocations[$i] = $otherAllocations[$i];
} else {
$chosenAllocations[$i] = $mainAllocations[$i];
}
}
// Use the $chosenAllocations for the rest of your PHP processing
?>
相关文章：
- 如何使用JavaScript/JQuery获取下拉列表的选定值
- jQuery 设置和获取下拉列表和输入的本地存储数据
- 如何获取下拉列表的默认值
- 从动态生成的输入字段中获取下拉列表中的数据，而无需保存值 - jquery
- 获取下拉列表的选定值
- 如何在与MySQL数据库相同的PHP页面中获取下拉列表的值
- 从数组 Jquery 中获取下拉列表的选定索引
- 如何获取按键值以获取下拉列表中的 TAB 键代码
- 获取下拉列表的选定 id
- 如何使用jquery获取下拉列表的选定选项值
- RadGrid-使用javascript获取下拉列表索引
- 按值获取下拉列表/组合框的索引(客户端）
- 在angularjs中无法获取下拉列表的值
- 在javascript中获取下拉列表值
- 没有使用angular.js获取下拉列表的默认选择值
- 从c#对象列表中获取下拉列表选择选项
- 在JQuery中使用名称获取下拉列表值
- 不能使用jquery获取下拉列表项的值
- 基于选定的第一个下拉列表获取下拉列表的值
- 获取下拉列表的值，而不仅仅是ID
