2. PHPRunner General questions
  3. Update single record
This topic is locked

Update single record

 		9/19/2011 4:56:54 AM
PHPRunner General questions
S
 slotracer author

Hello, I want to do the following, is it possible please -
I have a list of members of a group in a table and I want to allow the user to update his/her own record. I want to display a form (or similar) asking the user to input a key value relating to his record. I then want to bring up the record associated with the value for the user to be able to modify it and replace the record on the database.
I have already done this on my current system by hand coding the PHP, but I would like to make the appearance consistent with the theme and color scheme I am using in PHPRunner.
Thanks.
C
 		cgphp 9/19/2011



I have already done this on my current system by hand coding the PHP, but I would like to make the appearance consistent with the theme and color scheme I am using in PHPRunner.
Thanks.


Do you need help on the theme appearence ?
S
 		slotracer author 9/19/2011

Yes please, how do I create a theme for myself.



Do you need help on the theme appearence ?
C
 		cgphp 9/19/2011

Check the new version of PHPrunner (http://www.asprunner.com/forums/topic/17768-september-16-2011-phprunner-6asprunnerpro-7-beta/). It has a great support for theme customization.
S
 		slotracer author 9/20/2011

I would still like to know if this is possible. I only want to allow a member to update his record ONLY, and no others.

Thanks



Hello, I want to do the following, is it possible please -
I have a list of members of a group in a table and I want to allow the user to update his/her own record. I want to display a form (or similar) asking the user to input a key value relating to his record. I then want to bring up the record associated with the value for the user to be able to modify it and replace the record on the database.
I have already done this on my current system by hand coding the PHP, but I would like to make the appearance consistent with the theme and color scheme I am using in PHPRunner.
Thanks.
C
 		cgphp 9/20/2011

It is not very clear what you want to do. Do you need help on theme appearence or what else ?
S
 		slotracer author 9/20/2011

I'm sorry if it's not very clear, let me try again.

I have a table containing details of members of an Association. It holds all their address details, telephone numbers, e-mail addresses etc. At time to time these details change when people move home or something.

What I want to be able to do is have a method where an individual can have access to HIS/HER detail record and be able to update it with new or changed details. But they [size="4"]must not[/size] be able to update any other record on the table. I need some method of allowing a user to input a key field to identify the record for updating. I currently do this by displaying a form on a page, asking for a key field to be input and then fetching the record from the table for update (NOT written with PHPRunner, but hand coded).

Is there a way to do this with PHPRunner please.

Thanks



It is not very clear what you want to do. Do you need help on theme appearence or what else ?
C
 		cgphp 9/20/2011

Why not enable the authentication/authorization feature and check the logged in username ?
S
 		slotracer author 9/22/2011

Please can you tell me how to do that. I have restricted a user being able to update his own record by using the security page and having the user login with user/password from a table. BUT, that user is then able to go to another page where all the data is available to update, even though I have used the security page for a 'hard coded' login on this page.

i.e. once a user is logged in he can do anything, anywhere. How can I stop this.

Thanks



Why not enable the authentication/authorization feature and check the logged in username ?
C
 		cgphp 9/22/2011

Check this video tutorial: http://xlinesoft.com/tutorials/security.htm
S
 		stiven 10/1/2011



Hello, I want to do the following, is it possible please -
I have a list of members of a group in a table and I want to allow the user to update his/her own record. I want to display a form (or similar) asking the user to input a key value relating to his record. I then want to bring up the record associated with the value for the user to be able to modify it and replace the record on the database.
I have already done this on my current system by hand coding the PHP, but I would like to make the appearance consistent with the theme and color scheme I am using in PHPRunner.
Thanks.


were you able to do this? if not maybe i can help you there are several ways to do this....
S
 		slotracer author 10/2/2011

Sort of, but it's not exactly as I want it. I'm away on holiday now for 2 weeks so won't be able to comment any further until I get back on 17th October.

Thanks



were you able to do this? if not maybe i can help you there are several ways to do this....