Untitled

<?php

$dsn = "mysql:dbname=blog;host=localhost";
$dbuser = "root";
$dbpass = "";

try {
	$pdo = new PDO($dsn, $dbuser, $dbpass);


} catch (PDOException $e){

	echo "Falhou a conexão: ".$e->getMessage();

}


?>

-------------------------------------------------------------------------------------------------------------------------------
<?php
require 'config.php'
?>

<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<title>Controle de Usuários ADM</title>
	<meta name="viewport" content="width=device-width, initial-scale=1" >
	<link rel="stylesheet" href="bootstrap.min.css">
	<script type="text/javascript" src="bootstrap.min.js"></script>
	<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>

<div class="container">

<button class="btn btn-secondary"><a href="adicionar.php">Adicionar Novo Usuario</a></button><br>

<hr>

<table class="table table-bordered" border="0" width="100%" >
	<tr>
		<th>ID</th>
		<th>Nome</th>
		<th>E-mail</th>
		<th>Mais Opções</th>
	</tr>
	<?php
	$sql = "SELECT * FROM usuarios";
	$sql = $pdo->query($sql);
	if($sql->rowCount() > 0) {
		foreach($sql->fetchAll() as $usuario) {

		echo '<tr>';
		echo '<td>'.$usuario['id'].'</td>';
		echo '<td>'.$usuario['nome'].'</td>';
		echo '<td>'.$usuario['email'].'</td>';
		echo '<td><button><a href="editar.php?id='.$usuario['id'].'">Editar</a></button> - <button><a href="excluir.php?id='.$usuario['id'].'">Excluir</a></button></td>';
		echo '</tr>';


		}

	}

	?>

</table>
</div>
</body>
</html>

---------------------------------------------------------------------------------

<?php
require 'config.php';
if(isset($_POST['nome']) && empty($_POST['nome']) == false) {
	$nome = addslashes($_POST['nome']);
	$email = addslashes($_POST['email']);
	$senha = md5(addslashes($_POST['senha']));

	$sql = "INSERT INTO usuarios SET nome = '$nome', email = '$email', senha = '$senha'";
	$pdo->query($sql);

	header("Location: index.php");

}

?>

<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<title>Cadrastra Novo Usuário</title>
	<meta name="viewport" content="width=device-width, initial-scale=1" >
	<link rel="stylesheet" href="bootstrap.min.css">
	<script type="text/javascript" src="bootstrap.min.js"></script>
	<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div class="container">
<h1>Cadrastra Novo Usuário</h1>
<form method="POST">
<div class="form-group">
    <label for="inputEmail" class="control-label">Nome:</label>
    <input type="text" name="nome" class="form-control" placeholder="Digite seu Nome">
  </div>

  <div class="form-group">
    <label for="inputEmail" class="control-label">Email:</label>
    <input type="text" name="nome" class="form-control" placeholder="Digite seu E-mail">
  </div>

  <div class="form-group">
    <label for="inputPassword" class="control-label">Senha:</label>
    <input type="password" name="nome" class="form-control" placeholder="Digite sua Senha...">
  </div>
  <button type="submit" value="Cadastrar" class="btn btn-primary">Cadrastrar</button>
</form>
</div>