Admin viewer to access all users

Hey Bkerns,

So this is for the front end of the website, and you want to show admin users all records, but filter non-admin users to their own records only?

If so, you could do something like this:

<?php

#1) Include the viewer functions
include_once 'cmsb/lib/viewer_functions.php';

#2) Redirect the user to the login page if they're not logged in.
if (!$CURRENT_USER) { websiteLogin_redirectToLogin(); }

#3) Create a where statement that checks if the user is an admin, if they're not filter the records to only display their own.
$where = "";
if(!$CURRENT_USER['isAdmin']) {
$where = "`createdByUserNum` = ".intval($CURRENT_USER['num']) ;
}

#4) Get the account records and filter using the where statement.
list($accountsRecords, $accountsMetaData) = getRecords(array(
'tableName' => 'accounts',
'where' => $where,
'loadUploads' => true,
'allowSearch' => false,
));

Note: This is example code, so you might need to make a few changes to get it working.

So the code above will create a where filter statement in the variable $where that only shows the user their own records if they're not an admin account. This is then passed into the getRecords function that will return an array of account records.

If you don't want to add this where statement into the getRecords function and would prefer to use the MySQL statement in your previous post, you'll just need to add the where statement into it instead.

Thanks,

Greg