duangu1878 2015-05-31 08:27
浏览 77
已采纳

如何使用数组检查循环复选框

I have products in my database like this:

  1 -> torch
  2 -> speaker
  3 -> laptop
  4 -> handphone
  5 -> mouse
  6 -> lcd 

and in edit form, id product (example : 1,3,4,5 ) have been selected, but my form didn't selected the checkbox properly. here is my code :

$selected = array(1,3,4,5);

foreach ($selected as $val)
    $q=mysql_query("Select * from product");

while ($r=mysql_fetch_array($q)){
    echo "<input type='checkbox' name='product[]'";
    if ($r['id'] == $val) echo "checked"; 
    echo"> $r[product]<br>";
}

the result is only id no 5 is selected, it should be 4 products selected,,,

  • 写回答

1条回答 默认 最新

  • doujiu1447 2015-05-31 08:46
    关注

    It is because last iteration over query result is when $val is 5, so all other are not checked. Change the loop this way:

    $selected=array(1,3,4,5);
    $q=mysql_query("Select * from product");
    while ($r=mysql_fetch_array($q)){
       $ch = in_array($r['id'],  $selected)?"checked":'';
        echo "<input type='checkbox' name='product[]' $ch> {$r['product']}<br />";
    }
    

    BTW, don't use mysql_ functions - they are deprecated, and will be removed in future. Switch to mysqli or PDO with prepared statements to prevent malicious code injections.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥100 求购一套带接口实现实习自动签到打卡
  • ¥50 MacOS 使用虚拟机安装k8s
  • ¥500 亚马逊 COOKIE我如何才能实现 登录一个亚马逊账户 下发新 COOKIE ..我使用下发新COOKIE 导入ADS 指纹浏览器登录,我把账户密码 修改过后,原来下发新COOKIE 不会失效的方式
  • ¥20 玩游戏gpu和cpu利用率特别低,玩游戏卡顿
  • ¥25 oracle中的正则匹配
  • ¥15 关于#vscode#的问题:把软件卸载不会再出现蓝屏
  • ¥15 vimplus出现的错误
  • ¥15 usb无线网卡转typec口
  • ¥30 怎么使用AVL fire ESE软件自带的优化模式来优化设计Soot和NOx?
  • ¥15 Ubuntu20.04.4.LTS系统如何下载安装VirtualBox虚拟机?