duande1985 2017-06-06 09:44
浏览 67

在PHP中检查onchange下拉显示复选框

code:

<script>
  $(document).ready(function(){
    $(".menu").click(function(){
      ids = $('.menu:checked').map(function() {
              return this.id;
              }).get().join(',');
              console.log(ids);
        $("#ids").val(ids);      
    });
  });
</script>

<?php
if(isset($_POST['submit']))
{
  $adminid = $_POST['admin'];
  $menuids = explode(",", $_POST['ids']);
    foreach ($menuids as $idd) 
    {
      $sql = "update menu set admin_id = concat(admin_id,'$adminid',',') where id = '$idd'";
      $result = mysqli_query($link,$sql);
    }
    if($result == true)
      {
        $msg .= "<p style='color:green'>successfull</p>";
      }
      else
      {
        $msg .= "<p style='color:red'>error!</p>";
      }
}
?>

<form method="post">
  <select name="admin" id="admin">
    <option value="">---Select Admin---</option>
    <?php
      $sql = "select * from admin";
      $result = mysqli_query($link,$sql);
      while ($row = mysqli_fetch_array($result)) 
      {
    ?>
     <option value="<?php echo $row['id']; ?>"><?php echo $row['firstname']?></option> 
    <?php    
      }
    ?>
  </select>
  <table>
    <tr>
      <th>Share</th>
      <th>Menu Name</th>
    </tr>
    <?php
      $query = "select * from menu";
      $results = mysqli_query($link,$query);
      while ($fetch = mysqli_fetch_array($results)) 
      {
    ?>
        <tr>
          <td>
            <input type="checkbox" class="menu" id="<?php echo $fetch['id']; ?>" name="menuid" />
          </td>

          <td>
            <?php echo $fetch['menu_name']; ?>
          </td>
        </tr>
    <?php
      }
    ?>
  </table>
  <input type="text" name="ids" id="ids" value=""/>
  <input type="submit" name="submit" id="submit" />
</form>

In this code I am update a table having name menu in database. Now, I want to check only those checkbox where admin_id like ,1, or ,2, which is update by query. How can I fix this issue ?please please help.

Thank You

  • 写回答

1条回答 默认 最新

  • dongliu8559 2017-06-06 10:01
    关注
       while ($fetch = mysqli_fetch_array($results)) 
      {
       ?>
        <tr>
          <td>
            <input type="checkbox" class="menu" value="<?php if($fetch['id']==1 or 
               $fetch['id']==2 ) { echo "checked";} else{} ?>" name="menuid" />
          </td>
    
          <td>
            <?php echo $fetch['menu_name']; ?>
          </td>
        </tr>
    <?php
      }
    ?>
    
    评论

报告相同问题?

悬赏问题

  • ¥15 微信会员卡接入微信支付商户号收款
  • ¥15 如何获取烟草零售终端数据
  • ¥15 数学建模招标中位数问题
  • ¥15 phython路径名过长报错 不知道什么问题
  • ¥15 深度学习中模型转换该怎么实现
  • ¥15 HLs设计手写数字识别程序编译通不过
  • ¥15 Stata外部命令安装问题求帮助!
  • ¥15 从键盘随机输入A-H中的一串字符串,用七段数码管方法进行绘制。提交代码及运行截图。
  • ¥15 TYPCE母转母,插入认方向
  • ¥15 如何用python向钉钉机器人发送可以放大的图片?