Beginners Guide To Creating Database Driven Website
 

Over the next few weeks (or days - depending on how much time i have) I'll help with the very basics of SQL (and PHP).

These are the points I'll be covering (all from scratch of course)

Local Server setting up

• php
• mysql
• apache

Database Basics

• Simple Database Creation
• Database Uploading (& Converting)
• Database connecting

PHP Basics

• Simple PHP Creation (application based)

Database Intermediates

• Myphp Admin Db creation
• IP loggin and banning
• Site user creations
• Printing onscreen
• SQL table queries

For this workshop you will require the following applications:

• mysql
• php
• apache
• ms access (or any other database creation application you are comfortable with)
• ms access to mysql converter (if you using another application, just google it)
• PHP Makers

NB: I'm not writing this guide for myself, and im not planning to spoon feed anyone. So Vol.1 will only be released if 5 or more members request it.

Re: Beginners Guide To Creating Database Driven Website
 

Have a look at my tutorial for setting up a LAMP server on debian/ubuntu. It details exactly what packages you need to apt-get and how to change the MySQL root password.

Re: Beginners Guide To Creating Database Driven Website
 

I am requesting it... my goal is to create a Membership for my company. I would like my members to have Usernames and Passwords, and I would like to have a Login page. From my understanding, I'm going to need to have a database driven website to do this, and your knowledge would be very helpful. I'm very new to designing websites, databases, and computers altogether, so any help would be truly appreciated.

I hope everyone else feels the same way!

Re: Beginners Guide To Creating Database Driven Website
 

Yea me too. I have downloaded the applications but I was only able to try out oracle10 express. I have to some extent mastered SQL and way into PHP at the w3school site.
My question is that can I use my same system to set up as my database server OR i need another system entirely and if so, the security implications involved.
This LAMP on debian/ubuntu utorial jbennet menioned did not carry the link to he tutorial. Will he kindly do that?

Re: Beginners Guide To Creating Database Driven Website
 

Installing a LAMP server on debian/ubuntu

http://www.daniweb.com/forums/thread78131.html

its a wee bit outdated now

Re: Beginners Guide To Creating Database Driven Website
 

Do you mean LAMP server on debian/ubuntu or the tutorial you wrote on it?

Re: Beginners Guide To Creating Database Driven Website
 

tutorial

Re: Beginners Guide To Creating Database Driven Website
 

Hello Macneato,

I know this post is fairly old but if you have created a volume by now can you please post it up. Your information would be greatly appreciated not only by me but from the whole community.

Thanks!
-Moodymoe15

Re: Beginners Guide To Creating Database Driven Website
 

Hello Macneato,
We are waiting pls. Do us the favour even if it is releasing it chapter by chapter. We really appreciate it.
Thanks.

Re: Beginners Guide To Creating Database Driven Website
 

For local installation & config of Apache, PHP, JSP, Ruby on Rails, MySQL, PHPMyAdmin & WordPress on Windows XP/2000 you can use this guide. Little outdated like jbennet tutorial ;), but is functional