Adding Dynamic Data (PHP/My SQL) to your site

In this standalone tutorial, Matt supplies the CSS and layout that he built in previous articles, and shows you how to add database connectivity using My SQL and PHP - ideal for beginners to dynamic databases and server-side functionality.
$2.89
- OR -

Overview

Table of Content:
  • Installing a Test Server
  • Site Setup for PHP/MySQL
  • Building the Database
  • The art Table
  • The category Table
  • Creating a MySQL User
  • Building The Portfolio Page in Dreamweaver
  • Portfolio Specific CSS Styles
  • Setting up for the Dynamic Content
  • Creating the Database Connection
  • Creating the Navigation
    • The Recordset
    • The Server Behaviors
  • Creating the Art Area
    • The Recordset
    • The Dynamic Text, Images, and Links
    • The Repeating Area
    • The Record Navigation
    • When There's Nothing to Show
  • Making The Category Name Change
  • Summary

Matt Machell

Matt MachellA man of many talents, Matt has been a web designer, technical editor, and jewellery picker. He is currently on contract for the Birmingham City University, producing pages for research centres.

He has tech-edited a dozen books on web design and development for glasshaus, Apress and Sitepoint.

He likes music with loud guitars and games with obscure rules.

His website can be found at: http://www.eclecticdreams.com

He lives in Birmingham with his girlfriend, Frances, and a horde of spider plants.

See All Postings From Matt Machell >>

Reviews

Tutorial

July 24, 2009 by Eva Gustafsson

Thank you for writing this tutorial, I learned allot. However, I repeated the tutorial three times and I can still not make the navigation link to the different categories?????

I added some data into category 2, but when I click on Illustration nothing happens?

I am working in Dreamweaver CS3

You must me logged in to write a review.