AdminUsers.php

<?php

include_once("include/db.php");


# Return list of users
function getAdminUsers($params) {

	$db = connect_db();

	$sql = "SELECT ID, Username, Disabled FROM users";
	$res = $db->query($sql);

	$resultArray = array();

		# loop through rows
		while ($row = $res->fetchObject()) {
			$item = array();

			$item['ID'] = $row->id;
			$item['Username'] = $row->username;
			$item['Disabled'] = $row->disabled;

			# push this row onto array
			array_push($resultArray,$item);
		}

	# get number of rows
	$sql = "SELECT count(*) FROM users";
	$res = $db->query($sql);
	$numResults = $res->fetchColumn();

	return array($numResults,$resultArray);
}

?>