943,733 Members | Top Members by Rank

Web Development > Web Design > Site Layout and Usability > Beginners Guide To Creating Database Driven Website
Ad:
You are currently viewing page 1 of this multi-page discussion thread
Permalink
Jun 18th, 2007
0

Beginners Guide To Creating Database Driven Website

Expand Post »
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.
Similar Threads
Reputation Points: 46
Solved Threads: 48
Posting Pro in Training
macneato is offline Offline
410 posts
since Jun 2007
Permalink
Jun 18th, 2007
0

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.
Moderator
Featured Poster
Reputation Points: 1764
Solved Threads: 574
Moderator
jbennet is offline Offline
16,505 posts
since Apr 2005
Permalink
Nov 19th, 2008
0

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!
Reputation Points: 10
Solved Threads: 0
Newbie Poster
newby08 is offline Offline
4 posts
since Nov 2008
Permalink
Nov 27th, 2008
0

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?
Reputation Points: 10
Solved Threads: 1
Light Poster
emiola is offline Offline
49 posts
since Jul 2008
Permalink
Nov 27th, 2008
0

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
Moderator
Featured Poster
Reputation Points: 1764
Solved Threads: 574
Moderator
jbennet is offline Offline
16,505 posts
since Apr 2005
Permalink
Nov 27th, 2008
0

Re: Beginners Guide To Creating Database Driven Website

Do you mean LAMP server on debian/ubuntu or the tutorial you wrote on it?
Reputation Points: 10
Solved Threads: 1
Light Poster
emiola is offline Offline
49 posts
since Jul 2008
Permalink
Nov 27th, 2008
0

Re: Beginners Guide To Creating Database Driven Website

tutorial
Moderator
Featured Poster
Reputation Points: 1764
Solved Threads: 574
Moderator
jbennet is offline Offline
16,505 posts
since Apr 2005
Permalink
Dec 2nd, 2008
0

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
Last edited by moodymoe15; Dec 2nd, 2008 at 4:11 pm.
Reputation Points: 10
Solved Threads: 2
Newbie Poster
moodymoe15 is offline Offline
6 posts
since Dec 2008
Permalink
Dec 3rd, 2008
0

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.
Reputation Points: 10
Solved Threads: 1
Light Poster
emiola is offline Offline
49 posts
since Jul 2008
Permalink
Dec 3rd, 2008
0

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
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 871
Code tags enforcer
peter_budo is offline Offline
6,656 posts
since Dec 2004

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Site Layout and Usability Forum Timeline: .htaccess exclude subfolders from urls
Next Thread in Site Layout and Usability Forum Timeline: Where should I start for web developing?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC