首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >PHP MySQL使用复选框更新多行

问PHP MySQL使用复选框更新多行
EN

Stack Overflow用户
提问于 2019-07-30 14:57:43
回答 1查看 71关注 0票数 0

我想用PHP更新MySQL中的校验值。

代码语言:javascript
复制
<?php

require "../../../../config.php";


if (isset($_POST['btn-upload'])) {
    try {

        $connection = new PDO($dsn, $username, $password, $options);

        $status = $_POST['status'];
        $ck_id = $_POST['ck_id'];

        for ($i = 0; $i < sizeof($ck_id); $i++) {
            $sql = "UPDATE form_eg208 SET status=:status where ck_id IN (:ck_id)";
            $statement = $connection->prepare($sql);
            $statement->bindParam(':status', $status[$i]);
            $statement->bindParam(':ck_id', $ck_id[$i]);

            $statement->execute();
        }

    } catch (PDOException $error) {
        echo $sql . "<br>" . $error->getMessage();
    }


    if ($statement->rowcount() >= 0) {

        echo '<div class="alert alert-success alert-dismissible" id="flash- 
                msg">
    <a href="#" class="close" data-dismiss="alert" aria-label="close">&times; 
                    </a>
                  <h4> <strong>Success!</strong> Insert Record  
                 Successfully</h4>
                  </div>';

    } else {
        echo '<div class="alert alert-danger alert-dismissible" id="flash- 
                   msg">
    <a href="#" class="close" data-dismiss="alert" aria-label="close">&times; 
                         </a>
                 <h4> <strong>Failed!</strong> Duplicate BGLPARTNO</h4>
                    </div>';
    }
}

?>

我的html代码是

代码语言:javascript
复制
<?php
$id = $_REQUEST['cid'];

try {

    $connection = new PDO($dsn, $username, $password, $options);
    $j = 1;
    $sql = "CALL view_eg208 (:bglpartno)";
    $statement = $connection->prepare($sql);
    $statement->bindParam(':bglpartno', $id);
    $statement->execute();

    $result = $statement->fetchAll();
} catch (PDOException $error) {
    echo $sql . "<br>" . $error->getMessage();

}

foreach ($result as $row1)
?>
<div class="container-fluid">
    <div class="row">
        <div class="col-md-12" style="margin-top:40px;">
            <div class="card">
                <div class="card-body">
                    <form method="post" action="" enctype='multipart/form-data' class="needs-validation" novalidate>

                        <div class="table-responsive m-t-40">

                            <table id="myTable" class="table table-hover table-bordered">

                                <thead class="thead-dark">
                                <tr>
                                    <th>No.</th>
                                    <th>Activity</th>
                                    <th style="text-align:center;">Status</th>
                                </tr>
                                </thead>
                                <tbody>
                                <?php

                                if ($result && $statement->rowCount() > 0) {
                                    foreach ($result as $row) { ?>
                                        <tr>
                                            <td>
                                                <input type="checkbox" id="ck_id[]" class="filled-in chk-col-blue"
                                                       name="ck_id[]" value="<?php echo escape($row["ck_id"]); ?>"/>
                                            </td>
                                            <td style="color:black"><?php echo escape
                                                ($row["activity_name"]); ?></td>
                                            <td>
                                                <div class="form-group has-danger"
                                                     style="margin-bottom: 0;">
                                                    <input type="text" id="status[]" name="status[]" maxlength="100" class="form-control" value="<?php echo escape($row["status"]);?>" autocomplete="off" required="required">
                                                    <div class="invalid-feedback">
                                                        Please provide a Inputs.
                                                    </div>
                                                </div>
                                            </td>

                                        </tr>
                                    <?php }
                                }
                                $connection = null;
                                ?>
                                </tbody>
                            </table> 

当我更新所有的值时,它会正常工作,但当我更新单个值时,它会将第一个框的值更新到我选择的框中。请帮我解决这个问题

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-07-30 15:28:18

请像这样输入复选框,以便为正确的ck_id索引获得正确的status:

代码语言:javascript
复制
if ($result && $statement->rowCount() > 0) { 

    foreach ($result as $i => $row) { ?>

        <tr>

            <td>
                <input type="checkbox" id="ck_id[]"class="filled-in chk-col-blue" 
                name="ck_id[<?php echo $i ?>]" value="<?php echo escape ($row["ck_id"]);?>"/> 
            </td>   
            <td style="color:black"><?php echo escape 
                ($row["activity_name"]);?></td>
            <td>
                <div class="form-group has-danger" 
                style="margin-bottom: 0;">                   
                    <input type="text" id="status[]" name="status[<?php echo $i ?>]" 
                        maxlength="100" class="form-control" value="<? 
                        php echo escape ($row["status"]);?>" autocomplete="off" 
                        required="required" >                  
                    <div class="invalid-feedback">
                        Please provide a Inputs.
                    </div>
                </div>
            </td>    

        </tr>   

    <?php
    }
}

另外,尝试使用foreach而不是for循环:

代码语言:javascript
复制
    try {

        $connection = new PDO($dsn, $username, $password, $options);

        $status = $_POST['status'];
        $ck_id = $_POST['ck_id'];

        // for ($i = 0; $i < sizeof($ck_id); $i++) {
        foreach ($ck_id as $i => $value) {
            $sql = "UPDATE form_eg208 SET status=:status where ck_id IN (:ck_id)";
            $statement = $connection->prepare($sql);
            $statement->bindParam(':status', $status[$i]);
            $statement->bindParam(':ck_id', $ck_id[$i]);

            $statement->execute();
        }

    } catch (PDOException $error) {
        echo $sql . "<br>" . $error->getMessage();
    }
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/57265965

复制
相关文章

相似问题

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