Beginners guide to Zencart programming
People, who have tried to edit the code of Zencart for the first time, naturally face difficulties to find the right place to put their patches. They end up with hardcoded links, language dependent texts, at the worst case a new database connetion to pull data from database. The same happened to me when I [...]
Zend optimizer installation problem
Sometime we find that after successful installation of Zend optimizer, php seems do not find it.
I have found a common problem that people usually face while installing zend optimizer in a linux server. While installing, Zend optimizer asks for the directory location of current php.ini file. It comes with a default value like /usr/local/Zend/etc (may [...]
Access files in password protected directory using curl
I had to get a page that is in a password protected directory.
First I used php file_get_contents() which is always my first solution for accessing remote pages. But many web servers disable allow_url_fopen in php config. So curl is the ultimate solution.
Curl has an option called CURLOPT_USERPWD that allows to add the user name and [...]
Find duplicate entry in table
This is a very handy query all the db programmers and db admins need everyday.
Lets say, we have a table “test” with 2 fields “id” and “name”.
We need to find out which names are duplicated in the table. So here is the query:
select name, count(*) from test group by name having count(*) > 1;
This will [...]
Ridirect http://yoursite.com/index.php to http://yoursite.com
Sometimes we need to 301 redirect the index.php file to the domain root as they are canonical urls (ie, http://yoursite.com/index.php and http://yoursite.com are same).
It is only tricky for sites using index.php as the common entry with GET variables controlling the site . In that case we cannot redirect pages with any query string (anything after [...]
My Photo Stream @ Flickr
