Sending email using PHP on a Windows IIS server is not as simple as it is when using a Linux server. On a typical setup the mail() function probably won’t work without some tweaking.
Continue reading ‘Sending Email with PHP mail() on a Windows Server’ »
Usually our SQL queries use JOINs in SELECT queries. But what about if you want to DELETE using a JOIN? It’s not as straightforward.
Ever need to order an SQL query by the surname/last name of a user, but their full name is all one single field? Here’s how to use some of MySQL’s string function to do just that!
Continue reading ‘SQL Query To Order By Surname When Name Is All One Field’ »
WordPress is a great piece of blogging software. With very little experience you can have your own blog set up within minutes. However, WordPress does have its faults. One common complaint is that WordPress is slow, and gets slower as more posts are added. Fear not, because help is at hand! One simple change to your .htaccess file can optimise WordPress and speed your blog up dramatically.
If you have some ASP pages that you want redirecting to new URLs with the correct “301 Moved Permanently” status, this simple solution is easy to implement.
MySQL can do far more than just insert, update and select data. In fact the world’s most popular open source database has a whole host of incredibly useful functions built in that you might never know about until you find one day that you need them – and then you wonder how you coped without them!
Your web server may be ticking over nicely and everything looks fine and dandy. However, unbeknownst to you your server could be under constant attack by hackers! How can you find out if this is happening? One of the first things to check is your SSH log.
Continue reading ‘Check Your Linux SSH Log To Stop Hackers’ »
The preg_match() function will perform a Perl-compatible regular expression pattern match. Sometimes you will want to match a backslash, but it’s not as straightforward as you might first think!
Continue reading ‘How to Match A Backslash with preg_match() in PHP’ »
The MySQL relational database management system (RDBMS) supports a wide range of data types. The data type that you chose for your table columns is important because it determines how MySQL will store your data. It’s possible that any one of multiple data types could be used to store a piece of data, but which one is the best or optimal data type to use?
Continue reading ‘How to Choose the Optimal MySQL Data Type’ »
I recently had to redirect an old website to a new domain. The old domain had 11 pages indexed by Google but I only needed them to redirect to the home page of the new domain, rather than all having separate redirects to new URLs.
If I were using Apache this type of redirect would be easy to implement with a .htaccess rewrite rule. Therefore, I expected that Microsoft’s IIS web server would have a similar scripting method to redirect a whole website to a new domain.
(This was a shared hosting account so access to the IIS sever itself was not possible.)