How to build alumni type website using ASPRunner/ PHPRunner.

I have over 40 years of alumni using on my website.
Usual website visitors can see the part of information from this database only. Registered members can see all information about graduates. Also I need people who are from a certain class year to be global admins for their year - not other years.
Is this possible?

You can solve this problem as follows:

With program build three different projects on the basis of the main table and put generated files into three different directories.
guest - common access, readonly, no password required.
user - full readonly access, password required.
admin - full access to his graduation year, password required.

First project is for common access. For example, users can view only name of the person and graduation year.
To do it, on the Key column tab in program uncheck Edit, Add new, Delete, and Copy functions for the main table, and on the Formatting tab uncheck fields that users should not see.

Second project is for registered users.
Create Users table with Name and Password fields - in this table you will store data on registered users that have right to view all data in the database.
On the Key column tab in program uncheck Edit, Add new, Delete, and Copy functions for the main table. Set Security settings as Username and password from database, using Users table.

Third project is for administrators that will have full access to the 40 years of alumni database - edit and make changes in the records of their graduation year.
Create Admins table with Graduation year, Name, and Password fields - in this table you will store admin users data.
Set Security settings as Users can see other users data, can edit their own data only or Users can see and edit their own data only and link main table to Admins table with Graduation year field.

Now you can route your site's visitors to the appropriate project as per their access level.

Applies to:
ASPRunner Pro
ASPRunner.NET
PHPRunner

Back to top