DatabaseLessons.com

'Serving the Microsoft® Access
Community since 1997'

News/Blog
Tables
Queries
Forms
Reports
Modules
Miscellaneous
Subscribe
Free Samples
Videos
Services
Links
About Us

 

 

Access and FTP and PHP and MySQL - Part 2

The database that I will be using for this series stores articles. You can see several of the sites that utilize these articles by visiting this acne site, and this backpacking site. Depending on your browser, new tabs or new instances will open when you click those links.

Although the 2 have different visual designs, you can notice some commonalities. Go down to the "Newest Articles" section in each.

NOTE: All the VBA code segments on the Database Lessons site assume that you have DAO references active. If you are not sure what this means, and you are using Microsoft Access 2000 or higher, click here.

Hover your mouse over one of the clickable titles. They have a style like this example. "http://www.backpackingforbeginners.com/article/backpacking-chat-rooms-and-groups". Notice there is no ending (.html or .php). I could have faked an extension, but chose not to. There is no actual physical page called "backpacking-chat-rooms-and-groups". The article that shows up when you click that link is being read from a MySQL database.

The menu systems on the left are similar. Hovering your mouse over each entry suggests standard php pages, and they are. I considered having even the miscellaneous pages like those in the database, but chose not to in this version of my little system.

(article continues after sponsor spot)



Both sites have a convenient site map, which is just a basic alphabetic listing of all the articles. This site map page is dynamically generated from the database, freeing me from having to update it manually each time a new article is published. In addition, you will see later that there is a date-to-publish field in the database. This way I can load up a few articles and they appear one-by-one in the future, as per that field's date. This date field also controls what appears in the "Newest Articles" section.

The Acne site has a section in the left called "Categories", which is also database driven. You will see the responsible field when we look at the structure later.

Finally, the Acne site also has a "Last 10 Articles" section, which is almost redundant due to the "Newest Articles" section. This is a design issue that I have not resolved my thoughts about.

I probably prefer the simple and clean look of the Acne site, but this series of articles will be about the database and programming technologies, not the non-artist in Richard!

Before you read the next article (when it appears, hopefully within a week) you need to study the sites a bit so that you can picture them while we discuss the techniques I used in Access and the PHP / MySQL combo.

 
Note: This web site dedicated to MS Access database users is an independent publication of Richard W. Killey and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft® Corporation.
 

 

© 2006, 2007, 2008 Richard W. Killey. All Rights Reserved. - Privacy Policy