dongtiao2105 2018-08-26 16:31
浏览 38
已采纳

从mysql(php)正确检查复选框

I have a problem with checkboxes. I have some project they you can filter at categories. So the problem is when you want edit a project that automatic the correct category are checked. here you see a project but the categories are empty

In mine databank I use is a combo table - one to insert my categories and one for the project and there I have a combo table from.

Here you see my code for display the checkboxes and select for editing so now I looking for some help, for checked the correctly checkbox that belongs to that project.

<div id="categoriefilter">
  <?php     
  $sql = "SELECT * FROM `categories` ORDER BY `id` ASC";
  $cats = DB::getResult($sql);
  foreach($cats as $cat){
  ?>
  <label>
      <input name="cat[]" type="checkbox" value="<?php echo $cat['id']; ?>" >
      <?php echo $cat['categorienaam']; ?>
  </label>
  <?php
  }
  ?>
</div>
  • 写回答

2条回答 默认 最新

  • drtohng5613 2018-08-27 07:41
    关注

    If I understand your question correctly. You need 3 tables here

    Table1 : projects id, name, ...
    Table2: categories id, name, ...
    Table3: projects_categories project_id, category_id, ...

    The third table is needed to store the categories which are selected for projects

    And inside your project page
    You need to do the followings:

    1. Select your project by its id
    2. Select categories
    3. Select categories related to the project ( from Table3 )

    Here is example ( this is not a working code, just a showcase )

    //  your project
    $project = DB::getResult("SELECT * FROM project WHERE id = :id "); // <== id here
    
    // list of categories
    $categories = DB::getResult("SELECT * FROM categories ");
    
    // list of categories for this project
    $project_categories = DB::getResult("SELECT category_id FROM projects_categories WHERE project_id = :project_id ");
    $project_categories = (array) $project_categories; // in case DB::getResult is not array
    
    <?php
        foreach($categories as $category) :
    ?>
    <label>
        <input name="cat[]" 
            <?php if(in_array($category['id'], $project_categories)) echo 'checked="checked"'; ?>
            type="checkbox" value="<?= $category['id']; ?>" >
        <?php echo $category['name']; ?>
    </label>
    <?php endforeach; ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 给出完整的python代码并解释
  • ¥15 有人懂怎么做大模型的客服系统吗?卡住了卡住了
  • ¥20 firefly-rk3399上启动卡住了
  • ¥15 如何删除这个虚拟音频
  • ¥50 hyper默认的default switch
  • ¥15 网站打不开,提示502 Bad Gateway
  • ¥20 基于MATLAB的绝热压缩空气储能系统代码咨询
  • ¥15 R语言建立随机森林模型出现的问题
  • ¥15 关于#wpf#的问题:怎么更改LayoutGroup组件的标签页的字体颜色
  • ¥15 中级微观经济学,生产可能性边界问题