Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Billing - How stupid would I be to...
Old 04-01-2005, 07:39 AM Billing - How stupid would I be to...
Junior Talker

Posts: 4
Trades: 0
I'm starting up a (well trying to) business on a student government grant this summer doing web design/hosting. I was hoping to set up an 'online billing center' but nothing really fits my needs as an automated recurring bill through someone like paypal only allows a set amount, and I would be performing mantainance, updates, etc which would mean each client has their own unique (slighly varied) fee each month. My possible solution is:

This would all be using a 128 SSL connection:

Have a central billing panel which I alone can access. There would be a profile of each client where I can add a set fee whenever I do an update, etc or if they order an additional feature. It would then store the data in a payment table in my database. It would look something like this:

id, hosting_fee, mantainance_fee, additional_fee, applicable_tax_1(0 or 1 value), applicable_tax_2(0 or 1 value), applicable_tax_3(0 or 1 value)

So when I add a half hour for mantainance the mantainance_fee table would be set to 7.50. When I did a full hour, it would select mantainance_fee from the database and then add it to 15.00 and put it back into mantainance_fee (22.50). That would happen for all the applicable fees, and a dynamic invoice would be available for the client. PHP would add together all the fees and then applicable taxes/currency conversion (as specified in the database).

In the clients billing center panel there would be two CC payment options. The first would be to pay themselves via CC by the normal form post method that my eMERCHANT gateway provides, (SSL128 connection to them, they take the $_POST values and process the order based on them) with the dynamic invoice calculating the amount due into the form.

The second option, and this is where it gets iffy, would be to have an 'automatic payment' option whereby the name, credit card number, expiry date, etc is actually stored somewhere in the database. Then, via my billing panel, at the end of the billing cycle (as determined by the date function) the same form as before would be presented to myself, except the customer information would all be filled out through the database (and be un-editable). So it wouldn't be truly automatically payed but as far as the customer would be concerned it would be.


Is it entirely stupid to store credit card information in the database when using SSL 128? I mean isn't that the same technology the big boys use? Is there another option anyone can think of? Thanks
n0dice is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 04-01-2005, 09:13 AM
amw_drizz's Avatar
Ultra Talker

Posts: 340
Name: Jon
Location: New York
Trades: 0
have you looked at ModernBill Web host edition. ? just curious. you can also make a script for on the fly compilation for paypal terms from there dev site.

Try encrypting your database files or locking those config files for your db so no one can see them.
__________________
AMW_Drizz
Dev Machine:: Apache 2.2.6 PHP 5.2.6 MySQL 5.1
amw_drizz is offline
Reply With Quote
View Public Profile Visit amw_drizz's homepage!
 
Old 04-01-2005, 10:28 AM
Junior Talker

Posts: 4
Trades: 0
Oh can they? That would be most usefull, can you please link.
n0dice is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Billing - How stupid would I be to...
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.54364 seconds with 12 queries