时间戳

首页 > 解决方案 > 如何使用php中的if条件在while循环内的数据库中插入数据？

php - 如何使用php中的if条件在while循环内的数据库中插入数据？

问题描述

这是代码：

while ($row= mysqli_fetch_assoc($result)) {
    //
  ?>
  <table >
    <tr>
        <td>
            <p><?php echo $row['groupName'];?></p>
            <p><?php echo $row['groupPhoneNumber'];?></p>
        </td>
    </tr>

    <tr>
        <td>
        <?php
            if (isset($_POST['submit'])) {
                $status=1; // 1 is equel to requesting. 
                 $member_request=$_SESSION['id'];
                $group_requested=$row['groupName'];
                $select_chech= mysqli_query($con,"SELECT * FROM grouptbl WHERE groupCreator ='$member_request'");
                if (mysqli_num_rows($select_chech)>0) {
                    $error="You are a member of this group!";
                    }else {
                        $query_request=mysqli_query($con,"INSERT INTO `tblrequest`(`member_request`, `group_requested`, `status`) VALUES ('".$_SESSION['id']."','$group_requested',1)");
                        $msg="now you requested to ".$row['groupName'];
                    }
            }
        ?>
        <form method="post">
             <button type="submit" name="submit"
                class="btn btn-success waves-effect waves-light">ask</button>
        </form>
            
        </td>
    </tr>

   
  </table>

<?php
}//end of while condition

看到了！在 if 条件语句上，这将帮助我检查成员是否在组中，它不会给我一个错误，否则不会工作！请帮我！！

标签： php

解决方案

我稍微清理了你的代码，所以如果你在行中有任何值，那么它将为每条记录创建带有 tr td 的表。先打印 $row 进行调试。

// 我把这部分移到表外以提高代码的可读性。

<?php
    if (isset($_POST['submit'])) {
        $status=1; // 1 is equel to requesting. 
        $member_request=$_SESSION['id'];
        $group_requested=$row['groupName'];
        $select_chech= mysqli_query($con,"SELECT * FROM grouptbl WHERE groupCreator ='$member_request'");
        if (mysqli_num_rows($select_chech)>0) {
            $error="You are a member of this group!";
            }else {
                $query_request=mysqli_query($con,"INSERT INTO `tblrequest`(`member_request`, `group_requested`, `status`) VALUES ('".$_SESSION['id']."','$group_requested',1)");
                $msg="now you requested to ".$row['groupName'];
            }
    }
?>   
 <?php
 while ($row= mysqli_fetch_assoc($result)) { ?>  DEBUG -> PRINT $row to check, fetching value from DB or not.
  <table >
    <tr>
        <td><h2><?php echo $row['groupName'];?></h2></td>
        <td><h2><?php echo $row['groupPhoneNumber'];?></h2></td>
        <td>
        <form method="post">
             <button type="submit" name="submit"
                class="btn btn-success waves-effect waves-light">ask</button>
        </form>
        </td>
    </tr>
  </table>
<?php } ?>

推荐阅读