And the best part is -
"Payment gateway, CCAvenue it seems was hacked by hackers via exploiting SQL injection vulnerability."
This is a classic example of "Coding versus Programming".
The guys at CCAvenue, the dev team is full of great coders, with little idea of programming!
Any input from outside your safe zone (e.g. coming from the internet through form) must be cleaned. And not by saying which are the bad characters to remove (which is not easier to define compared to ..), but by saying what characters are safe. e.g. A-Za-z0-9_- etc. and removing all that are not needed, so called sanitizing the input.
Writing of code should always follow the long term, the 'what-is-right' approach as well. Not the mad0rush always, nor the 'it-works, so why bother' approach. Specially if you are dealing with finances, and your reputation.
While coding is the energy and ability to do something, programming is the attitude, the approach to the how of the doing. With proper direction, lot of energy is not of much use.
As startups, it would be even more important to take the right attitude, when giants like CCA can fall prey to silly mistakes of ignoring SQL injection!
Just a nostalgic bout from my years working with databases!
Thank you.
Shashikant Joshi
Author, ATTITUDE SHIFT - Sanskrit Maxims for Contemporary Life and Leadership