in_array不会选择从DB收集的多个复选框值

Question

When database query has many values [Permanent ID,Trainee ID Card,ID Card] it doesn't get checked for unknown reason

Below QUERY to get the checkbox cardtype has all the the checked values from the form

It works fine only for one checkbox field 1) Permanent ID Card or Trainee ID Card or ID Card 2) When Permanent ID Card ,Trainee ID Card , ID Card only checkbox is shown its not checked.

while($row2=mysqli_fetch_array($result2))
{
    $card_type = explode(',',$row2['cardtype']);
    if (in_array("Permanent ID Card", $card_type))  
    {  
    echo "'Permanent ID Card' found in the array";  
    }  
    <input type="checkbox" name="cardtype" value="Trainee ID Card"<?php if(in_array("Trainee ID Card",$card_type)) echo "checked";?> />Trainee ID Card
    <input type="checkbox" name="cardtype" value="Permanent ID Card"<?php if(in_array("Permanent ID Card",$card_type))  echo "checked";?> />Permanent ID Card
    <input type="checkbox" name="cardtype" value=" ID Card"<?php if(in_array(" ID Card",$card_type))  echo "checked";?> /> ID Card
 }

when I print-r

Array ( [0] => Trainee ID Card [1] => Permament ID Card [2] => ID Card ) as output

Answer 1

Please ensure there's no space in the if conditions. Also, after applying explode, trim the whitespaces

$card_type = explode(',',$row2['cardtype']);

$card_type = array_map('trim', $card_type); // Add this line

HTML code:

<input type="checkbox" name="cardtype" value="Trainee ID Card"<?php if(in_array("Trainee ID Card",$card_type)) echo "checked";?> />Trainee ID Card
<input type="checkbox" name="cardtype" value="Permanent ID Card"<?php if(in_array("Permanent ID Card",$card_type))  echo "checked";?> />Permanent ID Card
<input type="checkbox" name="cardtype" value=" ID Card"<?php if(in_array("ID Card",$card_type))  echo "checked";?> /> ID Card