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.)