Many web site owners and new designers do not understand the importance of optimizing images for a web site. The process is pretty simple once you understand the concepts. (more…)

Netiquette, or Net etiquette, is a set of guidelines for content and web site design that seek to create a seamless communications channel with users and to avoid areas that sometimes cloud or confuse the communications. Many rules that have become bona fide standards for print media do not work well with the Internet. It is a mistake to assume that all standards used for books, brochures and print media advertising work equally well with the web. Here are some examples of bad netiquette. (more…)

We have been using PHP and MySQL for web development almost exclusively for several years. During this time, our team has come up with a list of simple, yet powerful one line SQL statements that make MySQL easier to use. We thought we might share them with you. (more…)

It is common to add a drop-down select box that is populated with USA states or Canadian provinces to PHP applications. There are basically three ways to do this. You can hard-code all of the Select box selections into your application, you can add the states to a MySQL database manually, or you can use the handy code on this page to create a States table in MySQL in just a few seconds. (more…)

A shopping cart is an essential component of every e-commerce site. Although there are literally hundreds of shopping carts to choose from, only a few stand out. PHP is the preferred shopping cart language because it is the most popular web development language on the Internet. When combined with the MySQL database, PHP is unbeatable for cost effectiveness. (more…)

I am finding that an increasing number of hosting companies appear to be configuring their servers to allow the file listings of web site directories to be viewed by users. I don’t know why they are doing this. It can be a serious breach of security that may allow a hacker to gain information about a site that can be used to hack the site. It is always a good idea to take steps to prevent the listing of directory files.
(more…)

A full-text search allows a search of multiple text columns. If you are setting up a search of a series of articles or a site with lots of product-related content, a MySQL FULLTEXT search can make it very easy to find articles or products related to the keywords used by a searcher. This search method does exactly what its name implies–it allows a full search of large text fields. A FULLTEXT search is easy to set up if you just follow these simple instructions. (more…)

There is a little-known web design problem that can prevent search engine spiders from finding the content on web pages. It’s called excessive table nesting and the problem is more common than most designers and site owners think. (more…)

Learning how to use the MySQL database properly can take quite a bit of time. It is not uncommon to select a less than optimal data type when setting up a new table. Multiple data types are available for each value that you wish to store. This MySQL data type tutorial is intended to help take some of the mystery out of the proper type selections for database columns. (more…)

This is a simple PHP script that takes data from a MySQL table and uses it to generate a drop-down select box for an HTML form. This can be used for a list of states on a credit card or user data form, or for a category selection or something where you need to pull the selections from a MySQL table. The script uses PHP to generate the HTML that is sent to the user’s browser. (more…)