PHP & MySQL - Database-Driven Websites

Learn how to create a standalone application for uploading images to your website. This application uses an "iframe" to achieve an AJAX-like method for easily uploading multiple images to your server without the need for an FTP client. Images are automatically uploaded one at a time and displayed as thumbnails so you can keep track of which ones have already been uploaded. This tutorial is an enhanced version of Asynchronous image file upload without AJAX by Martin Konicek. The enhancements include being able to preview "gif" and "png" images in addition to "jpg" images, notification if the image already exists, an error message in case the upload fails, and image size restrictions.

Learn how to create a site search for database-driven websites. This tutorial assumes that the information you wish to search for is contained in a MySQL database. This search application will not only locate the documents containing the text in a search, but will also order the results according to how many times the words appear in the selected documents and offer boolean search commands. This tutorial assumes a basic knowledge of PHP and MySQL.

In this two-part tutorial, we will be building a stock ticker to retrieve and display stock quotes from Yahoo Finance. In part 2 we will learn how to make the quotes update automatically using AJAX. This stock ticker can easily be included as part of your site since all of the necessary code resides in a single div. It is recommended that you are comfortable writing code for CSS and HTML before continuing this tutorial. This is a PHP script so it would be helpful to understand PHP, but we will be going over the PHP code line by line so if you are not familiar with it, that's OK.