I have a form that has some checkboxes with names of cities that are generated dynamically by PHP. I would like to know how to get these values and in what type of structure to store them (Array?) And in what kind of data to save in MySQL. These checkboxes that will be selected at the time of the user's registration and should give the same permissions to access city. So any suggestions? Thanks to anyone who can help me.
Here is the registration form code
<div class="container-fluid">
<div class="panel panel-primary">
<div class="panel-heading">
CADASTRAR USUÁRIO
</div><br>
<div id="filtros" style="padding-left: 20px">
<a id="voltar_pagina" href="menu.php" class="btn btn-primary" title="Voltar ao início">
<span class="glyphicon glyphicon-home"></span>
</a>
<a id="voltar_lista" href="javascript:history.back()" class="btn btn-primary" title="Voltar">
<span class="glyphicon glyphicon-chevron-left"></span>
</a>
</div>
<div class="panel-body">
<form id="form_cad_usuario" data-toggle="validator" class="form-horizontal" method="POST" action="../config/usuario/processa_cad_usuario.php">
<!--DADOS DO USUÁRIO-->
<div class="page-header">
<h4>Dados do Usuário</h4s>
<hr>
</div>
<div class="form-group">
<label for="status_check" class="col-sm-2 control-label">Ativo</label>
<div class="col-sm-10">
<div class="checkbox">
<label>
<input id="status_check" name="status_check" type="checkbox" value="ativo" checked>
</label>
</div>
</div>
</div>
<div class="form-group">
<label for="nome_usuario" class="col-sm-2 control-label">Nome</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="nome_usuario" name="nome_usuario" placeholder="Nome" data-error="Por favor, informe o nome completo para o usuário." required>
<div class="help-block with-errors"></div>
</div>
</div>
<!--DADOS DE ACESSO-->
<div class="page-header">
<h4>Dados de Acesso</h4>
<hr>
</div>
<div class="form-group">
<label for="login_usuario" class="col-sm-2 control-label">Usuário</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="login_usuario" name="login_usuario" placeholder="Usuário" data-error="Por favor, digite um nome para o usuário." required>
<div class="help-block with-errors"></div>
</div>
</div>
<div class="form-group">
<label for="senha_usuario" class="col-sm-2 control-label">Senha</label>
<div class="col-sm-10">
<input type="password" class="form-control" id="senha_usuario" name="senha_usuario" placeholder="Senha" data-error="Por favor, digite um senha para o usuário." required>
<div class="help-block with-errors"></div>
</div>
</div>
<div class="form-group">
<label for="permissao_usuario" class="col-sm-2 control-label">Senha</label>
<div class="col-sm-10">
<select class="form-control" id="permissao_usuario" name="permissao_usuario" data-error="Por favor, selecione um nível de permissão para o usuário." required>
<option value="4">Jogos</option>
<option value="3">Regional</option>
<option value="2">Administrador</option>
<option value="1">Master</option>
</select>
<div class="help-block with-errors"></div>
</div>
</div>
<!--DADOS DA REGIONAL-->
<div class="page-header">
<h4>Regionais Permitidas</h4>
<hr>
</div>
<?php
$resultado = lista_regionais();
while ($registro = mysqli_fetch_assoc($resultado))
{
$id_regional = $registro['id'];
$nome_regional = $registro['nome'];
?>
<div class="col-sm-2">
<div class="form-group">
<div class="col-sm-1">
<div class="checkbox">
<label>
<label class="col-md-10" for="<?php echo"regional_$id_regional" ?>">
<input type="checkbox" name="<?php echo"regional[$id_regional]"; ?>" id="<?php echo"regional_$id_regional" ?>" value="<?php echo $nome_regional; ?>">
<small><?php echo $nome_regional; ?></small>
</label>
</label>
</div>
</div>
</div>
</div>
<?php
}
?>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<button id="botao_salvar" type="submit" class="btn btn-primary pull-right">Salvar <span class="glyphicon glyphicon-floppy-save"></span></button>
</div>
</div>
</form>
</div>
</div>
Here is the code of the class that processes the registry
<?php
session_start();
include_once ('../seguranca.php');
include_once ('../../dao/usuario_dao.php');
verifica_acesso();
$nome = $_POST['nome_usuario'];
$login = $_POST['login_usuario'];
$senha = $_POST['senha_usuario'];
$permissao_str = $_POST['permissao_usuario'];
$check_status = $_POST['status_check'];
//Verifica o status recebido
if(!strcmp($check_status, "ativo"))
{
$flag_ativo = 1;
}
//Verifica a permissão recebida
if(!strcmp($permissao_str, "4"))
{
$permissao = 4;
}
else if(!strcmp($permissao_str, "3"))
{
$permissao = 3;
}
else if(!strcmp($permissao_str, "2"))
{
$permissao = 2;
}
else if(!strcmp($permissao_str, "1"))
{
$permissao = 1;
}
var_dump($permissao);
//cadastra_usuario($nome, $login, $senha, $permissao, $flag_ativo, $modificado);
As a beginner, I also welcome suggestions for improving the code structure and the way things are being done. Thanks in advance.