Last December, I wrote a simple and easy to use PHP MySQLi wrapper class inspired from the simplicity of Code Igniter Active Record pattern and hosted on BitBucket. Over an year, I’ve been using this class and continuously improving it based on my requirements and other users requests. Over a dozen of bug fixes and improvements made based on user reporting so far.
The latest version has been released ( 1.4.6 ). This includes new methods FIND_IN_SET to find a value from a comma separated string and BETWEEN condition.
Yesterday, December 8th, 2014 I took the Zend Certification exam and passed. The latest version of the Zend exam is based on PHP version 5.5. They have updated their syllabus to reflect this change. And also, Zend made their official study materiel available to buy from their website for $19.95. It was available free of cost before.
I took the decision to write the Zend certification about 2 years back. But things have changed so quick in my life that I couldn’t even prepare for the exam. I’ve seen a lot of posts on the internet about the tricks and tips to pass this exam, and a bunch of sample questions. So I am not going to write similar post. If you would like to pass the exam, here is my suggestion
Study Strings and Arrays thoroughly. Don’t just read those pages, write the code and try to execute. Use a pen and paper if you need. If you study almost all functions mentioned on those pages, you will certainly get 50% of the pass mark.
In addition to those, here is what I found, will give you additional points. Continue reading →
Today I am going to share a small trick that would save you $50-$100 every month you are paying to your current home internet provider. I did not want to do 2 year agreement with Verizon FiOS, as I will be moving to another city within a month, so I found this setup works for me.
Basically, what you are trying to do is to tether your T-Mobile/MetroPCS unlimited internet plan and connect it to your router. By connecting any device to the router you can access internet on that device.
This method is helpful, when you have a XBox or Roku or any such devices connected to your TV and stream music and videos.
This is a simple trick to get the changes caused by the UPDATE query.
The trick is to get a copy of the row before and after UPDATE query and compare those rows to get the changes. If you would like to go for something complicated than this one, then you should check the MySQL TRIGGER.