<?
// variávis que se trabalham nessa página
$var_banco = "usuario_sistema";
$var_pagina = "meus-dados&raiz=1"
?>
<section class="content" >
<!-- Info boxes -->
<section class="content-header">
<h1>
Meus dados
</h1>
<br />
<!-- Default box -->
<div class="box">
<div class="box-header with-border">
<h3 class="box-title"> </h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse" data-toggle="tooltip" title="" data-original-title="Collapse">
<i class="fa fa-minus"></i></button>
<!--button type="button" class="btn btn-box-tool" data-widget="remove" data-toggle="tooltip" title="" data-original-title="Remove">
<i class="fa fa-times"></i></button-->
</div>
</div>
<div class="box-body" style="display: block;">
<? if ($_REQUEST['alterou']=="sim"){
$comando = "UPDATE ". $var_banco ."
SET
nome = '". $_REQUEST[nome] ."',
email = '". $_REQUEST[email] ."',
cpf = '". $_REQUEST[cpf] ."',
permissao = '". $_REQUEST[permissao] ."',
cadastrado_por = ". $_SESSION[id] .",
data_cadastro = '". date('Y-m-d h:i:s') ."'
WHERE id=".$_SESSION[id]; //comando SQL
$exec = mysql_query($comando); //executa o comando no banco
$_SESSION["nome"] = $_REQUEST['nome'];
$_SESSION["cpf"] = $_REQUEST['cpf'];
$_SESSION["email"] = $_REQUEST['email'];
$_SESSION["permissao"] = $_REQUEST['permissao'];
echo "<div class=\"alert alert-success\">
Alterado com <strong>sucesso</strong>.
</div>
<br>";
}
//********** BUSCA DADOS DO BANCO **********
$comando = "SELECT * FROM ".$var_banco." WHERE id =".$_SESSION[id];
$exec = mysql_query($comando);
$linha = mysql_fetch_assoc($exec);
?>
<div class="row" id="box_cadastro">
<form class="form-horizontal " id="form1" name="form1" method="post" action="index2.php?secao=<?= $var_pagina?>" style="width:90%; margin:0px auto">
<fieldset>
<div class="control-group">
<div class="controls">
<input type="text" class="form-control" id="nome" name="nome" value="<?= $linha[nome]?>" placeholder="Nome completo" required>
<br />
<input type="email" class="form-control" placeholder="E-mail" id="email" name="email" value="<?= $linha[email]?>" required>
<br />
<select class="form-control" id="permissao" name="permissao" required>
<option value="">PERMISSÃO</option>
<option value="ADMINISTRADOR" <? if($linha[permissao] == "ADMINISTRADOR") echo ' selected = selected '; ?> >ADMINISTRADOR</option>
<option value="FUNCIONARIO" <? if($linha[permissao] == "FUNCIONARIO") echo ' selected = selected '; ?>>FUNCIONARIO</option>
<option value="ESTAGIARIO" <? if($linha[permissao] == "ESTAGIARIO") echo ' selected = selected '; ?>>ESTAGIÁRIO</option>
<option value="EXTERNO" <? if($linha[permissao] == "EXTERNO") echo ' selected = selected '; ?>>EXTERNO</option>
</select>
<br />
<div class="control-group form-inline">
<input type="text" class="form-control" id="cpf" name="cpf" value="<?= $linha[cpf]?>" placeholder="CPF" required>
</div>
</div>
</div>
<br />
<div class="control-group">
<div class="controls">
<input type="hidden" name="alterou" value="sim">
<button type="submit" class="btn btn-primary">Alterar meus dados</button>
</div>
</div>
</fieldset>
</form>
</div>
<!-- /.box-body -->
<div class="box-footer" style="display: block;">
</div>
<!-- /.box-footer-->
</div>
<!-- /.box -->
</section>
</section>