Raffle website

I am starting to put together a website which is a house raffle site.

Users by tickets at £500 with good odds at winning a house.

I'm struggling to find an 'off the shelf' system that supports this, a kind of shopping cart specific to a lottery/raffle website. Does anyone know of any software that offers this?

It needs the following functions:

•  Users can buy a one-off ticket or buy a tickets over time (5 payments of £500 for example).
•  A kind of stock control so only a certain amount of tickets are bought
•  A function allowing the client to login and check their account.

I'm ok with MySQL and PHP and have considered building this myself, would this be difficult?
BrighteyesDesignAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark BradyPrincipal Data EngineerCommented:
This would be very basic especially if you knew both PHP and MYSQL.  Making a login system is easy. There are millions of tutorials out there but I'm sure you have read many yourself.

Here are some questions for you before we begin (so I can get a feel of what level you are at)

1: Are you comfortable making a login page ?
2: Can you write MYSQL tables and insert and retrieve data via PHP script ?
3: Can you do some basic graphic (Photoshop) work to create the login page ?

If you can do all 3 of the above then this is how I would attack it.

Create the login page. Create a 'stock' table and populate it with the number of tickets to be sold.
On the purchase page, as the user clicks the button to buy a ticket, have the forms script go to the database and perform the following tasks:

1: Add the ticket and ticket number if you want to have one to the customers purchase table and include things like the date and time the ticket was purchased etc...
2: Reduce the stock amount of tickets by 1

Whatever other functions you deem necessary but I think on the whole this would be a one days effort kind of thing. It really wouldn't be difficult at all. Have a go at it and if you get stuck just ask in here and we will help you.

I ALWAYS start any project off by writing down everything I want the site to do. Every feature I need it to have and the aim of every button click (where is each page going and to do what?).

Once you have your list you can chip away at the project page by page. Always start with the login script as that is the very first thing the user will need to do to get into their account. Give them each a unique identifier when they signup by using a combination of a random number (8 - 10 numbers long) and a few letters of their username.

I would also do things like create a user feedback form so they can send you email, create an admin section so you can login and do certain tasks. You could create the 'Buy Now' buttons in paypal or you can use your own merchant account if you have one but paypal is simple and quick. That's pretty muck all I can offer right now but let me know if you don't follow my line of thinking.

I created a trading site with similar features a couple of years ago so if you want you can go checkout www.junktraders.co.nz

Cheers
Elvin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.