If you have a web site that focuses on interesting topics, it is fairly easy to earn some passive income from the web site by placing Google AdSense ads on your web pages. AdSense is a context-driven system, which means that the ads displayed should be related to the theme of the content on the page.
(more…)

This MySQL cheatsheet is the first of a series of cheatsheets. I’ve always set up cheatsheets for my own use as long as I’ve been writing programs, which goes back a long time. What sets this cheatsheet apart from others is that it focuses on commonly used MySQL examples and not just code. It’s a free download. I hope that you find it to be useful.
(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…)

Outgoing e-mail problems can sometimes be more difficult to troubleshoot than incoming e-mail problems. Troubleshooting these types of problems in Mozilla’s Thunderbird is fairly easy if you understand how outbound e-mail works.
(more…)

Troubleshooting connection problems with an e-mail client, such as the freebie Mozilla Thunderbird e-mail program can be frustrating and tricky. If you are having problems retrieving your e-mail or getting it configured correctly, don’t give up. Most solutions are pretty simple. In this article we cover some of the more common connection issues you might find when using Thunderbird.
(more…)

The ternary operator is a shortcut comparison operator that replaces an if-else statement in a PHP script. If you use a lot of comparison statements in your scripts, this can greatly reduce the number of lines of code. The ternary operator is really very simple to use, but it does tend to confuse newbie PHP programmers.
(more…)

Most new web developers have heard of SQL injection attacks, but not very many know that it is fairly easy to prevent an attacker from gaining access to your data by filtering out the vulnerabilities using MySQL extensions found in PHP. An SQL injection attack occurs when a hacker or cracker (a malicious hacker) attempts to dump the data in a database table in a database-driven web site. In an unprotected and vulnerable site, this is pretty easy to do.
(more…)

External CSS style sheets offer numerous benefits to web site design. First, they centralize CSS rules, which means that making a change in one file affects the entire web site; therefore, site maintenance is much simpler. Second, an external style sheet reduces the amount of web page code, which makes it easier for spiders to dissect the code and get at the content. Third, most browsers cache this file, which speeds up the loading and rendering of a web page.
(more…)