<? // 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">&nbsp;</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;"> &nbsp; </div> <!-- /.box-footer--> </div> <!-- /.box --> </section> </section>