I have designed several websites during my time at Cornell, for both homework assignments and projects. Most used PHP or Python in addition to SQL, HTML, CSS, and Javascript. I have displayed some of them below.
This site was made to showcase a game made in CIS300. Check it out in the games section.
Cornell eLabThis final course project was done as a group for a client. It uses PHP, SQL, AJAX, and Javascript, and was designed to meet the demands of the client. However, the Cornell Entrepreunership Lab isn't using our version at the moment, so I can only link a static page.
WriteAlongThis final course project was a Facebook Application. This app lets people invite their friends to a story, poem, or play and engage in collaborative storytelling.
Photo GalleryThis project was a fairly sophisticated photo gallery. It uses SQL to upload and store images, and it requires authentication (for only one user, however) to access certain areas of the site. It also uses AJAX on the album view page.
Movie TagsThis site uses Python and the Google App Engine to store information about movies.
Music CatalogThis catalog site uses file writing as a poor man's database.