What next?

[keepingbusy]

Hello guys

I am looking for "What next?" in this scenario:

I have a secure area on a server set up for a members only area which is working fine. This can limit members to certain pages if required and has been tested.
I have access to more than one MySql table if required.
On our server we have a table (call it mytable for this scenario) that holds information relating to individual members.

I need to know how to allow members to access information once they have logged in to the members only area. I can use the same table if it is easier by adding the fields required via phpmyadmin.

I have looked at companies such as

http://www.interlogy.com

Would this be the sort of thing I would need to accomplish the job?

So my question is, what next?

Thank you

 

[RhythmAce]

You wouldn't give access to the user directly. That would be inviting mischief. You would set permissions and privileges for that table or database to one user/password. A script would access the table as that user. Once a user is logged in and verified, they can have access to the script else they are locked out.

 

[keepingbusy]

Hi RhythmAce

You wouldn't give access to the user directly. That would be inviting mischief. You would set permissions and privileges for that table or database to one user/password. A script would access the table as that user.

That is what I am trying to achieve by allowing a user to log in but once in, only have access to their own details/data contained within that table.

It is at the log in point where I want to show the fields contained in the table that relate to that person only so they can change them if required.

I hope that makes sense (wish this was a FoxPro project!)

Lee

 

[RhythmAce]

Oh, I see. You still don't want them to have direct access to the database. If I understand correcly, you want them just to be able to edit their own 'profile". This would still be done via script. The script would be used to modify the user's data. Each user's record would have to have a field which is unique to each record. In most cases, the key is an ID number or the user's name itself.

 

[jpadie]

@keepingbusy

are you still using my code for the login handler? if so which version? if not which code are you using?

 

[keepingbusy]

RhythmAce

You still don't want them to have direct access to the database. If I understand correcly, you want them just to be able to edit their own 'profile". This would still be done via script. The script would be used to modify the user's data. Each user's record would have to have a field which is unique to each record. In most cases, the key is an ID number or the user's name itself.

Yes, that is what I am after. For users to log in and change their own data.

jpadie

are you still using my code for the login handler? if so which version? if not which code are you using?

Sorry, but I couldn't use your code in the end. I have no doubt it worked but I am now using something called sitelok which works great and was relatively easy to set up (for people like me who don't have much experience in this line)

RhythmAce, am I a bit clearer with what I'm trying to achieve?

Lee

 

[jpadie]

wow. that costs 40 bucks! for a page protection script!! i'm in the wrong job...

well, as the manual is formware only, and i'm not prepared to pay for the code, it's going to be difficult to advise you on how to customise the user data script. why not approach the writers?

 

[RhythmAce]

I thought so until you brought up that sitelok thing. Now I'm confused again. ;-) Are you saying you need help creating a script that will allow users to edit their profile or is that what sitelok does? If it's the former, let me make a suggestion. Try to find a script that does pretty much what you want then hack it for your needs. There are plenty of resources out there. Here are just a couple:

http://php.resourceindex.com

http://www.hotscripts.com/PHP/index.html

 

[keepingbusy]

jpadie

wow. that costs 40 bucks! for a page protection script!! i'm in the wrong job...

Maybe you are but I have to say it was the easiest and most user friendly set up I found. Even down to adding variables after someone logs in to a secure area. As a novice to php and MySql I am looking to build up my knowledge piece by piece and when I get experienced like you guys, then things may be different.

RhythmAce

If it's the former, let me make a suggestion.

Yes. I am sorry if I haven't made this clear but in the meantime, I have downloaded a script from HotScripts and I'll try that.

It states, "With this tool you can easily create a web forms to insert/update/delete data in a MySQL database"

That's what I want to do after someone logs in to the "Members only" area which has already been set up using Sitelok.

I hope that now makes some sort of sense and thanks for the links you posted. That gave me some idea where to look.

Kind regards

Lee

 

[jpadie]

Lee
follow this link to a CRUD application that i wrote for a member of tektips.
thread434-1254677

 

[keepingbusy]

Thanks jpadie, I'll take a look over the weekend

Lee