Tryangled Solutions web designing tips tricks

In order to do some of our tutorials (or program with PHP and MySQL in general) you need to be able to run PHP and MySQL. Although most free hosts do not have PHP and MySQL support there are some that do, and there are also many low cost hosting options available. If you already have hosting and are unsure if you have PHP and MySQL support you should contact your host directly. If you are shopping for hosting be sure that they support PHP and that your package includes at least one MySQL database.

Another option is to install PHP and MySQL directly onto your Windows computer. If you are a Mac user you already have the capability and just need to activate PHP and MySQL.

1: Too Few Databases

All blogging software, all forum software, and darn near every cool Web application you can think of requires a database in order to function. Unfortunately, most shared server packages only offer between 1 and 5 databases, thereby limiting your ability to expand with new sites or to experiment with new ideas.

In my opinion, this is completely unacceptable. If I want to see if I can tie 10 databases into one WordPress installation, then by god, I ought to be able to do that! Sadly, this would be an impossible task with just about every shared server package I’ve ever seen.

Because of this limitation, I have resorted to purchasing more expensive plans that offer more flexibility. Remember my first inadequate server that I told you about earlier? After that terrible experience, I opted for a more expensive server that cost me roughly $550 up front, and the primary reason why I went with the more expensive unit was because I could have unlimited databases.

2: Too Few Domains Allowed

Probably in an attempt to curb spammers, Web hosting companies usually limit the number of domains you can have on a shared server. Oftentimes, the limit is between 1 and 5 domains, but just like with the databases, this really affects your flexibility over time.

Want to start that new site you’ve been thinking of lately? Too bad, you’ll have to buy new hosting because you’ve already maxed out your domains.

Oh, and here’s another gem from the crazy world of Web hosting… I’ve seen shared server accounts before that would let you have 5 domains but only 1 database. If every site on the planet requires a database to run, how the hell can you run 5 domains with only one database?

Sanity? Anyone?

The bottom line—and the thing you really need to know here—is that good shared server plans will offer you at least 20 domains, and even better ones will let you add as many as you like (usually up to 999).

3: Crappy Developer Support

So, that new version of WordPress you want to run requires MySQL 4.0 or higher in order to work properly? What a shame, because your junky shared server only runs MySQL 3.23 and hasn’t been updated since 2005.

Of the three cardinal sins I’ve listed here, this one is probably the easiest to avoid. However, developer support is the ultimate litmus test for any Web host, and you can bet your bottom dollar that if the company you’re looking at doesn’t consider developers a priority (we’re a raucous, complaining bunch), then they damn sure won’t consider you a priority.

No matter what hosting package you’re looking at, make absolutely certain that you see support for the following developer tools:

* PHP
* MySQL
* Ruby on Rails
* Python
* CGI
* .htaccess
* cron jobs

Every hosting account has a certain allotment of disk space. The disk space is used to hold all the files which make up your web site – HTML files, graphics, scripts, and multi-media content. Usually the more expensive the hosting package the more disk space and the more bandwidth you receive.

A basic web site with just a few pages requires less than 1 MB of disk space. As you add more content and include things like downloadable files, pictures, music, and video you will require more disk space. Email also takes up disk space. If you have an account with a small disk allotment you may find that unsolicited SPAM may be eating away at your disk allotment. It’s always a good idea to go through your inbox from time to time to delete unnecessary emails.

What will happen if you use too much disk space? Each web host has their own policy about this but it’s safe to say that you will be charged for the extra space. Often this penalty is much higher than regular rates for disk space so it’s important to keep an eye on how much space you are using and if you are approaching the limit, either purchase more space or delete some files.

How can you tell how much space you are using? Most hosting packages have a control panel for making adjustments to almost every aspect of your account. These control panels usually tell you how much disk space is being used and may also rate it against your allotment so you can see at a glance if you are approaching your limit. If your hosting account does not have this feature you can judge the amount of space by downloading your entire site to a folder on your personal computer in order to check how much space it takes.

As a rough guide, consider that an average web page (3 graphics and 2 screen lengths of text) takes about 20 kb (to be generous). At this rate, a hosting package with 10 MB can have about 500 pages. Since most small sites are less than 50 pages 10 MB should be plenty to get started. But what about databases? They are usually calculated separately from your disk allotment but check with your web host to see what their policy is.

If you place music or video files on your website your need for disk space (and bandwidth) starts to take off. A typical 3 minute MP3 file takes about 2.5 to 3 MB of disk space. A short video (very poor quality) can take 1 MB. A good rule of thumb for those wishing to host multimedia is to estimate the total size of the files and get an account with double that space. This will allow for future expansion. Always check with your web host, though, before placing sound or video files on your website. Some have policies against this type of content because it places a strain on the bandwidth allotment – a serious consideration with a shared hosting package.