Web Programming

easyPHP: Unable to load PHP extension php_intl.dll

After enable the  intl extension in php.ini. There are two errors happen :
– eds-httpd.exe – System error: The program can’t start because icuuc51.dll is missing from your computer. Try reinstalling the program to fix this problem. (Figure 1)

– PHP Startup: Unable to load dynamic library ‘C:\PROGRA~2\EASYPH~1.1VC\\binaries\php\php_runningversion\ext\php_intl.dll’ – The specified module could not be found. (Figure 2)



  1. Copy all the files that starts with icu* (basically it contains 8 files, it is depends on your OS) from “C:\Program Files (x86)\EasyPHP-DevServer-14.1VC11\binaries\php\php_runningversion\” (location might be different):
  2. And then paste the files to “C:\Program Files (x86)\EasyPHP-DevServer-14.1VC11\binaries\apache\bin\” (location might be different).easyphp3
  3.  Restart easyPHP.


Tested : easyPHP Version 14.1 @ Windows 8

How to : MySQL

How to get the size of MySQL Databases?

SELECT table_schema “ohmygoh”,
sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”,
sum( data_free )/ 1024 / 1024 “Free Space in MB”
FROM information_schema.TABLES
GROUP BY table_schema ;

SugarCRM Web Programming

How to get full name of user by using user id in SugarCRM

It is very simple :

$myUser = new User();

Disk encryption utilities

  1. TrueCrypt : TrueCrypt is a software system for establishing and maintaining an on-the-fly-encrypted volume (data storage device). On-the-fly encryption means that data is automatically encrypted right before it is saved and decrypted right after it is loaded, without any user intervention. No data stored on an encrypted volume can be read (decrypted) without using the correct password/keyfile(s) or correct encryption keys. Entire file system is encrypted (e.g., file names, folder names, contents of every file, free space, meta data, etc).

    Files can be copied to and from a mounted TrueCrypt volume just like they are copied to/from any normal disk (for example, by simple drag-and-drop operations). Files are automatically being decrypted on the fly (in memory/RAM) while they are being read or copied from an encrypted TrueCrypt volume. Similarly, files that are being written or copied to the TrueCrypt volume are automatically being encrypted on the fly (right before they are written to the disk) in RAM. Note that this does not mean that the whole file that is to be encrypted/decrypted must be stored in RAM before it can be encrypted/decrypted. There are no extra memory (RAM) requirements for TrueCrypt. For an illustration of how this is accomplished, see the following paragraph.


System Information for Windows

  1. System Information for Windows : SIW is an advanced System Information for Windows tool that analyzes your computer and gathers detailed information about system properties and settings and displays it in an extremely comprehensible manner.   SIW can create a report file (CSV, HTML, TXT or XML), and is able to run in batch mode
  2. Belarc Advisor : The Belarc Advisor builds a detailed profile of your installed software and hardware, network inventory, missing Microsoft hotfixes, anti-virus status, security benchmarks, and displays the results in your Web browser. All of your PC profile information is kept private on your PC and is not sent to any web server.
  3. PC WIZARD : PC WIZARD is a powerful utility designed especially for detection of hardware, but also some more analysis. It’s able to identify a large scale of system components and supports the latest technologies and standards. This tool is periodically updated (usually once per month) in order to provide most accurate results.

    PC WIZARD is also an utility designed to analyze and benchmark your computer system. It can analyze and benchmark many kinds of hardware, such as CPU performance, Cache performance, RAM performance, Hard Disk performance, CD/DVD-ROM performance, Removable/FLASH Media performance, Video performance, MP3 compression performance.


Fastest way to remove all hyperlinks in Excel

The fastest way is you will need to create a macro to delete the hyperlinks in your Excel.

Step 1:  Create a new Macro. Go to View > Macros > Record Macro…

Step 2:  Enter a Macro name “removehyperlinks”.

 Step 3:  Edit Macro. Go to View > Macros > View Macros… And then click on Edit button.

 Step 4:  Insert/Paste fomular code into your  Macro as following figure:


After inserted the code, go back to the sheet of Microsoft Excel, Views > Macros > Stop recording…

 Step 5:  Run the Macro. Go to View > Macros > View Macros… And then click on Run button.




Screen Capture Utilities

  1. FastStone Capture : Shareware. FastStone Capture is a powerful, lightweight, yet full-featured screen capture tool that allows you to easily capture and annotate anything on the screen including windows, objects, menus, full screen, rectangular/freehand regions and even scrolling windows/web pages. You can choose to send captures to editor, file, clipboard, printer, email, Word/PowerPoint document or upload them to your website. Editing tools include annotating (texts, arrowed lines, highlights), resizing, cropping, sharpening, watermarking, applying edge effects and many more. It also allows you to record screen activities and sound into highly compressed video files. Other features include global hotkeys, automatic filename generation, support for external editors, a color picker, a screen magnifier and a screen ruler.
  2. PicPick : FREE. PicPick is user friendly and full of features for creating your image, suitable for software developers, graphic designers and home users.
    It is an all-in-one program that provides a full-featured screen capture tool, an intuitive image editor, a color picker, a color palette, a pixel-ruler, a protractor, a crosshair and even  a whiteboard.
  3. HyperSnap : Shareware. HyperSnap is the fastest and easiest way to take screen captures from Windows screen and full screen games, and text capture (TextSnap™) from places where normal text copy is not possible. HyperSnap combines the power of a first-class screen capture application with an advanced image editing utility – wrapped into one easy-to-use tool!

Synchronize data between PCs, Laptops, or thumbdrives

  1. Allway Sync : It uses innovative synchronization algorithms to synchronize your data between desktop PCs, laptops, USB drives, remote FTP/SFTP servers, different online data storages and more. Encrypted archives are supported. Allway Sync combines bulletproof reliability with extremely easy-to-use interface.

Clean Up Windows Utilities

  1. ShellExView v1.70– Shell Extensions Manager : Shell Extensions are in-process COM objects which extends the abilities of Windows operating system. Most shell extensions are automatically installed by the operating system, but there are also many other applications that install additional shell extension components. For example: If you install WinZip on your computer, you’ll see a special WinZip menu when you right-click on a Zip file. This menu is created by adding a shell extension to the system.The ShellExView utility displays the details of shell extensions installed on your computer, and allows you to easily disable and enable each shell extension.
  2. Driver Cleaner
  3. index.dat Cleaner
  4. system cleanup
  5. Eraser : Eraser is an advanced security tool for Windows which allows you to completely remove sensitive data from your hard drive by overwriting it several times with carefully selected patterns.
  6. Starter : Starter allows one to view and manage all the programs that are starting automatically whenever operating system is loading. It enumerates all the hidden registry entries, startup folders’ items and some of the initialization files, so that the user could choose to temporarily disable selected entries, edit them, create new, or delete them permanently.  Secondary purpose is to list all the running processes with possibility to view extended process’ information (such as used DLLs, memory usage, thread count, priorities etc.), and to terminate selected process.

Extracting icons from files and libraries utilities

  1. MiTeC Icon Explorer : This tool allows to manage icon libraries, standalone icons and executable that contains icons as resources. MicroAngelo 16-bit format (icl) and 16-bit executables (NE) is no longer supported and Icon Explorer now creates 32-bit DLLs as icon libraries. 32-bit icons and 256×256 sized icons are supported. It has powerfull searching tool that searches specified path with directory recursion and examines any file if it contains any icon and then extract it. Icons can be saved as icons, individual icon images or bitmaps.