/    Sign up×
Community /Pin to ProfileBookmark

Paid Membership

Copy linkTweet thisAlerts:
Jun 12.2007

Hey. When a member is just registering onto your site. If you want it to be a paid membership how would you make them pay before they got their profile. I am aware you would need some e-commerse script but I’m just wondering how to properly organise it. Thank you for any help

to post a comment
PHP

13 Comments(s) ↴

Copy linkTweet thisAlerts:
@JDM71488Jun 12.2007 — You can use paypal ipn or something equivalent. You can allow the user to create a profile, but it will not be activated until they pay with paypal. Or you can set a date in your database and make them pay by month/year/etc.

When they pay, paypal's ipn will call a script on your Web site behind the scenes and update the database allowing them to login.
Copy linkTweet thisAlerts:
@JavajoobauthorJun 12.2007 — Ah yes and can the Paypal accept credit cards and such? Also you can adjust the periods on the database to limit them to only a month and such. Would they be a method to do that? And yes the activation part was the intended bit
Copy linkTweet thisAlerts:
@JDM71488Jun 12.2007 — You must not be familiar with paypal.com, right? It is loved and hated, but I like it. It will accept credit/debit cards and paypal accounts that are tied to checking and savings accounts. It takes the reliability away from you from storing and securing sensitive information.

If you code this custom you can have any kind of functionality you want.
Copy linkTweet thisAlerts:
@JavajoobauthorJun 13.2007 — Aaaah is it possible you use you own code or script to make profile payments or is Paypal recomended for now? Also can a special funtion deplete a profile's time limit until it has to pay again?
Copy linkTweet thisAlerts:
@JDM71488Jun 13.2007 — Anything is possible as far as functionality... Ex: Your script upon login will check to see if today's date is less than or equal to the date that they need to update. If so they still have an active membership. Otherwise make them pay again.

I only suggested Paypal because I just used it in my new application. The user is redirected to Paypal for payments so its not fancy or anything. For like $20 a month you can accept payments on your Web site that are sent to Paypal behind the scenes. This looks much better but it depends on how well you wish to present your application.

Paypal probably isn't going to be your final method, but as a start it will work.
Copy linkTweet thisAlerts:
@JavajoobauthorJun 13.2007 — Aaah well I was oringinally considering CCBill for something like that at first. And do you set a Expiry Date date box in the database or something like that?
Copy linkTweet thisAlerts:
@JDM71488Jun 13.2007 — It sounds as though you don't really have experience with doing something like this. Without getting too involved in how it's done:

Let's say you are using PHP and MySQL.

Your MySQL database will be designed to hold tables that relate to your application. If you don't have a separate table to log payment history, you can have a field added on to your users table. This field will house the date that their subscription runs out.

Your PHP script will handle all of the logic. It checks to see if today's date is less than or equal to the date that their subscription runs out. If so they proceed to use your application. Otherwise they are required to pay. Upon payment completion, this field is updated with a later date.

Yes, CCBill or an equivalent will work, too. They should provide an API (I don't know from experience) to where you could have a credit card form on your Web site. You will need an SSL certificate for this, too.
Copy linkTweet thisAlerts:
@JavajoobauthorJun 13.2007 — I'll take all this into account. Thank you. You would need to also connect the member to the expiry date as well?
Copy linkTweet thisAlerts:
@JDM71488Jun 13.2007 — Of course. If the "expiry date" field that you use is in a separate table (probably used for logging a history of payments) you need to associate each payment to a user with an "id" field. Otherwise, just add the "expiry date" field on the users table and that should take care of it.
Copy linkTweet thisAlerts:
@JavajoobauthorJun 13.2007 — Aaah. And as long as any two or more tables are joined by an id you can do a query invovling all of them?
Copy linkTweet thisAlerts:
@JDM71488Jun 13.2007 — Yes. Try searching around some. You might enjoy http://www.w3schools.com. It is where I learned PHP and MySQL.
Copy linkTweet thisAlerts:
@JavajoobauthorJun 13.2007 — Oh I have resources on it I was just clarifyinvg
Copy linkTweet thisAlerts:
@JavajoobauthorJun 14.2007 — Can I ask as a side note: Is HTTP the line in the address bar? I know it means Hyper Text Transfer Protocol but I should know more
×

Success!

Help @Javajoob spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.12,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,
)...