Member Database SQL / PHP

[realm]

Hi,

I am going to be setting up a database to hold information about my customers. Using PHP and SQL. I currently been using a flat file DB but going to start using SQL for obvious reasons. I don’t have much experience with SQL but know enough to tackle this project. I will be using PHPMyAdmin to work on the database and write my own scripts to add/delete/edit members ect.

Before i started this i was wondering if anyone knew of any tutorials that would help me through this if not any tutorials that are similar that can help me. Before anyone says why not use a CMS etc, i prefer and want to build this my self that way i am learning more and also i get it to run how i want it to.

Cheers,
RealM

[Dav0s]

find a good guide on "sql injection" and how to prevent it, and code your CMS accordingly. just a note for security reasons.

[Dorza]

www.sitepoint.com Check out the Build your own database driven website using Mysql and PHP by kevin yank. I cant praise this book enough, it does exactly what it says on the cover. I dont think it teaches you how to setup a member system but it will certanly teach you enough for you to be able to do it. Its the best book out there for getting started. As davos said you need to find out how to secure what you make; the book doesnt go into that level of detail unfortunately.

[realm]

Hi, Thanks for your comments i will take a look into that book as it seems to be what i am after, Cheers.

[MAdMaN]

While you don't want to use a CMS, I'd say download one anyway. That way you'll have working code to look at while you learn.