PHP and MySQL?

[sadcomedian]

I have very little experience with databases and backend scripting, and was wondering if someone could help me here.
I have MySQL support on the server.
Now I suppose the easiest way for me to do this is explain what the site should do, and then someone here that reads this could explain to me how to make that happen with PHP and SQL. Of course at this point, any help would be greatly appreciated.

Any user should be able to purchase a game separately, whether or not they have packages.

A user should be able to purchase 1 or more packages.

A user that has purchased 1 or more packages should be able to access those packages but only the one’s they have paid for.

Each package will have a time limit on them.

When the time limit is up, they should no longer have access to that package.

Also, I don’t understand what I need to do as far as databases go.

If I create tables for the database, how do I upload them or whatever?

Where do I test them and so forth?

And lastly, what’s a good program to do tables in? Access? Excel?



Well, that’s all I can think of right now.



Thank you for all the help.



Matthew

[mordred]

Everything you mentioned above should possible to do with PHP and MySQL. I suggest you read some introductory articles about the what and why about database-driven websites, this article is a first example:

http://www.mysql.com/articles/ddws/index.html

There are plenty of tutorials/articles in the web, good sites include http://www.devshed.com and http://www.phpbuilder.com

[sadcomedian]

Okay, lol, reading them now!

[codewarrior]

Get EasyPHP (http://www.easyphp.org) :D It has PHP, MySQL, and Apache built in ;)

[duniyadnd]

This book teaches you how to start your own small online store. I'm not sure they deal with security issues for credit card information and such, but its a great place to start.

Web Database Applications with PHP & MySQL

published by O'REILLY

Duniyadnd

[sadcomedian]

I have umm.... PHP and MySQL Web Devolopement it's good, but there's so much.
I just don't even know where to start.

[whackaxe]

get PHPDEV then so you dont have tedious FTP sessios uploading downlaoding stuff all the time then you could also look around the web for e-commerce tutorials notably on www.hotscripts.com. be aware that when in E-commerce you need to either have a paying sys like paypal or have SSL (secure sockets layer whatever that means please someone!)

[sadcomedian]

HEHE gonna go through paypal....... how would i get my database to communicate to thier database?
btw
with secure socket layers, it uses an algorythm with encryptions while it's being passed from server to server..... see, when it gets transfered, it gets broken into packets of data, and ssl secures those packets so they are protected during the transfer.
matthew




WHAT IS PHPDEV? and where do i get it?

[mordred]

Originally posted by sadcomedian
WHAT IS PHPDEV? and where do i get it?

It's all explained in the second "Must Read" thread of this forum - actually, now at the moment directly above this thread.

[sadcomedian]

what MySQL client do I need to connect to MySQL Server via the web?
(Fusion 3k is my host)

[sadcomedian]

Okay, just downloaded this php dev thing, how do I install it lmao, maybe it's just me, but I'm used to a setup.exe or something....