Store a PHP array in a single SQL cell
===

I wish to store the ingredients if an item as an array or similar data type in my SQL db an cannot find satisfactory information on the subject

in php the information will get stored as `ingredient["$id"]=true or false` where $id represents an ingredient

so for plain bread (please note this is mostly still psudo code as the data entry side has not yet been started)

    //code that creates array this bit is still theory and will be manually emulated in the db for the time being
        $id=1;
        while (isset ($_POST["ingredient part of form".$ID])){
            if ($_POST["ingredient".$id]==checked){
                $p["ingredient"][$id]=true;
            }
            else{
                $p["ingredient"][$id]=false
            }
        $id++;
        }
    
    //the code that gets the values back for the ingredient name we will use a separate array ingredient_n[$id]
    echo p[$prod_id]["item"].': '
    $id=1
    while (isset ($ingredient[$id])){
        if ($p[$prod_id]["ingredient"][$id]==true)
            if ($id!=1){
                echo ', ';
            }
            echo $ingredient_n[$id];
        }
    }
    echo '.';

this should produce something like

'PLAIN BREAD: WHEAT FLOUR, WATER, SALT, YEAST.'

I looked in to ENUM and SET but that would make adding new ingredients harder