Boa tarde gente!
Estou fazendo um sistema que cadastra alunos, o adm vai cadastrar os usuarios desse sistema, só que ao tentar gravar as informações no banco de dados elas não aparecem.
estarei postando os codigos:
Listar_usuario.php
<?php
session_start();
include_once("seguranca.php");
include_once("conexao.php");
?>
<!doctype html>
<html lang="pt-br">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="Página administrativa">
<meta name="author" content="Paulo Baltieri">
<link rel="icon" href="../../../../favicon.ico">
<title>Administrativo</title>
<!-- Bootstrap core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Custom styles for this template -->
<link href="starter-template.css" rel="stylesheet">
</head>
<body>
<?php
include_once("menu_admin.php");
$resultado=mysql_query("SELECT*FROM usuarios ORDER BY 'id'");
$linhas=mysql($resultado);
?>
<nav class="navbar navbar-expand-md navbar-dark bg-dark fixed-top">
<a class="navbar-brand" href="administrativo.php">UPDATE</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarsExampleDefault" aria-controls="navbarsExampleDefault" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarsExampleDefault">
<ul class="navbar-nav mr-auto">
<li class="nav-item active">
<a class="nav-link" href="#">Inicio<span class="sr-only">(current)</span></a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">Link</a>
</li>
<li class="nav-item">
<!-- <a class="nav-link disabled" href="#">Disabled</a>-->
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="http://example.com" id="dropdown01" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Usuario</a>
<div class="dropdown-menu" aria-labelledby="dropdown01">
<a class="dropdown-item" href="listar_usuario.php">Listar</a>
<a class="dropdown-item" href="cad_usuario.php">Cadastrar</a>
</div>
</li>
<li class="nav-item">
<a class="nav-link" href="sair.php">SAIR</a>
</li>
</ul>
<form class="form-inline my-2 my-lg-0">
<input class="form-control mr-sm-2" type="text" placeholder="Search" aria-label="Search">
<button class="btn btn-outline-success my-2 my-sm-0" type="submit">Pesquisar</button>
</form>
</div>
</nav>
<main role="main" class="container">
<div class="starter-template">
<br></br>
<h1>Lista e Usuarios</h1>
<p class="lead">Usuarios registrados no sistema.</p>
<table class="table">
<thead class="thead-inverse">
<tr>
<th>ID</th>
<th>Nome</th>
<th>Email</th>
<th>Nivel de acesso</th>
<th>login</th>
<th>Ações</th>
</tr>
</thead>
<tbody>
<?php
while($linhas = mysql_fetch_array($resultado)){
echo"<tr>";
echo"<td>".$linhas['id']."</td>";
echo"<td>".$linhas['nome']."</td>";
echo"<td>".$linhas['email']."</td>";
echo"<td>".$linhas['nivel_acesso_id']."</td>";
echo"<td>".$linhas['login']."</td>";
echo"<td> Editar - Visualizar - Apagar</td>";
echo "</tr>";
}
?>
<tr>
</tr>
</tbody>
</table>
</main><!-- /.container -->
</div>
</main><!-- /.container -->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script>window.jQuery || document.write('<script src="../../../../assets/js/vendor/jquery-slim.min.js"><\/script>')</script>
<script src="js/popper.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>
cad_usuario.php
<?php
session_start();
include_once("seguranca.php");
include_once("conexao.php");
?>
<!doctype html>
<html lang="pt-br">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="Página administrativa">
<meta name="author" content="Paulo Baltieri">
<link rel="icon" href="../../../../favicon.ico">
<title>Cadastrar usuario</title>
<!-- Bootstrap core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Custom styles for this template -->
<link href="starter-template.css" rel="stylesheet">
</head>
<body>
<?php
include_once("menu_admin.php");
?>
<nav class="navbar navbar-expand-md navbar navbar-dark bg-primary fixed-top">
<a class="navbar-brand" href="administrativo.php">UPDATE</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarsExampleDefault" aria-controls="navbarsExampleDefault" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarsExampleDefault">
<ul class="navbar-nav mr-auto">
<li class="nav-item active">
<a class="nav-link" href="#">Inicio<span class="sr-only">(current)</span></a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">Link</a>
</li>
<li class="nav-item">
<!-- <a class="nav-link disabled" href="#">Disabled</a>-->
</li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" href="http://example.com" id="dropdown01" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Usuario</a>
<div class="dropdown-menu" aria-labelledby="dropdown01">
<a class="dropdown-item" href="listar_usuario.php">Listar</a>
<a class="dropdown-item" href="cad_usuario.php">Cadastrar</a>
</div>
</li>
<li class="nav-item">
<a class="nav-link" href="sair.php">SAIR</a>
</li>
</ul>
<form class="form-inline my-2 my-lg-0">
<input class="form-control mr-sm-2" type="text" placeholder="Digite sua pesquisa" aria-label="Search">
<button type="button" class="btn btn-secondary">Pesquisar</button>
</form>
</div>
</nav>
<main role="main" class="container">
<div class="starter-template"><br></br></p>
<br></br>
<h1>Cadastro de usuários</h1>
<p class="lead"></p>
<form class="form-horizontal" method="POST" action="processa/cad_processa.php">
<div class="container">
<form>
<div class="form-group">
<label for="exampleInputEmail1">Nome </label>
<input type="text" class="form-control" name="nome" aria-describedby="emailHelp" placeholder="Nome completo">
</div>
<div class="form-group">
<label for="exampleInputEmail1">E-mail</label>
<input type="email" class="form-control" name="email" aria-describedby="emailHelp" placeholder="Digite seu e-mail">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Usuário</label>
<input type="text" class="form-control" name="usuario" aria-describedby="emailHelp" placeholder="Digite um nome de usuario.">
</div>
<div class="form-group">
<label for="exampleInputPassword1">Senha</label>
<input type="password" class="form-control" name="senha" placeholder="Digite uma senha">
</div>
<div class="form-group">
<label for="exampleSelect1">Nivel de acesso</label>
<select class="form-control" name="nivel_de_acesso_id">
<option value="1">Administrativo</option>
<option value="2">Usuário</option> </select>
</div>
<button type="submit" class="btn btn-primary">Cadastrar</button>
</form>
</div>
</form>
</div>
</main><!-- /.container -->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script>window.jQuery || document.write('<script src="../../../../assets/js/vendor/jquery-slim.min.js"><\/script>')</script>
<script src="js/popper.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>
cad_processa.php
<?php
session_start();
include_once("../seguranca.php");
include_once("../conexao.php");
$nome = $_POST["nome"];
$email = $_POST["email"];
$usuario = $_POST["usuario"];
$senha = $_POST["senha"];
$nivel_de_acesso = $_POST["nivel_de_acesso"];
$query = mysql_query("INSERT INTO usuarios(nome, email, login, senha, nivel_de_acesso_id, created) VALUES
('$nome','$email','$usuario','$senha','$nivel_de_acesso_id', NOW())");
if(mysql_affected_rows() != -1){
header("Location: listar_usuario.php");
}else{
$_SESSION['ErroLogin'] = "Erro no Cadastro:" or die(mysql_error());
header("Location: listar_usuario.php.php")or die(mysql_error());
}
?>
Anexei ao tópico a forma que o banco de dados se encontra, podem me ajudar?
Estou em fase de aprendizado, estou implantando esse sistema na empresa que atuo.
Desde já agradeço.