首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何通过复选框在数据库中插入多行?

问如何通过复选框在数据库中插入多行?
EN

Stack Overflow用户
提问于 2020-10-23 15:59:25
回答 1查看 35关注 0票数 0

我有一个从名为'submittbl‘的数据库动态生成的表。每一行都有一个动态生成的复选框。

我希望能够将选中的行插入到名为'marktbl‘的数据库中。到目前为止,我只尝试将第一行保存到数据库中,而不是我选中/选择的行。但是如果我检查所有行,所有行都会被正确地保存。如何插入勾选的行?

我尝试了许多解决方案,但都没有奏效。

代码语言:javascript
复制
//to get records from database dynamically

<?php
            if(isset($_POST['find_btn']))
            {
                if(empty($_POST['s_lev']) && empty($_POST['s_sem']))
                {
                    $msgerr = "<b>Notice: </b>" . "No categories selected.";
                }
                else
                {
                    $selev=$_POST['s_lev'];
                    $sesem=$_POST['s_sem'];
                    $sql = "SELECT *FROM submittbl WHERE CourseCode = ? AND Level = ? AND Semester = ?";
                    $stmt = $conn->prepare($sql);
                    $stmt->bind_param("sss",$pcode, $plevel, $psems);
                    $pcode = $_SESSION['ccode'];
                    $plevel = $selev;
                    $psems = $sesem;
                    $stmt->execute();
                    $result = $stmt->get_result();
                    $num_rows = $result->num_rows;
                    if($num_rows>0)
                    {
                        while($rows = $result->fetch_assoc())
                        {
                            $sn = $rows['SN'];
                            $name = $rows['StudentName'];
                            $regno = $rows['RegNo'];
                            $asmid = $rows['AssignmentID'];
                            $code = $rows['CourseCode'];
                            $lev = $rows['Level'];
                            $sem = $rows['Semester'];
                            $det = $rows['SubmissionDate'];
                            $doc = $rows['Document'];
                            $score = $rows['Score'];
                            ?>
                            <tr>
                            <td><input type='checkbox' name='delChk[]' value='<?php echo $sn; ?>'><?php echo $sn; ?></input></td>
                            <td><?php echo $name; ?></td>
                            <td><?php echo $regno; ?></td>
                            <td><?php echo $asmid; ?></td>
                            <td><?php echo $det; ?></td>
                            <input type='hidden' name='sn' value='<?php echo $sn; ?>'></input>
                            <input type='hidden' name='name[]' value='<?php echo $name; ?>'></input>
                            <input type='hidden' name='regno[]' value='<?php echo $regno; ?>'></input>
                            <input type='hidden' name='asmid[]' value='<?php echo $asmid; ?>'></input>
                            <input type='hidden' name='ccode[]' value='<?php echo $code; ?>'></input>
                            <input type='hidden' name='level[]' value='<?php echo $lev; ?>'></input>
                            <input type='hidden' name='semester[]' value='<?php echo $sem; ?>'></input>
                            <input type='hidden' name='det[]' value='<?php echo $sub; ?>'></input>
                            <input type='hidden' name='doc[]' value='<?php echo $doc; ?>'></input>
                            <input type='hidden' name='score[]' value='<?php echo $score; ?>'></input>
                            <td><?php echo "<a href='download_submitted.php?id=$asmid'><img src=img/downloads.png width=10% height=10% alt='download'>Download</a>"; ?></td>
                            </tr>
                            <?php
                        }
                    }
                    else
                    {
                        $msgerr = "<b>Notice: </b>" . "Oops! No records found for the selected categories.";
                    }
                }
            }
            ?>

                //to insert into markedtbl database
               //this is where I'm having the whole problem

                <?php
                    if(isset($_POST['upload']))
                    {
                        if(!isset($_POST['delChk']))
                        {
                            $msgerr = "<b>Notice: </b>" . "No records selected - select/mark records to upload.";
                        }
                        else
                        {
                //-------------------get all IDs in checkbox by loop------------------
                           
                            $checked = $_POST['delChk'];

                            foreach($checked as $k=>$v)
                            {
                                if($checked[$k] == TRUE)
                                {
                                $chkrow = $checked[$k];
                                $name = $_POST['name'];
                                $regno = $_POST['regno'];
                                $asmid = $_POST['asmid'];
                                $code = $_POST['ccode'];
                                $level = $_POST['level'];
                                $sems = $_POST['semester'];
                                $det = $_POST['det'];
                                $doc = $_POST['doc'];
                                $score = $_POST['score'];
                               
                //-------------prepare sql query to update score in database------------------------
                            $sql = "INSERT INTO marktbl(NSN, StudentName, RegNo, AssignmentID, CourseCode, Level, Semester, DateSubmitted, Document, Score)
                                    VALUES(?,?,?,?,?,?,?,?,?,?)";
                                $stmt = $conn->prepare($sql);
                                $stmt->bind_param("ssssssssss", $pcount, $pname, $pregno, $pasmid, $pcode, $plevel, $psems, $pdet, $pdoc, $pscore);
                                $pcount = $chkrow;
                                $pname = $name[$k];
                                $pregno = $regno[$k];
                                $pasmid = $asmid[$k];
                                $pcode = $code[$k];
                                $plevel = $level[$k];
                                $psems = $sems[$k];
                                $pdet = $det[$k];
                                $pdoc = $doc[$k];
                                $pscore = $score[$k];
                                $stmt->execute();
                            }
                                }
                                if($conn->error)
                                {
                                    $msgerr = $conn->error;
                                }
                                else
                                {
                                    echo "<script> alert('Assignment uploaded for marking.')</script>";
                                }
                        }
                            //}
                    }
                ?>
<?php echo "<span class='err'>" . $msgerr . "</span>"; ?><br>

                <td class='td'>
                <button class='upload' name='upload' onclick="return confirm('Are you sure you want to upload selected assignments for marking?')"
                >Upload for Marking</button>
                </td>
</form>
EN

回答 1

Stack Overflow用户

发布于 2020-10-23 17:06:06

所以我会试着写一个你的想法的样本,希望能行得通。因此对于我的示例,您有一个用户数组,其中包含四个键

代码语言:javascript
复制
$users = [
 0 => [
    'selected' => true,
    'name' => 'Name 1',

  ],
1 => [
    'selected' => false,
    'name' => 'Name 2',

  ],
2 => [
    'selected' => true,
    'name' => 'Name 3',

  ],
3 => [
    'selected' => false,
    'name' => 'Name 4',

  ],
];

foreach ($users as $user) {
    if (!$user['selected]) {
       continue;
    }
    $sql = "INSERT INTO marktbl(
        NSN,
        StudentName,
        RegNo,
        AssignmentID,
        CourseCode,
        Level,
        Semester,
        DateSubmitted,
        Document,
         Score
      ) VALUES(
       :name,
       :lastname,...
      )";
      $stmt = $conn->prepare($sql);
      $params = [
         ':name' => $user['name'],
         ':lastname' => $user['lastname'],...
      ];
      try {
         $stmt->execute($params); 
      } catch(Exception $e) {
         echo $e->getMessage();
      }
      

}

我认为你的代码应该是这样的。您可以轻松地为每个选定的元素设置一个标志,然后根据该标志过滤数据。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/64496139

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档