2. PHPRunner General questions
  3. Data Modification
This topic is locked

Data Modification

 		6/2/2005 7:49:44 AM
PHPRunner General questions
J
 jlann author

I may have not been clear in my last post. I am building a app that would allow users to edit their own login information. However, I don't want them to see any other users login information and they should definately not be able to edit other users login information.
At the same time, I need users to be able to create, edit and delete data in the rest of the database.
Is this possible with PHPrunner. I'm on eval right now, but I have multiple databases that need to be web accessible. Any help would be greatly appreciated. If anyone needs more information please don't hesitate to ask.
Thanks!!!
pplaut 6/2/2005

You want them to see only their own record? And to be able to see only their own record?

You can do that with PHPRunner.

I did this by simply making the "master" table the login table.

You need to make sure you have the latest download of PHPRunner though.

If you do this however, keep in mind when the user "adds" himself, there is not way in PHPRunner to create the "label" definitions for the fields.
It looks like we have to do this by hand, and I am working on this now.
Peer
Sergey Kornilov admin 6/6/2005

Hi,
you can use Advanced Security mode for this purpose.

  1. Select your username/password table on Datasource table tab in PHPRunner
  2. Go forward to Security tab
  3. Check off Create login page, select Username and password from database, select your login/password table, username and password fields
  4. Click Advanced button
  5. Select Users can see and edit their own data only, select the same field in two comboboxes below. This field must be a primary key for username/password table or the username field.
  6. Click OK, return to Datasource table tab and proceed with other tables.

    This mode will affect only your username/password table