Paid Subscription Service

Question

Hi all,
I need to implement a free and paid subscription service in a Job portal project in PHP.
Can anybody help me knowing,
how to achieve paid subscription service.
I want the job seeker to purchase a plan with given validity, based on which he/she can apply for jobs.
Same goes to a Recruiter which can post a job after subscription.
There will be monthly rates for accessing the features.
I almost finished with free subscription, but quite confused with premium services.
I need to know the database tables or an algorithm to achieve this.
Thanks

Answer 1

Hi Sachin Artani interesting topic, what idea of particular difference would you offer for the premium subscribers? have you considered that only a small number of job seekers would consider a paid service for job seeking? what advantages are there in premium service for both recruiters and job seekers compared to the free version?

Answer 2

Sachin Artani
Maybe consult PayPal for logging users' payment transactions how-to? they will be the one who's keeping the transaction details anyhow ...

Answer 3

Sachin Artani
I haven't experienced using their service tbh, but if they deny use of such internal transaction logging I guess you still have the *rather dull* manual logging way, you can create a subscription table which records subscriber information and subscription period validity date, whenever that subscriber logs in check whether their subscription is still valid. You can also store subscription information in the Recruiter and Candidate table since this information is bound to them individually, I guess ...

Answer 4

Are you crazy man ?
Did you ever tryed to maybe find a job online ?
It is insane that almoust in every website I must register, write down all my data and plus upload tons of stuff.

Do you think that people in addition to all of that will even pay ? A lottery ticket will be more useful imho.

But yeah, as a coding challenge this kinda looks good.

Answer 5

Sachin Artani
Thanks, I guess that would be yours to decide, I mean, what other transactional details are you looking to save? is the transaction related to subscription service only, or others like, maybe a charge/fee from a hired candidate? or something else? it all depends on your needs : )

Answer 6

Sachin Artani
Alright, best of luck with the project : )

Answer 7

Hi Sachin Artani !

Can you please provide more detail as to what part(s) of "premium services. I need to know the database tables or an algorithm to achieve this" is confusing to you?

Answer 8

Part 1:

Hi Janning Ipang ,
It is a job portal for agriculture and related streams.
There are two user roles-
1. Candidate (Job seeker)
2. Employer (Recruiter)

I have created four tables yet -

1. seeker - to store basic info of candidates like name, email password etc.
2. cand_profile - to store detailed info of candidate such as CV, picture, area of interest etc.
3. employer - to store recruiter's basic info
4. jobs - that contain job details along with the recruiter id who post the job

I am almost finished with free services but now I need to upgrade it to a premium one with two subscription facility-
free and premium.

Depends on the subscription, services like ability to apply to any job, getting job alerts etc will be provisioned to premium users. and less features to free one.

For that purpose, I use a column subscription with value 0 (for free) and 1 (for premium) in each seeker row in db. So, that I can differentiate the free and premium candidate.

Continue...

Answer 9

Part 2:

Now I am facing difficulty in database,
How to perform the transactions and how to store the details of transactions of Candidate as well as Employers?

What tables are required? There will be duration for premium users as well. So, how do I perform next steps?

Answer 10

Hi LOGAN SIMONSEN ,
I am not using Stripe. I want to use Paypal.
I am storing data on SQL db for each user.
I am not using auth0 for authentication.
I won't try to re-invent the wheel. Just need to know how to use the readymade wheels...

Answer 11

Are you using Stripe for your payment system? are you storing data on a SQL database for each user? are you using Auth0 for authentication? Don't try to re-invent the wheel.

Answer 12

I think you want to have a separate table for "employers" with a foreign key that relates to the primary key of users table.

as far as keeping record of transactions I know how I could do it with stripe API, but not sure about PayPal. does PayPal store that data and allow you to access via their API?

Answer 13

Ipang
Does PayPal help me for this?
I also want to store the transactional details in my database, so that the expiration of subscription can be used to inform the Candidates/Employers.

Answer 14

Ipang
Creating a subscription table is a good idea.
Rather storing in two different tables, I prefer to create a single 'subscription' table which contains records - userid (candidate or recruiter's id), subscriptiondate and validity.
Then, I check according to your way.
That helps. Thanks.

Answer 15

But I think there will be more things than this, like storing the transactional details as well.
or any other that I ignored?

Answer 16

Alright, thanks Ipang

Answer 17

LOGAN SIMONSEN ,
Employer's table is separated. There is a user table which only contains the admin details.

I have no idea about Paypal. Using stripe, how can I make transactions?