Paypal – Various ways of integration solutions – Transfer transaction data through Session. – Most preferred way for SME and NPOs. – Developer’s page and it’s explanation contents are a little unorganised, so it’s a bit hard to grasp a whole picture of services for new comers. – Developer Resource: X.com, Sandbox eWay – Build:… Continue reading Payment Gateways used in Australia
MSSQL backup & restore using script.sql
MSSQL has the function called backup & restore, which is useful. It works fine between different versions. But, if you need to restore from script.sql, you can do it on command line. sqlcmd -S <server> -i C:\<your file here>.sql -o Full explanation : Link and Sometimes connection string can be tricky. You can get full help… Continue reading MSSQL backup & restore using script.sql
Use Sublime Text theme color in Visual Studio 2010
I started using Sublime Text since I went to the DDD event at Sydney, where all presenters were using Sublime Text as their main editor. Soon, I became a fan of it. Now I wanted to use its theme color on text editor screen in Visual Studio. Dark background with light font color may be… Continue reading Use Sublime Text theme color in Visual Studio 2010
MySQL: remove special character from DB field
UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘<‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘>’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘”‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘%’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘;’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘(‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘)’,… Continue reading MySQL: remove special character from DB field
Best PHP IDE for junior php developer
PHPStorm Many said this is the best, but cost $99 for individual purchase. NetBeans 7 I just started to use it. My verdict is 10 out of 10 at least for now. The big difference between Netbeans and Eclipse PDT is that you can do pretty much all you need to use just out of the box,… Continue reading Best PHP IDE for junior php developer