Create checkbox and save to database

-1

Good morning!

I have a question, I am creating an application that when the user clicks to create a certain item in db, automatically creates several items in checkbox, I would like help to save these items in db as well. Follow the code creation page

'

function auditorias(){

    require_once('conexao.php');

        $sql = "SELECT * FROM auditorias";

        $dados = mysqli_query($connect, $sql) or die ("Erro, envie um email para [email protected]");

    while ($rows = mysqli_fetch_array($dados)){
        echo "<tr>";
        echo "<td>".$rows['nome']."</td>";
        echo "<td>".$rows['data_auditoria']."</td>";
        echo "<td>".$rows['tipo']."</td>";
        echo "<td>".$rows['descricao']."</td>";
        echo "<td style='text-align:right;'>";
        echo "<label>PROCEDIMENTOS</label> <input type='checkbox' name='ivs[]' value='PROCEDIMENTOS'>"."<br>";
        echo "<label>APR</label> <input type='checkbox' name='ivs[]' value='APR'>"."<br>";
        echo "<label>SAM/LOTO</label> <input type='checkbox' name='ivs[]' value='SAM/LOTO'>"."<br>";
        echo "<label>EQUIPAMENTOS</label> <input type='checkbox' name='ivs[]' value='EQUIPAMENTOS'>"."<br>";
        echo "<label>LISTA DE EPIS</label> <input type='checkbox' name='ivs[]' value='LISTA DE EPIS'>"."<br>";
        echo "<label>CLASSE I/II</label> <input type='checkbox' name='ivs[]' value='CLASSE I/II'>"."<br>";
        echo "<label>PINTURAS</label> <input type='checkbox' name='ivs[]' value='PINTURAS'>"."<br>";
        echo "<label>GESTÃO À VISTA</label> <input type='checkbox' name='ivs[]' value='GESTÃO À VISTA'>"."<br>";
        echo "<label>5'S'</label> <input type='checkbox' name='ivs[]' value='5'S''>"."<br>";
        echo "<label>OPERAÇÃO</label> <input type='checkbox' name='ivs[]' value='OPERAÇÃO'>"."<br>";
        echo "<label>EPI'S</label> <input type='checkbox' name='ivs[]' value='EPIS'>";
        echo "</td>";
        echo "<td><a href='funcoes/deletar-auditorias.php?id=" .$rows['id']."'>Finalizar</a></td>";
        echo "</tr>";
    }

}'
    
asked by anonymous 04.01.2019 / 13:59

0 answers