How to integrate a WordPress.com blog RSS feed into a PHP page

What comes first your wordpress blog or your website? You might have started with a free wordpress blog. Then later created a separate website or vice versa. Well whichever way round it is. You might have ended up with two disconnected websites. Now you want to reuse your wordpress.com blog content in your website. One […]

How to replace NULL values in a MySQL SELECT statement

Sometimes when you are SELECTing data from MySQL, some of your columns may have NULL data values and NULL’s don’t display well to end-users, so it may be best to replace the NULL’s with a string of text instead such as: “Not defined” “Undefined” “Default value” You could do this in PHP when you are […]

When to use USING in a JOIN rather than JOINing ON?

What is the difference between ON and USING() when JOINing two or more tables together in a SQL query? For example you have the following two tables, Users and Products, when a Product is created, the Users id that created it is stored. Products table: id Primary Key created_by_user_id Foreign Key to Users table product_name […]

Help for avoiding undefined index notices

If you are just starting out with PHP, you may come across this message: Notice: Undefined index: username in C:\wamp\www\mysite\index.php on line 99 Even if you’ve been coding for years you can still get this message! You may be confused as to what an “Undefined index” is? Often seen when trying to access global server variables […]

How to reduce physical stress when working as Web Developer?

If you are new to web development, sitting down all day might seem like a cushy easy job, and  it can be.  However as time and the years pass by, all that sitting will take it’s toll.  It’s easy to slouch, it’s easy to forget about your posture and easy to grab another sugary snack […]

How to protect your PHP source code as a freelancing web developer

How to protect your PHP source code?  You might be worried about giving away your secret sauce  or having it reverse engineered. Another good reason for wanting to protect your code is delivering the code to a clients server / hosting before final payment has been made for the development of the code. I have […]