function Remover_usuario($var) { global $conexao; $comandoSql = "SELECT id_usuario FROM usuario WHERE userid = ?"; $stmt = $conexao->prepare($comandoSql) or trigger_error("triggererror " . $conexao->error); $stmt->bind_param('s', $var); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($id); if ($stmt) { while ($stmt->fetch()) { //carrega variavel } } $stmt->close(); if (testaSeAdminOuNao() == 1 && $id != 1) { $comandoSql = "DELETE FROM usuario WHERE userid = ?"; $stmt = $conexao->prepare($comandoSql) or trigger_error("triggererror " . $conexao->error); $stmt->bind_param('s', $var); $stmt->execute(); $stmt->close(); $comandoSql = "DELETE FROM template WHERE userid = ?"; $stmt = $conexao->prepare($comandoSql) or trigger_error("triggererror " . $conexao->error); $stmt->bind_param('s', $var); $stmt->execute(); $stmt->close(); $comandoSql = "DELETE FROM remetente WHERE userid = ?"; $stmt = $conexao->prepare($comandoSql) or trigger_error("triggererror " . $conexao->error); $stmt->bind_param('s', $var); $stmt->execute(); $stmt->close(); } }
</tr> <?php } $stmt->close(); } ?> </table> </fieldset> <br/> </div> <a href="#novo_usuario"><div class="metodo" onclick="openclose_novo_usuario();">Novo usuário</div></a> <div style="display:none;" id ="novo_usuario"> <?php if (testaSeAdminOuNao() == 1) { ?> <fieldset> <legend>Criar novo usuário com permissão para enviar</legend> <br/> <form action="pp/incluir_usuario.php" method="post"> <table> <tr class="trUP"> <th width="20%">Usuário</th> <th width="20%">Senha</th> <th width="40%">e-mail</th> <th width="10%">Limite diário</th> <th width="10%">Ação</th> </tr> <tr class="trDOWN"> <td><input style="background-color:rgba(0,0,0,0);" type="text" name="usuario" maxlength="50" required/></td>