GOBB

<?php
include 'connect.php';
include 'head.html';

$firstn = $_REQUEST['firstname'];
$lastn  = $_REQUEST['lastname'];
$usern  = $_REQUEST['username'];
$passw  = $_REQUEST['password'];
$email  = $_REQUEST['email'];
$id     = $_REQUEST['id'];
$add    = $_REQUEST['add'];
$delete = $_REQUEST['delete'];
$show   = $_REQUEST['show'];
$edit   = $_REQUEST['edit'];
$update = $_REQUEST['update'];
$MBEB = $_REQUEST['MBEB'];

if ($add) {
	$sql = "INSERT
	INTO user (firstname, lastname, username, password, email)
	VALUES ('$firstn', '$lastn', '$usern', '$passw', '$email')";
	if ($conn->query($sql) === TRUE) $message = '<p style="color:lightgreen">Record created</p>';
	else $message = '<p style="color:orangered">fel vid insttning utav anv'.$conn->error.'</p>';
}



else if ($delete) {
	$sql = "SELECT * FROM user WHERE id=$delete";
	$result = $conn->query($sql);
	if ($result == TRUE) $message = '<p style="color:lightgreen">Profil borttagningsbar</p>';
	else $message = '<p style="color:orangered">Kan ej visa'.$conn->error.'</p>';
	$post = mysqli_fetch_assoc($result);
}



else if ($show) {
	$sql = "SELECT * FROM user WHERE id=$show";
	$result = $conn->query($sql);
	if ($result == TRUE) $message = '<p style="color:lightgreen">Record Showing</p>';
	else $message = '<p style="color:orangered">Kan ej visa'.$conn->error.'</p>';
	$post = mysqli_fetch_assoc($result);
}


else if ($MBEB) {
	$sql = "DELETE FROM user WHERE id=$id";
$result = $conn->query($sql);
if ($result == TRUE) $message = '<p style="color:lightgreen">Profil borttagen.</p>';
}

else if ($edit) {
	$sql = "SELECT * FROM user WHERE id=$edit";
	$result = $conn->query($sql);
	if ($result == TRUE) $message = '<p style="color:lightgreen">Record Editable</p>';
	else $message = '<p style="color:orangered">Kan ej visa redigerbar information'.$conn->error.'</p>';
	$post = mysqli_fetch_assoc($result);
}



else if ($update) {
	$sql = "UPDATE user SET
	firstname='$firstn',
	lastname='$lastn',
	email='$email',
	username='$usern',
	password='$passw'
	WHERE id=$id";
	$result = $conn->query($sql);
	if ($result === TRUE) $message = '<p style="color:lightgreen">Record Updated</p>';
	else $message = '<p style="color:orangered">Error updating record'.$conn->error.'</p>';
	$sql = "SELECT * FROM user WHERE id=$id";
	$result = $conn->query($sql);
	if ($result == TRUE) $message .= '<p style="color:lightgreen">Record Showing</p>';
	else $message .= '<p style="color:orangered">Error showing record'.$conn->error.'</p>';
	$post = mysqli_fetch_assoc($result);
}

$sql = "SELECT id, firstname, lastname FROM user ORDER BY firstname";
$result = $conn->query($sql);

$conn->close();

$content = '';

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
		$content .= '
 <li class="list-group-item">'.$row["firstname"]." ".$row["lastname"].
'<button type="submit" name="delete" value="'.$row["id"].'">Radera</buton>'.
'<button type="submit" name="edit" value="'  .$row["id"].'">Redigera</buton>'.
'<button type="submit" name="show" value="'  .$row["id"].'">Visa</buton> '.
'</li>';

    }

} else $content = '<li class="list-group-item">Inga användare</li>';

include 'list.php';

if ($show || $update) include 'show.php';
else if ($delete) include 'remove.php';
else if ($edit) include 'edit.php';
else include 'add.php';
include 'foot.html';
?>