<?php
require_once('includes/config.php');

if( !$user->is_logged_in() ){ header('Location: login.php'); }

if(isset($_POST['deleteUser']))
{
    deleteUser($_POST['memberID']);
    echo "ID"+ $_POST['memberID'];
}

function deleteUser($id){
  try {

  	//create PDO connection
  	$db = new PDO("mysql:host=".DBHOST.";dbname=".DBNAME, DBUSER, DBPASS);
  	$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  } catch(PDOException $e) {
  	//show error
      echo '<p class="bg-danger">'.$e->getMessage().'</p>';
      exit;
  }

  $stmt = $db->prepare('DELETE FROM members WHERE memberID= :id');
  $stmt->execute(array(':id' => $id));
  //$row = $stmt->fetch(PDO::FETCH_ASSOC);
}



?>

<?php require_once "header.php"; ?>
      <!-- main area -->
      <div class="main-content">


        <div class="card bg-white m-b">
          <div class="card-header">Usuarios</div>
          <div class="card-block p-a-0">
            <div class="table-responsive">
              <table class="table m-b-0">
                <thead>
                  <tr>
                    <th class="col-md-6">
                      <span></span>Nome</th>
                    <th class="col-md-2">Ação</th>
                  </tr>
                </thead>
                <tbody>
                  <?php
                  //$sql = mysqli_query("SELECT name, username, email FROM members ORDER BY memberID DESC ");

                  $query = $db->prepare('SELECT * FROM members');
                  $query->execute();

                  for($i=0; $row = $query->fetch(PDO::FETCH_ASSOC); $i++){ ?>

                  <tr>
                    <td>
                    <?php echo $row['name']; ?></td>
                    <td class="align-middle">
                      <form method="post" action="">
                          <input name="memberID" type="hidden" id="memberID" value="<? echo $row["memberID"]; ?>">
                          <input class="btn btn-primary m-b" type=submit name='deleteUser' value=Excluir>
                      </form>
                      <!-- <button class="btn btn-primary btn-block btn-lg m-b" name="delete" type="button" onclick="" >Excluir</button> -->
                    </td>
                  </tr>

                  <?php } ?>

                </tbody>
              </table>
            </div>
          </div>
        </div>


      </div>
<!-- /main area -->
<?php require_once "footer.php" ?>