HERE IS loginadmin.php with 15 extra fields:
<?php
session_start();
error_reporting(0);
define('ADMIN_PASS', 'eebc2fc1499d5f49c6348cd31608567b');
$session_timeout = 600;
$mysql_server = 'ppocc_members.db.3698662.hostedresource.com';
$mysql_username = 'ppocc_members';
$mysql_password = 'xxxxxxxxxx';
$mysql_database = 'ppocc_members';
$mysql_table = 'ppocc_members2018';
$admin_password = isset($_COOKIE['admin_password']) ? $_COOKIE['admin_password'] : '';
if (empty($admin_password))
{
if (isset($_POST['admin_password']))
{
$admin_password = md5($_POST['admin_password']);
if ($admin_password == ADMIN_PASS)
{
setcookie('admin_password', $admin_password, time() + $session_timeout);
}
}
}
else
if ($admin_password == ADMIN_PASS)
{
setcookie('admin_password', $admin_password, time() + $session_timeout);
}
$id = isset($_REQUEST['id']) ? $_REQUEST['id'] : '';
$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';
$username = isset($_POST['username']) ? $_POST['username'] : '';
$fullname = isset($_POST['fullname']) ? $_POST['fullname'] : '';
$email = isset($_POST['email']) ? $_POST['email'] : '';
$active = isset($_POST['active']) ? $_POST['active'] : 0;
$role = isset($_POST['role']) ? $_POST['role'] : '';
$extra1 = isset($_POST['extra1']) ? $_POST['extra1'] : '';
$extra2 = isset($_POST['extra2']) ? $_POST['extra2'] : '';
$extra3 = isset($_POST['extra3']) ? $_POST['extra3'] : '';
$extra4 = isset($_POST['extra4']) ? $_POST['extra4'] : '';
$extra5 = isset($_POST['extra5']) ? $_POST['extra5'] : '';
$extra6 = isset($_POST['extra6']) ? $_POST['extra6'] : '';
$extra7 = isset($_POST['extra7']) ? $_POST['extra7'] : '';
$extra8 = isset($_POST['extra8']) ? $_POST['extra8'] : '';
$extra9 = isset($_POST['extra9']) ? $_POST['extra9'] : '';
$extra10 = isset($_POST['extra10']) ? $_POST['extra10'] : '';
$extra11 = isset($_POST['extra11']) ? $_POST['extra11'] : '';
$extra12 = isset($_POST['extra12']) ? $_POST['extra12'] : '';
$extra13 = isset($_POST['extra13']) ? $_POST['extra13'] : '';
$extra14 = isset($_POST['extra14']) ? $_POST['extra14'] : '';
$extra15 = isset($_POST['extra15']) ? $_POST['extra15'] : '';
$avatar_folder = 'avatars';
$avatar = '';
if (isset($_FILES['avatar']) && $_FILES['avatar']['name'] != "")
{
$error_message = '';
if (!file_exists($avatar_folder))
{
if (!mkdir($avatar_folder, 0777))
{
die("Failed to create images directory.");
}
}
switch ($_FILES['avatar']['error'])
{
case UPLOAD_ERR_OK:
if ($_FILES['avatar']['type'] == 'image/gif' || $_FILES['avatar']['type'] == 'image/jpeg' || $_FILES['avatar']['type'] == 'image/pjpeg' || $_FILES['avatar']['type'] == 'image/png' || $_FILES['avatar']['type'] == 'image/x-png')
{
$prefix = rand(111111, 999999);
$avatar = $prefix . "_" . str_replace(" ", "_", $_FILES['avatar']['name']);
if (!move_uploaded_file($_FILES['avatar']['tmp_name'], $avatar_folder . "/" . $avatar))
{
$error_message = "Upload failed, please verify the folder's permissions.";
}
}
else
{
$error_message = "Wrong file type, please only use jpg, gif or png images.";
}
break;
case UPLOAD_ERR_INI_SIZE:
$error_message = "The uploaded file exceeds the 'upload_max_filesize' directive.";
break;
case UPLOAD_ERR_FORM_SIZE:
$error_message = "The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form.";
break;
case UPLOAD_ERR_PARTIAL:
$error_message = "The uploaded file was only partially uploaded.";
break;
case UPLOAD_ERR_NO_FILE:
$error_message = "No file was uploaded.";
break;
case UPLOAD_ERR_NO_TMP_DIR:
$error_message = "Missing a temporary folder.";
break;
case UPLOAD_ERR_CANT_WRITE:
$error_message = "Failed to write file to disk.";
break;
case UPLOAD_ERR_EXTENSION:
$error_message = "File upload stopped by extension.";
break;
}
if ($error_message != '')
{
die($error_message);
}
}
$db = mysqli_connect($mysql_server, $mysql_username, $mysql_password);
if (!$db)
{
die('Failed to connect to database server!<br>'.mysqli_error($db));
}
mysqli_select_db($db, $mysql_database) or die('Failed to select database<br>'.mysqli_error($db));
mysqli_set_charset($db, 'utf8');
mysqli_query($db, 'SET NAMES "UTF8"');
mysqli_query($db, "SET collation_connection='utf8_general_ci'");
mysqli_query($db, "SET collation_server='utf8_general_ci'");
mysqli_query($db, "SET character_set_client='utf8'");
mysqli_query($db, "SET character_set_connection='utf8'");
mysqli_query($db, "SET character_set_results='utf8'");
mysqli_query($db, "SET character_set_server='utf8'");
if (!empty($action))
{
if ($action == 'delete')
{
$sql = "DELETE FROM ".$mysql_table." WHERE `username` = '$id'";
mysqli_query($db, $sql);
mysqli_close($db);
header('Location: '.basename(__FILE__));
exit;
}
else
if ($action == 'update')
{
$sql = "UPDATE `".$mysql_table."` SET `username` = '$username', ";
if (!empty($_POST['password']))
{
$crypt_pass = md5($_POST['password']);
$sql = $sql . "`password` = '$crypt_pass',";
}
if (!empty($avatar))
{
$sql = $sql . "`avatar` = '$avatar',";
}
$sql = $sql . " `fullname` = '$fullname', `email` = '$email', `role` = '$role', `active` = $active, `extra1` = '$extra1', `extra2` = '$extra2', `extra3` = '$extra3', `extra4` = '$extra4', `extra5` = '$extra5', `extra6` = '$extra6', `extra7` = '$extra7', `extra8` = '$extra8', `extra9` = '$extra9', `extra10` = '$extra10', `extra11` = '$extra11', `extra12` = '$extra12', `extra13` = '$extra13', `extra14` = '$extra14', `extra15` = '$extra15' WHERE `username` = '$id'";
mysqli_query($db, $sql);
mysqli_close($db);
header('Location: '.basename(__FILE__));
exit;
}
else
if ($action == 'create')
{
$sql = "SELECT username FROM ".$mysql_table." WHERE username = '".$_POST['username']."'";
$result = mysqli_query($db, $sql);
if ($data = mysqli_fetch_array($result))
{
echo 'User already exists!';
exit;
}
$crypt_pass = md5($_POST['password']);
$avatar_column = '';
$avatar_value = '';
if (!empty($avatar))
{
$avatar_column = ", `avatar`";
$avatar_value = ", '$avatar'";
}
$sql = "INSERT `".$mysql_table."` (`username`, `password`, `fullname`, `email`, `role`, `active`, `extra1`, `extra2`, `extra3`, `extra4`, `extra5`, `extra6`, `extra7`, `extra8`, `extra9`, `extra10`, `extra11`, `extra12`, `extra13`, `extra14`, `extra15`$avatar_column) VALUES ('$username', '$crypt_pass', '$fullname', '$email', '$role', $active, '$extra1', '$extra2', '$extra3', '$extra4', '$extra5', '$extra6', '$extra7', '$extra8', '$extra9', '$extra10', '$extra11', '$extra12', '$extra13', '$extra14', '$extra15'$avatar_value)";
mysqli_query($db, $sql);
mysqli_close($db);
header('Location: '.basename(__FILE__));
exit;
}
else
if ($action == 'logout')
{
session_unset();
session_destroy();
setcookie('admin_password', '', time() - 3600);
header('Location: '.basename(__FILE__));
exit;
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>User Administrator</title>
<style type="text/css">
*
{
box-sizing: border-box;
}
body
{
background-color: #FFFFFF;
margin: 6px;
font-size: 16px;
font-family: Arial;
font-weight: normal;
text-decoration: none;
color: #000000;
}
th
{
font-size: 16px;
font-family: Arial;
font-weight: normal;
text-decoration: none;
background-color: #89BDD3;
color: #FFFFFF;
text-align: left;
}
td
{
font-size: 16px;
font-family: Arial;
font-weight: normal;
text-decoration: none;
color: #000000;
}
input, select
{
font-size: 16px;
font-family: Arial;
font-weight: normal;
text-decoration: none;
color: #000000;
border:1px #000000 solid;
}
.clickable
{
cursor: pointer;
}
.container
{
max-width: 768px;
margin: 0 auto 0 auto;
padding: 15px;
text-align: left;
width: 100%;
}
td, th
{
padding: 0;
}
.table
{
background-color: transparent;
border: 1px solid #DDDDDD;
border-collapse: collapse;
border-spacing: 0;
max-width: 100%;
width: 100%;
}
.table > thead > tr > th, .table > tbody > tr > th, .table > tfoot > tr > th, .table > thead > tr > td, .table > tbody > tr > td, .table > tfoot > tr > td
{
padding: 8px;
line-height: 1.4285;
vertical-align: top;
border-top: 1px solid #DDDDDD;
}
.table > thead > tr > th
{
vertical-align: bottom;
border-bottom: 2px solid #DDDDDD;
}
.table > caption + thead > tr:first-child > th, .table > colgroup + thead > tr:first-child > th, .table > thead:first-child > tr:first-child > th, .table > caption + thead > tr:first-child > td, .table > colgroup + thead > tr:first-child > td, .table > thead:first-child > tr:first-child > td
{
border-top: 0;
}
.table-hover > tbody > tr:hover > td
{
background-color: #F5F5F5;
}
.table-striped>tbody>tr:nth-child(odd)>td
{
background-color: #F9F9F9;
}
th
{
background-color: #89BDD3;
color: #FFFFFF;
font-weight: bold;
}
.form-control
{
display: block;
width: 100%;
margin-bottom: 15px;
padding: 6px 12px;
font-family: Arial;
font-size: 16px;
line-height: 1.4285;
color: #555555;
background-color: #FFFFFF;
background-image: none;
border: 1px solid #CCCCCC;
border-radius: 4px;
box-shadow: inset 0px 1px 1px rgba(0,0,0,0.075);
-webkit-transition: border-color ease-in-out .15s, box-shadow ease-in-out .15s;
transition: border-color ease-in-out .15s, box-shadow ease-in-out .15s;
}
.form-control:focus
{
border-color: #66AFE9;
outline: 0;
box-shadow: inset 0px 1px 1px rgba(0,0,0,0.075), 0px 0px 8px rgba(102,175,233,0.60);
}
label
{
display: block;
padding: 6px 0px;
text-align: left;
}
.btn
{
display: inline-block;
padding: 6px 12px;
margin-bottom: 0px;
font-family: Arial;
font-weight: normal;
font-size: 16px;
text-align: center;
text-decoration: none;
white-space: nowrap;
vertical-align: middle;
cursor: pointer;
-webkit-user-select: none;
-moz-user-select: none;
-ms-user-select: none;
user-select: none;
background-color: #9AD3DE;
border: 1px solid #9AD3DE;
border-radius: 4px;
color: #FFFFFF;
}
#header
{
margin-bottom: 6px;
}
#filter
{
float: right;
}
#filter input
{
display: inline-block;
vertical-align: middle;
width: 16em;
padding: 5px 10px;
}
#filter label
{
display: inline-block;
max-width: 100%;
font-size: 16px;
font-family: Arial;
}
.filter-hide
{
display: none !important;
}
#pagination
{
display: inline-block;
list-style: none;
padding: 0;
border-radius: 4px;
font-family: Arial;
font-weight: normal;
font-size: 0;
}
#pagination > li
{
display: inline;
font-size: 16px;
}
#pagination > li > a, #pagination > li > span
{
position: relative;
float: left;
padding: 6px 12px 6px 12px;
text-decoration: none;
background-color: #FFFFFF;
border: 1px #DDDDDD solid;
color: #9AD3DE;
margin-left: -1px;
}
#pagination > li:first-child > a, #pagination > li:first-child > span
{
margin-left: 0;
border-bottom-left-radius: 4px;
border-top-left-radius: 4px;
}
#pagination > li:last-child > a, #pagination > li:last-child > span
{
border-bottom-right-radius: 4px;
border-top-right-radius: 4px;
}
#pagination > li > a:hover, #pagination > li > span:hover, #pagination > li > a:focus, #pagination > li > span:focus
{
background-color: #CCCCCC;
color: #23527C;
}
#pagination > .active > a, #pagination > .active > span, #pagination > .active > a:hover, #pagination > .active > span:hover, #pagination > .active > a:focus, #pagination > .active > span:focus
{
z-index: 2;
background-color: #9AD3DE;
border-color: #9AD3DE;
color: #FFFFFF;
cursor: default;
}
#pagination > .disabled > span, #pagination > .disabled > span:hover, #pagination > .disabled > span:focus, #pagination > .disabled > a, #pagination > .disabled > a:hover, #pagination > .disabled > a:focus
{
background-color: #FFFFFF;
color: #777777;
cursor: not-allowed;
}
.paginate-show
{
display: table-row;
}
.paginate-hide
{
display: none;
}
#footer
{
margin-top: 10px;
text-align:right;
}
.icon-edit, .icon-delete
{
display: inline-block;
}
.icon-edit::before
{
display: inline-block;
width: 16px;
height: 16px;
content: " ";
background: url('data:image/svg+xml,%3Csvg%20height%3D%2216%22%20width%3D%2216%22%20version%3D%221.1%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%3E%3Cg%20style%3D%22fill%3A%23000000%22%20transform%3D%22scale%280.0089%29%22%3E%0D%0A%3Cpath%20transform%3D%22rotate%28180%29%20scale%28-1%2C1%29%20translate%280%2C-1536%29%22%20d%3D%22M363%200l91%2091l-235%20235l-91%20-91v-107h128v-128h107zM886%20928q0%2022%20-22%2022q-10%200%20-17%20-7l-542%20-542q-7%20-7%20-7%20-17q0%20-22%2022%20-22q10%200%2017%207l542%20542q7%207%207%2017zM832%201120l416%20-416l-832%20-832h-416v416zM1515%201024q0%20-53%20-37%20-90l-166%20-166l-416%20416l166%20165q36%2038%2090%2038q53%200%2091%20-38l235%20-234q37%20-39%2037%20-91z%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E') no-repeat center center;
}
.icon-delete::before
{
display: inline-block;
width: 16px;
height: 16px;
content: " ";
background: url('data:image/svg+xml,%3Csvg%20height%3D%2216%22%20width%3D%2216%22%20version%3D%221.1%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%3E%3Cg%20style%3D%22fill%3A%23000000%22%20transform%3D%22scale%280.0089%29%22%3E%0D%0A%3Cpath%20transform%3D%22rotate%28180%29%20scale%28-1%2C1%29%20translate%280%2C-1536%29%22%20d%3D%22M1298%20214q0%20-40%20-28%20-68l-136%20-136q-28%20-28%20-68%20-28t-68%2028l-294%20294l-294%20-294q-28%20-28%20-68%20-28t-68%2028l-136%20136q-28%2028%20-28%2068t28%2068l294%20294l-294%20294q-28%2028%20-28%2068t28%2068l136%20136q28%2028%2068%2028t68%20-28l294%20-294l294%20294q28%2028%2068%2028t68%20-28l136%20-136q28%20-28%2028%20-68t-28%20-68l-294%20-294l294%20-294q28%20-28%2028%20-68z%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E') no-repeat center center;
}
#avatar *
{
box-sizing: border-box;
}
#avatar
{
display: table;
border-collapse: separate;
border-spacing: 0;
margin-bottom: 15px;
}
#avatar .form-control
{
position: relative;
z-index: 2;
float: left;
width: 100%;
margin-bottom: 0px;
}
#avatar .input-group-btn, #avatar .form-control
{
display: table-cell;
}
#avatar .form-control
{
border-bottom-right-radius: 0px;
border-top-right-radius: 0px;
margin: 0;
}
#avatar .input-group-btn
{
width: 1%;
white-space: nowrap;
vertical-align: middle;
padding: 0;
position: relative;
font-size: 0px;
white-space: nowrap;
}
#avatar .btn
{
border-bottom-left-radius: 0px;
border-top-left-radius: 0px;
display: inline-block;
margin-left: -1px;
padding: 6px 8px 6px 8px;
position: relative;
}
.thumbnail
{
display: inline-block;
min-height: 1px;
box-sizing: border-box;
margin: 0;
padding: 6px 0 14px 0;
text-align: center;
vertical-align: top;
}
.thumbnail .frame
{
padding: 4px;
background-color: #fff;
border: 1px #DDDDDD solid;
border-radius: 4px;
}
.thumbnail img
{
border-width: 0;
display: block;
width: 100%;
height: auto;
max-width: 100%;
box-sizing: border-box;
}
</style>
<script type="text/javascript" src="jquery-1.12.4.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$('#filter input').on('propertychange input', function(e)
{
$('.no-results').remove();
var $this = $(this);
var search = $this.val().toLowerCase();
var $target = $('.table');
var $rows = $target.find('tbody tr');
if (search == '')
{
$rows.removeClass('filter-hide');
buildNav();
paginate();
}
else
{
$rows.each(function()
{
var $this = $(this);
$this.text().toLowerCase().indexOf(search) === -1 ? $this.addClass('filter-hide') : $this.removeClass('filter-hide');
})
buildNav();
paginate();
if ($target.find('tbody tr:visible').size() === 0)
{
var col_span = $target.find('tr').first().find('td').size();
var no_results = $('<tr class="no-results"><td colspan="'+col_span+'"></td></tr>');
$target.find('tbody').append(no_results);
}
}
});
$('.table').each(function()
{
var currentPage = 0;
var numPerPage = 10;
var $table = $(this);
var numRows = $table.find('tbody tr').length;
var numPages = Math.ceil(numRows / numPerPage);
var $pagination = $('#pagination');
paginate = function()
{
$pagination.find('li').eq(currentPage+1).addClass('active').siblings().removeClass('active');
var $prev = $pagination.find('li:first-child');
var $next = $pagination.find('li:last-child');
if (currentPage == 0)
{
$prev.addClass('disabled');
}
else
{
$prev.removeClass('disabled');
}
if (currentPage == (numPages-1))
{
$next.addClass('disabled');
}
else
{
$next.removeClass('disabled');
}
$table.find('tbody tr').not('.filter-hide').removeClass('paginate-show').addClass('paginate-hide').slice(currentPage * numPerPage, (currentPage + 1) * numPerPage).removeClass('paginate-hide').addClass('paginate-show');;
};
buildNav = function()
{
numRows = $table.find('tbody tr').not('.filter-hide').length;
numPages = Math.ceil(numRows / numPerPage);
$pagination.find('li').not($pagination.find('li:first-child')).not($pagination.find('li:last-child')).remove();
for (var page = 0; page < numPages; page++)
{
var item = '<a>' + (page + 1) + '</a>';
$('<li></li>').html(item)
.bind('click', {newPage: page}, function(event)
{
currentPage = event.data['newPage'];
paginate();
}).appendTo($pagination).addClass('clickable');
}
$pagination.find('li').eq(1).appendTo($pagination);
}
buildNav();
$pagination.find('li:nth-child(2)').addClass('active');
$pagination.find('li:first-child').click(function()
{
if (currentPage > 0)
{
currentPage--;
}
paginate();
});
$pagination.find('li:last-child').click(function()
{
if (currentPage < (numPages-1))
{
currentPage++;
}
paginate();
});
paginate();
});
$("#avatar :file").on('change', function()
{
var input = $(this).parents('.input-group').find(':text');
input.val($(this).val());
});
});
</script>
</head>
<body>
<?php
if ($admin_password != ADMIN_PASS)
{
echo "<div class=\"container\" style=\"text-align:center\">\n";
echo "<h2>User Administrator</h2>\n";
echo "<form method=\"post\" accept-charset=\"UTF-8\" action=\"" .basename(__FILE__) . "\">\n";
echo "<input class=\"form-control\" type=\"password\" name=\"admin_password\" size=\"20\" />\n";
echo "<input class=\"btn\" type=\"submit\" value=\"Login\" name=\"submit\" />\n";
echo "</form>\n";
echo "</div>\n";
}
else
{
if (!empty($action))
{
if (($action == 'edit') || ($action == 'new'))
{
$username_value = '';
$fullname_value = '';
$email_value = '';
$active_value = '';
$avatar_value = '';
$role_value = '';
$extra1_value = '';
$extra2_value = '';
$extra3_value = '';
$extra4_value = '';
$extra5_value = '';
$extra6_value = '';
$extra7_value = '';
$extra8_value = '';
$extra9_value = '';
$extra10_value = '';
$extra11_value = '';
$extra12_value = '';
$extra13_value = '';
$extra14_value = '';
$extra15_value = '';
$sql = "SELECT * FROM ".$mysql_table." WHERE username = '".$id."'";
$result = mysqli_query($db, $sql);
if ($data = mysqli_fetch_array($result))
{
$username_value = $data['username'];
$fullname_value = $data['fullname'];
$email_value = $data['email'];
$active_value = $data['active'];
$avatar_value = $data['avatar'];
$role_value = $data['role'];
$extra1_value = $data['extra1'];
$extra2_value = $data['extra2'];
$extra3_value = $data['extra3'];
$extra4_value = $data['extra4'];
$extra5_value = $data['extra5'];
$extra6_value = $data['extra6'];
$extra7_value = $data['extra7'];
$extra8_value = $data['extra8'];
$extra9_value = $data['extra9'];
$extra10_value = $data['extra10'];
$extra11_value = $data['extra11'];
$extra12_value = $data['extra12'];
$extra13_value = $data['extra13'];
$extra14_value = $data['extra14'];
$extra15_value = $data['extra15'];
}
echo "<div class=\"container\">\n";
echo "<form action=\"" . basename(__FILE__) . "\" enctype=\"multipart/form-data\" accept-charset=\"UTF-8\" method=\"post\">\n";
if ($action == 'new')
{
echo "<input name=\"action\" type=\"hidden\" value=\"create\">\n";
}
else
{
echo "<input name=\"action\" type=\"hidden\" value=\"update\">\n";
}
echo "<input type=\"hidden\" name=\"id\" value=\"". $id . "\">\n";
echo "<label for=\"username\">Username</label>\n";
echo "<input class=\"form-control\" id=\"username\" name=\"username\" size=\"50\" type=\"text\" value=\"" . $username_value . "\">\n";
echo "<label for=\"password\">Password</label>\n";
echo "<input class=\"form-control\" id=\"password\" name=\"password\" size=\"50\" type=\"password\" value=\"\">\n";
echo "<label for=\"fullname\">Fullname</label>\n";
echo "<input class=\"form-control\" id=\"fullname\" name=\"fullname\" size=\"50\" type=\"text\" value=\"" . $fullname_value . "\">\n";
echo "<label for=\"email\">Email</label>\n";
echo "<input class=\"form-control\" id=\"email\" name=\"email\" size=\"50\" type=\"text\" value=\"" . $email_value . "\">\n";
echo "<label for=\"role\">Role</label>\n";
echo "<select class=\"form-control\" id=\"role\" name=\"role\" size=\"1\">\n";
$roles = array("Administrator","Member","Guest");
for ($i=0; $i<count($roles); $i++)
{
$selected = ($roles[$i] == $role_value) ? "selected" : "";
echo "<option value=\"$roles[$i]\" $selected>$roles[$i]</option>\n";
}
echo "</select>\n";
echo "<label for=\"avatar\">Avatar</label>\n";
echo "<div class=\"input-group\" id=\"avatar\"><input class=\"form-control\" type=\"text\" readonly=\"\" value=\"$avatar_value\"><label class=\"input-group-btn\"><input type=\"file\" name=\"avatar\" style=\"display:none;\"><span class=\"btn\">Browse...</span></label></div>\n";
if (!empty($avatar_value))
{
echo "<div class=\"thumbnail\"><div class=\"frame\"><img alt=\"$avatar_value\" src=\"$avatar_folder/$avatar_value\"></div></div>\n";
}
echo "<label for=\"extra1\">Studio Name</label>\n";
echo "<input class=\"form-control\" id=\"extra1\" name=\"extra1\" size=\"50\" type=\"text\" value=\"" . $extra1_value . "\">\n";
echo "<label for=\"extra2\">Contact Name</label>\n";
echo "<input class=\"form-control\" id=\"extra2\" name=\"extra2\" size=\"50\" type=\"text\" value=\"" . $extra2_value . "\">\n";
echo "<label for=\"extra3\">Address</label>\n";
echo "<input class=\"form-control\" id=\"extra3\" name=\"extra3\" size=\"50\" type=\"text\" value=\"" . $extra3_value . "\">\n";
echo "<label for=\"extra4\">City</label>\n";
echo "<input class=\"form-control\" id=\"extra4\" name=\"extra4\" size=\"50\" type=\"text\" value=\"" . $extra4_value . "\">\n";
echo "<label for=\"extra5\">State</label>\n";
echo "<input class=\"form-control\" id=\"extra5\" name=\"extra5\" size=\"50\" type=\"text\" value=\"" . $extra5_value . "\">\n";
echo "<label for=\"extra6\">Zip</label>\n";
echo "<input class=\"form-control\" id=\"extra6\" name=\"extra6\" size=\"50\" type=\"text\" value=\"" . $extra6_value . "\">\n";
echo "<label for=\"extra7\">Business Phone 1</label>\n";
echo "<input class=\"form-control\" id=\"extra7\" name=\"extra7\" size=\"50\" type=\"text\" value=\"" . $extra7_value . "\">\n";
echo "<label for=\"extra8\">Business Phone 2</label>\n";
echo "<input class=\"form-control\" id=\"extra8\" name=\"extra8\" size=\"50\" type=\"text\" value=\"" . $extra8_value . "\">\n";
echo "<label for=\"extra9\">Home Phone - will not be on Referral Page</label>\n";
echo "<input class=\"form-control\" id=\"extra9\" name=\"extra9\" size=\"50\" type=\"text\" value=\"" . $extra9_value . "\">\n";
echo "<label for=\"extra10\">Cell Phone - will not be on Referral Page</label>\n";
echo "<input class=\"form-control\" id=\"extra10\" name=\"extra10\" size=\"50\" type=\"text\" value=\"" . $extra10_value . "\">\n";
echo "<label for=\"extra11\">Specialities - What services do you offer?</label>\n";
echo "<input class=\"form-control\" id=\"extra11\" name=\"extra11\" size=\"50\" type=\"text\" value=\"" . $extra11_value . "\">\n";
echo "<label for=\"extra12\">Description - Add something informative to prospective clients</label>\n";
echo "<input class=\"form-control\" id=\"extra12\" name=\"extra12\" size=\"50\" type=\"text\" value=\"" . $extra12_value . "\">\n";
echo "<label for=\"extra13\">Web Address</label>\n";
echo "<input class=\"form-control\" id=\"extra13\" name=\"extra13\" size=\"50\" type=\"text\" value=\"" . $extra13_value . "\">\n";
echo "<label for=\"extra14\">Current Member (yes/no)</label>\n";
echo "<input class=\"form-control\" id=\"extra14\" name=\"extra14\" size=\"50\" type=\"text\" value=\"" . $extra14_value . "\">\n";
echo "<label for=\"extra15\">Website Ad (yes/no)</label>\n";
echo "<input class=\"form-control\" id=\"extra15\" name=\"extra15\" size=\"50\" type=\"text\" value=\"" . $extra15_value . "\">\n";
echo "<label for=\"active\">Status</label>\n";
echo "<select class=\"form-control\" name=\"active\" size=\"1\"><option " . ($active_value == "0" ? "selected " : "") . "value=\"0\">inactive</option><option " . ($active_value != "0" ? "selected " : "") . "value=\"1\">active</option></select>\n";
echo "<input class=\"btn\" type=\"submit\" name=\"cmdSubmit\" value=\"Save\">";
echo " ";
echo "<input class=\"btn\" name=\"cmdBack\" type=\"button\" value=\"Cancel\" onclick=\"location.href='" . basename(__FILE__) . "'\">\n";
echo "</form>\n";
echo "</div>\n";
}
}
else
{
echo "<div id=\"header\"><a class=\"btn\" href=\"" . basename(__FILE__) . "?action=new\">New User</a> <a class=\"btn\" href=\"" . basename(__FILE__) . "?action=logout\">Logout</a>\n";
echo "<div id=\"filter\">\n";
echo "<label>Search: </label> <input class=\"form-control\" placeholder=\"\" type=\"search\">\n";
echo "</div>\n</div>\n";
echo "<table class=\"table table-striped table-hover\">\n";
echo "<thead><tr><th>Username</th><th>Fullname</th><th>Email</th><th>Status</th><th>Action</th></tr></thead>\n";
echo "<tbody>\n";
$sql = "SELECT * FROM ".$mysql_table;
$result = mysqli_query($db, $sql);
while ($data = mysqli_fetch_array($result))
{
echo "<tr>\n";
echo "<td>" . $data['username'] . "</td>\n";
echo "<td>" . $data['fullname'] . "</td>\n";
echo "<td>" . $data['email'] . "</td>\n";
echo "<td>" . ($data['active'] == "0" ? "inactive" : "active") . "</td>\n";
echo "<td>\n";
echo " <a href=\"" . basename(__FILE__) . "?action=edit&id=" . $data['username'] . "\" title=\"Edit\"><i class=\"icon-edit\"></i></a> \n";
echo " <a href=\"" . basename(__FILE__) . "?action=delete&id=" . $data['username'] . "\" title=\"Delete\"><i class=\"icon-delete\"></i></a>\n";
echo "</td>\n";
echo "</tr>\n";
}
echo "</tbody>\n";
echo "</table>\n";
echo "<div id=\"footer\">\n";
echo "<ul id=\"pagination\">\n";
echo "<li class=\"disabled\"><a href=\"#\">« Prev</a></li>\n";
echo "<li class=\"disabled\"><a href=\"#\">Next »</a></li>\n";
echo "</ul>\n";
echo "</div>\n";
}
}
?>
</body>
</html>
