Intermediate MySQL/PHP Question Week 1
Written by Bean on August 30, 2008 – 12:40 amThe Web is full of database driven web sites. Blogs are data driven and most of them run on MySQL/PHP like this one. E-Commerce sites are also database driven. They can run on a variety of platforms like ASP.net, jsp and of course MySQL/PHP. Some are well written and easy to navigate. Others can be a nightmare. Some of those issues are related to database design, others to interface design and other issues are related to business rules. You can see some examples of this. especiallu business rules, described in Viki’s post.
In this course, we will be designing a basic interface for our database to create a database driven web site. We won’t be tackling e-commerce until the advanced course so let’s turn our attention back to other data driven web sites. Blogs are one of the most common examples but there are lots of others like recipe repositories and information clearinghouses. Spend a little time surfing the web and find one that you like that is NOT an e-commerce site. Post the URL of the site here and tell us what you think it does and what you like about it.
For example, I like ma.gnolia. It is a social bookmarking site. It’s database allows me to store my bookmarks in one central location. I can use its interface from any computer to add to my bookmarks, edit or delete them. It allows me to query its database of bookmarks based on tags. I can search everybody’s bookmarks, my friends or just my own.
Posted in Class Announcements | 4 Comments »

Here’s one I have spent considerable time at.
http://www.wga.hu/index1.html
It has various ways of searching and setting preferences for searching. What I like about it is the great amount of art and the ease of finding it.
Anita
Sometimes designing a website for a client can result in that – un uh – what do I do with this blank canvass?
I like this blog since it posts 50 or so links to the top design sites. Great for getting inspired .
M
Anita,
Hmmm I hate frames I can’t tell exactly which db engine they are using on that art site. It is PROBABLY php but I can’t tell for certain.
Marion,
I checked out http://www.davidairey.com/top-50-graphic-design-blogs/ and that is a nice resource. He is using WordPress 2.6 to power his blog so it is definitely using MySQL/PHP to power it.
I had no idea what they were using Bean, I just liked that they have lots of art and a way to search for it