Reset / Delete magento category / products by SQL for magento version 1.7
I was writing a bulk category/product import script for magento 1.7. For debugging I had to frequently clear all the erroneous data inserted while coding and run my script again and again. Searching for an easy solution I came into this magento wiki that has the queries to delete all the products and categories for [...]
Inegrate Assembla Git on Windows Machine Issue – Solved
Posted by Imran in Project Management on March 29, 2011
We use assembla as our git repository. Initially LINUX or MAC machines gave us no trouble syncing with assembla. But when we tried on windows machines, it was not working somehow. Spent many hours “googling” and found everybody have their different ways of doing it using puttygen and many other different tool. None worked for [...]
Magento – related products not showing
While playing with magento, I was stuck in related products section. I added couple of products, and tried to add related products to one of these products. I added 5 related products but on the front end only 3 was showing. So here is the places where I searched to fix the problem: First of [...]
Install php scripts as cron in Windows
Posted by Imran in Miscellaneous, PHP, Windows on September 8, 2010
Linux has it’s very unique and beautiful feature “cron” that allows us to execute a program at a predefined schedule. For LAMP developers cron is a very common feature that we use very frequently. But many time lots of developers who recently have hosted their php code in Windows servers, face difficulty setting up their [...]
Mysql function to soundex match a word in a multi word string
soundex is a very useful mysql function when we try to compare 2 words if they sounds similar. Here is the official manual for the function. Soundex is pretty easy to use when we are comparing 2 words. For example, check the following query: select if(soundex(‘Rösle’)= soundex(‘rosle’), 1, 0); It’ll return 1 as both the [...]
Hover effect on input element in IE6
Posted by Imran in Browser Compatibility, HTML, Javascript on March 17, 2010
If you have ever tried to put a hover effect on any input element (submit, button etc) using css you must have faced the problem when you tested on IE6. Generally following is the css code we use to add the hover effect: input.inputClass{background-color:#cccccc;color:#000000;} input.inputClass:hover{background-color:#000000;color:#ffffff;} This would change the background color and text color of [...]
Back to my world after long
Posted by Imran in Miscellaneous on January 24, 2010
Childhood, originally uploaded by Lazy Fellow.
Have been too busy with family activities and completion of my MBA. At last the marathon family programs have been ended and the MBA(YAHOO!!!!) as well.
Simple Javascript Validation for Checkbox
Posted by Imran in Javascript on January 22, 2010
There are times when we need to add javascript validation to check if at least one of a group of checkbox options has been checked. Here is a simple function that’ll solve the problem and works in most of the browsers. <html> <head> <title>Imran’s checkbox validation</title> <script language=”javascript”> //frm is the form element function checkForm(frm){ [...]
Bird at my window
Posted by Imran in Photography on October 9, 2009
The place I live is not a very quiet one. A typical populated area in the city with people screaming, street dogs barking, hawkers shouting everywhere. The place is always lively.
Among all these chaos, I found this little baby bird sitting quiet on the mango tree right beside my window.
- Solving your puzzles @
My Photo Stream @ Flickr
