This topic is locked

Display own data only

4/12/2009 10:47:24 PM
PHPRunner General questions
H
honda author

We have a simple school website (intranet). How i configure PHPERUNNER so that each student can only display his/her own data after login?
For example : exam result, payment reminder, etc......

vin7102 4/13/2009

Hi SRJ
Welcome!!

PHPRunner makes it very easy but you should set up your tables to include a field that will contain the logged in users name then simply select the Security tab and set up your users and passwords. Then click on the Advanced tab to show the Advanced Security settings form, select the table for which you want to apply the access rights, select the second option button ("Users can see and edit their own data only"). Finally, select the users table (username or id) and the main table (username field or id field) that will be used to verify the records creator (They must have the same values).

You will then have to set up group permissions to complete the process.

There is some good documentation in the manual in regards to this also, Open the PHPRunner Manual and go to Using PHPRunner>>Security and there are a few pages and descriptions on setting it all up
Good Luck

Vince

H
honda author 4/13/2009

Thanks God...

You're genius vince

Hi SRJ

Welcome!!

PHPRunner makes it very easy but you should set up your tables to include a field that will contain the logged in users name then simply select the Security tab and set up your users and passwords. Then click on the Advanced tab to show the Advanced Security settings form, select the table for which you want to apply the access rights, select the second option button ("Users can see and edit their own data only"). Finally, select the users table (username or id) and the main table (username field or id field) that will be used to verify the records creator (They must have the same values).

You will then have to set up group permissions to complete the process.

There is some good documentation in the manual in regards to this also, Open the PHPRunner Manual and go to Using PHPRunner>>Security and there are a few pages and descriptions on setting it all up
Good Luck

Vince