Making Eclipse for PHP Useful

Jacob Allred

Out of the box, Eclipse for PHP is lacking a few vital features.

Problem: How do I run SQL queries in Eclipse?

Solution: The SQL Explorer plugin.

To install:

Problem: Okay, I can run some queries now, but not against Microsoft SQL Server!

Solution: Use the jTDS JDBC driver. (Note: In my experience, this driver is much faster and more reliable than the driver you can get from Microsoft.)

To use:

Problem: What about editing files on a remote server? The built in Remote System Explorer doesn’t seem to work…

Solution: Use CDT and Target Management (this includes a working version of Remote System Explorer).

To install CDT:

To install Target Management (requires CDT):

To connect to a Linux box over SSH: