Page 1 of 1

Code to add to group for MySQL

Posted: Fri Jul 21, 2006 12:17 pm
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

Posted: Fri Jul 21, 2006 12:48 pm
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??

Posted: Fri Jul 21, 2006 1:03 pm
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.

Posted: Fri Jul 21, 2006 1:07 pm
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???

Posted: Fri Jul 21, 2006 10:26 pm
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.

Posted: Mon Jul 24, 2006 11:47 am
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???

Posted: Mon Jul 24, 2006 11:59 am
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.

Posted: Mon Jul 24, 2006 12:06 pm
by Assured99
What would be some reccomended gateways i can use??

Posted: Mon Jul 24, 2006 12:11 pm
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)?

Posted: Mon Jul 24, 2006 12:28 pm
by Assured99
Credit Card/check card Only

i would say 90% of our payments are collected by them

Posted: Mon Jul 24, 2006 12:37 pm
by feyd
that's a payment type/method, not a payment processor -- the company that is the payment clearinghouse.

Posted: Mon Jul 24, 2006 12:37 pm
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.

Posted: Mon Jul 24, 2006 12:39 pm
by Assured99
ok so just contact the company that works with the CC machine we have in the office for a gateway ???

Posted: Mon Jul 24, 2006 12:42 pm
by RobertGonzalez
Yeah, ask them what kind of internet based processing systems they offer.

Posted: Mon Jul 24, 2006 1:01 pm
by Assured99
Sweet Deal Thanks Everah :idea: