How to build a database driven website part 2

In part 1 of how to build a database driven website we looked at creating the database and tables and looked at some simple options for inserting data.

In this part we are going to look at connecting to the DB using PHP, creating a simple template as well as discussing a few site architecture issues.

We are going to use a simple PHP connection script to connect to your DB, which will be saved in a separate file and stored outside of root.The connection script will contain the username and password for connecting to our database.

Continued here


How to Build a Database driven website part 1

Building a simple database driven website.

This is part one of a multi part yet to be determined ‘how to’ aimed at showing you how to build a database driven website.

Ok for this recipe you will need.

  • An idea of what you want to do
  • Basic knowledge of HTML
  • PHP enabled webspace
  • A Mysql Database
  • PhpMyAdmin
  • A dataset
  • Will and determination to get it done

Continued here