This is just a quick tip. Let’s say that you’ve got “http://www.google.com/search?q=1234″ in cell B1 in Excel, but you want to display “google.com”. You can use this formula:
=SUBSTITUTE(MID(B1, FIND(“//”, B1)+2, FIND(“/”, B1, FIND(“//”, B1)+2)-8), “www.”, “”)
This isn’t perfect as it assumes you always use “http://”, but it works pretty well for a quick, easy fix.
In general, you should always be forward thinking when creating your database schema, but it’s impossible to foresee every business need for every aspect of every project. In some cases, you’ll have to alter your table structure – maybe add, drop, or alter a column. Continue reading Fastest way to alter a large MySQL table
I just posted benchmarks for checking for an empty string that I ran when looking to improve the efficiency of an application. Another simple benchmark I ran was for ways to check if an array is empty.
Like strings, there are a ton of ways to check if am array is empty. These here are not exhaustive, but a few that I chose to test:
- $array == false
- count($array) == 0
- $array == array()
I run an application that requires a very high level of efficiency due to very high volume. I recently did an evaluation of efficiency for this application and performed a benchmark on a number of important aspects of the code. My findings were very interesting.
As you may know, there are a ton of ways to check if a string is empty. These here are not exhaustive, but a few that I chose to test:
- $string == false
- strlen($string) == 0
- $string == ” Continue reading PHP: Fastest way to check if a string is blank
I have a site that runs on Linux in production that uses Memcache. Installing Memcache on Linux is a cinch. I was setting this site up in my development environment however (Windows 7 64-bit, with WAMP, specifically Apache 2 and PHP 5.3) and I quickly discovered it’s not so easy. For the life of me, I could not find the correct php_memcache.dll file.
After spending a ton of time unsuccessfully install Memcache on my local machine, I realized that I don’t even need the memory caching functionality of Memcache, I just need the functions to work. Continue reading How to install PHP Memcache on Windows WAMP, Linux for any operating system (without really installing)