复选框、表单提交以及如何在循环中正确使用数组填充？

5w9g7ksd  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(342)

我有一个表单，用户可以在其中对评分尺度进行一些更改。他们还可以选择将这些更改应用于一个或多个记录（类节号）。以下是我的表格截图以及下面的代码：

单击复选框时，需要使用复选框中的每个节号将表单中的数据插入数据库。由于checkbox数组只包含3个值，因此它没有完成所有节号行的插入。在我的代码中，您会看到我尝试使用array\u fill，但我显然没有正确地使用它或在正确的位置使用它。
这是我提交表单前数据库表的正确外观：http://sqlfiddle.com/#!2015年9月20日
这是我提交表单后数据库表的外观：http://sqlfiddle.com/#!2015年9月40日
下面是给我带来问题的变量的测试输出（$sectionnumber）：

5011 is SectionNumber
5013 is SectionNumber
5099 is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
5011 is SectionNumber
5013 is SectionNumber
5099 is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
5011 is SectionNumber
5013 is SectionNumber
5099 is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber
is SectionNumber

我需要/期望输出显示“5011 is sectionnumber”重复11次，然后是“5013 is sectionnumber”，最后是“5099 is sectionnumber”11次。

html表单：

https://jsfiddle.net/keusv75a/

<form action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="post" name="snum">
   <p>
      Select the section for which you'd like to display the grading scale below:<br />
      <select name="snum">
         <?php
            $stmt4 = $connection->prepare("SELECT DISTINCT c.SectionNumber FROM Courses c, Assignments a WHERE a.SectionNumber = c.SectionNumber
            ") or die($connection->error);
            $stmt4->execute();
            $result4 = $stmt4->get_result();

            while ($row4 = $result4->fetch_assoc()):
            ?>
         <option value="<?php echo $row4['SectionNumber']; ?>" <?php
            if ($_POST['snum'] == $row4['SectionNumber']) {
                echo "selected";
            } ?>><?php echo $row4['SectionNumber']; ?></option>
         <?php
            endwhile; ?> 
      </select>
      <input class="btn btn-sm btn-primary" type="submit" value="Show Me">
   </p>
</form>
<form action="admin_grading_scale2.php" method="post">
   <p>Which section(s) would you like to apply this grading scale to?<br>
      <?php $stmt4 = $connection->prepare("SELECT DISTINCT SectionNumber FROM Courses
         ") or die($connection->error);
         $stmt4->execute();
         $result4 = $stmt4->get_result();

                      while ($row4 = $result4->fetch_assoc()):
         ?>
      <label>
      <input type="checkbox" name="SectionNumber[]" value="<?=$row4['SectionNumber'];?>" id="SectionNumber[]"><?=$row4['SectionNumber'];?></label>
      <?php endwhile; ?>
   </p>
   <div class="form-inline">
   <table class="table table-striped">
      <thead>
         <tr class="table-text-center">
            <th scope="col"> Letter Grade</th>
            <th scope="col">Percent Toward Grade</th>
            <th scope="col">Avg Steps/Day</th>
            <th scope="col">Average Active Minutes/Week</th>
         </tr>
      </thead>
      <tbody>
         <?php
            while ($row = $result->fetch_assoc()) {
            $id = $row['id'];
            $letter = $row['letter'];
            $AssignmentID = $row['AssignmentID'];
            $percent = $row['percent'];
            $avgsteps = $row['avgsteps'];
            $avgweeklymin = $row['avgweeklymin'];
            $section = $row['section']; 
             ?>
         <input name="id[]" type="hidden" value="<?php echo "$id"; ?>"/>
         <input name="section[]" type="hidden" value="<?php echo "$section"; ?>"/>
         <input name="AssignmentID[]" type="hidden" value="<?php echo "$AssignmentID"; ?>"/>
         <tr class="table-text-center">
            <td>
               <div class="col-sm-10">
                  <input type="text" class="form-control" id="letter" name="letter[]" aria-describedby="letter" placeholder="Grade" value="<?php echo "$letter"; ?>"> 
               </div>
            </td>
            <td>
               <div class="col-sm-10">
                  <input type="text" class="form-control" id="percent" name="percent[]" aria-describedby="percent" placeholder="Percent" value="<?php echo "$percent"; ?>"> 
               </div>
            </td>
            <td>
               <div class="col-sm-10">
                  <input type="text" class="form-control" id="avgsteps" name="avgsteps[]" aria-describedby="points" placeholder="Average Steps" value="<?php echo "$avgsteps"; ?>"> 
               </div>
            </td>
            <td>
               <div class="col-sm-10">
                  <input type="text" class="form-control" id="avgweeklymin" name="avgweeklymin[]" aria-describedby="avgweeklymin" placeholder="Average Weekly Activity Minutes" value="<?php echo "$avgweeklymin"; ?>"> 
               </div>
            </td>
         </tr>
         <?php } ?>
      </tbody>
   </table>
   <input class="btn btn-lg btn-primary btn-block" type="submit" value="Save Changes">
</form>

php代码：

$size = count( $_POST[ 'id' ] );
$numofsections = count( $_POST[ 'SectionNumber' ] );

$stmt = $connection->prepare( "INSERT INTO GradingScale SET letter=?,percent=?,avgsteps=?,avgweeklymin=?,section=?,AssignmentID=? ON DUPLICATE KEY UPDATE letter=?,percent=?,avgsteps=?,avgweeklymin=?,section=?,AssignmentID=?" );

for($x = 0; $x < $numofsections; $x++):

    $SectionNumber = array_fill(0, $size, $_POST['SectionNumber'][$x]);

$i = 0;
while ( $i < $size ) {
    // define each variable 
    $id = filter_var( $_POST[ 'id' ][ $i ], FILTER_SANITIZE_NUMBER_INT );
    $letter = filter_var( $_POST[ 'letter' ][ $i ], FILTER_SANITIZE_STRING );
    $percent = filter_var( $_POST[ 'percent' ][ $i ], FILTER_SANITIZE_NUMBER_INT );
    $avgsteps = filter_var( $_POST[ 'avgsteps' ][ $i ], FILTER_SANITIZE_NUMBER_INT );
    $avgweeklymin = filter_var( $_POST[ 'avgweeklymin' ][ $i ], FILTER_SANITIZE_NUMBER_INT );
    $AssignmentID = filter_var( $_POST[ 'AssignmentID' ][ $i ], FILTER_SANITIZE_NUMBER_INT );
    $SectionNumber = filter_var( $_POST[ 'SectionNumber' ][ $i ], FILTER_SANITIZE_STRING );
    echo $SectionNumber .  "  is SectionNumber<BR>"; 

    $stmt->bind_param( "siiisisiiisi", $letter,$percent, $avgsteps, $avgweeklymin, $SectionNumber, $AssignmentID, $letter,$percent, $avgsteps, $avgweeklymin, $SectionNumber, $AssignmentID);
    $stmt->execute();

    //$stmt2->bind_param( "iii", $PointsPossible, $SectionNumber, $AssignmentID );
    //$stmt2->execute();

    ++$i;
}
endfor;

数据库架构

CREATE TABLE `GradingScale` (
  `id` int(11) NOT NULL,
  `letter` enum('A','B','C','D','F') NOT NULL,
  `percent` smallint(4) NOT NULL,
  `avgsteps` smallint(6) NOT NULL,
  `avgweeklymin` smallint(4) NOT NULL,
  `section` varchar(8) NOT NULL,
  `AssignmentID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Grading Scale';

INSERT INTO `GradingScale` (`id`, `letter`, `percent`, `avgsteps`, `avgweeklymin`, `section`, `AssignmentID`) VALUES
(1, 'A', 100, 10000, 100, '5011', 1),
(2, 'A', 90, 9500, 90, '5011', 1),
(3, 'B', 80, 9000, 80, '5011', 1),
(4, 'C', 70, 8500, 70, '5011', 1),
(5, 'D', 60, 8000, 60, '5011', 1),
(6, 'F', 50, 7500, 50, '5011', 1),
(7, 'F', 40, 7000, 40, '5011', 1),
(8, 'F', 30, 6500, 30, '5011', 1),
(9, 'F', 20, 6000, 20, '5011', 1),
(10, 'F', 10, 5500, 10, '5011', 1),
(11, 'F', 0, 5000, 0, '5011', 1),
(12, 'A', 100, 10000, 100, '5013', 1),
(13, 'A', 90, 9500, 90, '5013', 1),
(14, 'B', 80, 9000, 80, '5013', 1),
(15, 'C', 70, 8500, 70, '5013', 1),
(16, 'D', 60, 8000, 60, '5013', 1),
(17, 'F', 50, 7500, 50, '5013', 1),
(18, 'F', 40, 7000, 40, '5013', 1),
(19, 'F', 30, 6500, 30, '5013', 1),
(20, 'F', 20, 6000, 20, '5013', 1),
(21, 'F', 10, 5500, 10, '5013', 1),
(22, 'F', 0, 5000, 0, '5013', 1),
(23, 'A', 100, 10000, 100, '5099', 1),
(24, 'A', 90, 9500, 90, '5099', 1),
(25, 'B', 80, 9000, 80, '5099', 1),
(26, 'C', 70, 8500, 70, '5099', 1),
(27, 'D', 60, 8000, 60, '5099', 1),
(28, 'F', 50, 7500, 50, '5099', 1),
(29, 'F', 40, 7000, 40, '5099', 1),
(30, 'F', 30, 6500, 30, '5099', 1),
(31, 'F', 20, 6000, 20, '5099', 1),
(32, 'F', 10, 5500, 10, '5099', 1),
(33, 'F', 0, 5000, 0, '5099', 1);

--
-- Indexes for table `GradingScale`
--
ALTER TABLE `GradingScale`
  ADD UNIQUE KEY `id` (`id`,`letter`,`percent`);

-- AUTO_INCREMENT for table `GradingScale`
--
ALTER TABLE `GradingScale`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
COMMIT;

任何帮助都将不胜感激！！！
提姆

mysqlArraysphpformsCheckBox

1条答案

按热度按时间
w7t8yxp5

w7t8yxp51#

本任务：

$SectionNumber = array_fill(0, $size, $_POST['SectionNumber'][$x]);

正在被这个覆盖：

$SectionNumber = filter_var( $_POST[ 'SectionNumber' ][ $i ], FILTER_SANITIZE_STRING );

我想你的意思是：

$SectionNumbers = array_fill(0, $size, $_POST['SectionNumber'][$x]);
...
$SectionNumber = filter_var( $SectionNumbers[ $i ], FILTER_SANITIZE_STRING );

注：增加 $SectionNumbers 数组来保存值。

赞(0）分享  回复(0）举报  2021-06-21
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com