How 2 Guru

Guys,

When users using Emails function in some web base application (like sugarcrm, joomla), they might need to request read receipt from the recipients.
Here is a simple tutorial on how to add in the “Request read receipt” in email while send out email thru PHP.

I am using the phpmailer class to develop the feature, please download it from the source forge.

Here is the simple script to send out email and request for read receipt.
read more »

Guys, today I am sharing how to create a installation package for custom scheduler job in SugarCRM.

For SugarCRM administrator, the scheduler job functions are always not enough for suit the business logic.
As a administrator, we are always need to create our customize job in order to fulfill the requirement.

In older version of SugarCRM (like 4.x), it required to modified the core file in SugarCRM to just add in a custom scheduler job function. As SugarCRM release version 5.X, it allow administrator add in a job without modifying the core file.

Here is an example on how to create a single scheduler job in SugarCRM 5.X.X.
read more »

Today I would like to share some useful command for developer to export out data by using SQL statement.
I think most of the developer should familiar with the putty & command line environment.
But always facing an problem to export out the data in a excel/csv file in order to send it to customer.

Here is a simple but useful MySQL command to export out your data in a csv file.
read more »

Hi guys,

I hosted my website using hostgator service.
It is a US base provider.

Here is the latest Hostgator voucher to get you the first month hosting at only $0.01(save $9.94)!
Discount voucher: prEreSp9hEcr

The best value hostgator plan at the moment is the Baby Plan where you can host unlimited domains. Even if you have only one domain now, it’s worth considering because it’s easier to host new domains straightaway and you get double the bandwidth.

From now until Sep 1, you can also get 20% off your total initial order by using the hostgator coupon code: SPRING. This may be more valuable than the $0.01 first month if you take up a longer hosting plan.

When perform some data clean up in MySQL, found that no disk space was release and MySQL still occupied it.

Here is the command to check those tables with more than 300MB of data:
read more »