`<?php
 //variables for database connection
$servername = "";
$username = "";
$password = "";
$dbname = "";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

//select records from table to populate rows
$sql = "SELECT memberID, firstName, lastName, dateRegistered, userRole,status, approved from member";
$result = $conn->query($sql);
if ($result){
echo "";
}else {
echo mysqli_error();
}
//create the table using the output of the query
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()){
echo  '<tr>', '<form action="review-users.php" method="post">','<td>',$row['memberID'], '</td>' . '<td class="center">',$row['firstName'],'</td>' . '<td class="center">',$row['lastName'],'</td>'.
 '<td class="center">',$row['dateRegistered'], '</td>'.'<td class="center">',$row['userRole'], '</td>'. '<td class="center"><span class="label label-success">', $row['status'], '</td>' .
 '<td>','<input type="submit" value="Approve" name="approve">','<input type="submit" value="Delete" name="Delete">','</td>', '</tr>','</form>';

    }


    }

?>

 <?php
$servername = "";
$username = "";
$password = "";
$dbname = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

if (isset($_POST['approve'])){

//query to update the user
$sql =("UPDATE member set approved = 1, status = 'active' where memberID= memberID");
$resultt = $conn->query($sql);
if ($resultt) {
"Successfully changed approved"; }
else {
echo mysqli_error($conn);
}
}

?>
<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);


if (isset($_POST['Delete'])){
//query to delete the user
$sql =("DELETE from member where memberID = memberID");
$resultt = $conn->query($sql);
if ($resultt) {
"Successfully changed approved"; }
else {
echo mysqli_error($conn);
}
}

?>