Code to add to group for MySQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Assured99
Forum Commoner
Posts: 81
Joined: Wed Jul 12, 2006 11:48 am
Location: California

Code to add to group for MySQL

Post by Assured99 »

Ok here is my situation everyone has been very helpfull so here is my next question.

I downloaded a script to create a secure login for Patients and Referral sources, when they register i would like to add a series of raido buttons that would allow the register to select if they are a Referral or a Patient and then only give them access to the area specified for their group.

I would also like to restrict them access untill the Administrator (me) grants them access so i can verify their credentials.

Any ideas on a script i can use for this or any other reccommendations to make this happen??

Thanks

~Snapple
User avatar
Assured99
Forum Commoner
Posts: 81
Joined: Wed Jul 12, 2006 11:48 am
Location: California

Post by Assured99 »

Well if this is any help MySQL Database is set up with the Fields Group1 Group2 and Group3 im assuming it would be soemthing like
if Employee
Than Group1
Etc...


Am i correct??
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

I doubt there is an out of the box package like this. There are few parts to this that you will need to tackle. The first is taking their stated group. The next is verifying that. The third is a queue for admins to approve and the fourth is the sectioned login areas. You may want to take this a step at a time and build it yourself.
User avatar
Assured99
Forum Commoner
Posts: 81
Joined: Wed Jul 12, 2006 11:48 am
Location: California

Post by Assured99 »

You may want to take this a step at a time and build it yourself.
Yeah im just not that cool yet! 8)

I do need a way to all their group to the database i can probally figure that out using a drop down box to select.

How can i stop them from having access untill i approve?

and i can restrict access to pages unless they are in a specific group. but i need to authenticate their group before they log in.

Any Ideas, being that im not Cool enough to Build it yet???
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Assured99 wrote:[How can i stop them from having access untill i approve? and i can restrict access to pages unless they are in a specific group. but i need to authenticate their group before they log in.
Single enum("Yes","No") field or a TinyInt (1 or 0) field named member_approved. Default it to 'No" or 0, then when you approve them. Change that field to "Yes" or 1. Until they show "Yes" or 1, they are not approved entry.
User avatar
Assured99
Forum Commoner
Posts: 81
Joined: Wed Jul 12, 2006 11:48 am
Location: California

Post by Assured99 »

ok i did something similar I gave all people User Access to get to teh secure welcome page, but from the other pages i require group access which wont happen untill i set it up like that.

Also what would i use if i wanted to allow customers to view invoices and pay bills online???
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Assured99 wrote:Also what would i use if i wanted to allow customers to view invoices and pay bills online???
Viewing invoices, not much. Paying invoices, a heck of a lot more involved if doing it through your site. If running them through a gateway, then that is a fairly simple implementation of the software/web API's given by the gateway.
User avatar
Assured99
Forum Commoner
Posts: 81
Joined: Wed Jul 12, 2006 11:48 am
Location: California

Post by Assured99 »

What would be some reccomended gateways i can use??
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Depends on the payment processor. How did you plan on allowing your users to make payments on your system (I mean as far as actually collecting monies)?
User avatar
Assured99
Forum Commoner
Posts: 81
Joined: Wed Jul 12, 2006 11:48 am
Location: California

Post by Assured99 »

Credit Card/check card Only

i would say 90% of our payments are collected by them
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

that's a payment type/method, not a payment processor -- the company that is the payment clearinghouse.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

So I would say contact the company that is actually processing the credit card fund transfers from the user to your bank account and ask them for a gateway. They should be able to help you with that.
User avatar
Assured99
Forum Commoner
Posts: 81
Joined: Wed Jul 12, 2006 11:48 am
Location: California

Post by Assured99 »

ok so just contact the company that works with the CC machine we have in the office for a gateway ???
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Yeah, ask them what kind of internet based processing systems they offer.
User avatar
Assured99
Forum Commoner
Posts: 81
Joined: Wed Jul 12, 2006 11:48 am
Location: California

Post by Assured99 »

Sweet Deal Thanks Everah :idea:
Post Reply