Building a dynamic webpage using PHP, MySQL and Smarty

stage one
introduction to this tutorial
stage two
tutorial prerequisite reading and useful links
stage three
creating a data source and entering data
stage four
creating php code to retrieve the data from mysql
stage five
creating a template to represent our data
stage six
putting it all together
stage seven
conclusions, links and comments

stage six - putting it all together

Now that we have a template, and some PHP to populate it, we should be able to load up the PHP file and get some news articles returned

I used the following CSS stylesheet to get the results below.

h1, h2, h3, #header, #footer {
  font-family: verdana, tahoma, helvetica, arial, sans-serif;
}

h1 {
  font-size: 200%;
  font-weight: bold;
  text-align: center;
}

h2 {
  font-size: 125%;
  font-variant: small-caps;
  color: black;
}

h3 {
  font-size: 85%;
  font-style: italic;
  color: #9B9B96;
}

#header, #footer {
  text-align: center;
  display: block;
  border: 1px solid #999;
  padding: 1mm;
  background: #ffc;
  color: #000;
  color: gray;
  font-variant: small-caps;
}

#header {
  font-size: 250%;
  font-weight: bold;
  margin-bottom: 5mm;
}

#footer {
  font-size: 85%;
  margin-top: 5mm;
}

Here is my smarty powered page in action:

devscripts dot net tutorial

building a dynamic webpage using php, mysql and smarty

stage six - putting it all together