YOUR FEEDBACK
José D'Andrade wrote: "...it may never be released..." Why? "...if Midori isn’t heir to Windows Mi...
AJAXWorld RIA Conference
$300 Savings Expire August 8
Register Today and SAVE!


2007 West
GOLD SPONSORS:
Active Endpoints
Your SOA Needs BPEL for Orchestration
BEA
Virtualized SOA: Adaptive Infrastructure for Demanding Applications
Nexaweb
Overcoming Bandwidth Challenges with Nexaweb
TIBCO
What is Service Virtualization?
SILVER SPONSORS:
WSO2
Using Web Services Technologies and FOSS Solutions
Click For 2007 East
Event Webcasts

2008 East
PLATINUM SPONSORS:
Appcelerator
Think Fast: Accelerate AJAX Development with Appcelerator
GOLD SPONSORS:
DreamFace Interactive
The Ultimate Framework for Creating Personalized Web 2.0 Mashups
ICEsoft
AJAX and Social Computing for the Enterprise
Kaazing
Enterprise Comet: Real–Time, Real–Time, or Real–Time Web 2.0?
Nexaweb
Now Playing: Desktop Apps in the Browser!
Sun
jMaki as an AJAX Mashup Framework
POWER PANELS:
The Business Value
of RIAs
What Lies Beyond AJAX?
KEYNOTES:
Douglas Crockford
Can We Fix the Web?
Anthony Franco
2008: The Year of the RIA
Click For 2007 Event Webcasts
SYS-CON.TV
TOP COLDFUSION LINKS


Zend Studio for Eclipse
An IDE of great promise

Debugger
Another big aspect to Zend's Studio for Eclipse is its full-featured debugger. This is one of the best debuggers that I've seen in a long time. Figure 4 shows a sample program in debug mode in the PHP Debug Perspective. There are many views here that support the debug process. In the middle of the top pane you can track your variables, breakpoints, and parameter stack. To the right of that is a view that holds the outputs of the debugger in both HTML and browser-rendered formats. Then in the middle pane is the code that's being traversed with the debugger, so you can see the code as it's being executed.

If you can see the mouse-pointer in Figure 4 it's pointing to the toolbar items in the debugger that help you navigate through a debugging session. Here you can step into, over, or through (to the cursor) your code as you're looking for the problems in your application. Being able to stop you coding at certain stages of execution and inspecting values can be very valuable indeed.

Preferences
The plethora of options that control how the Studio works is huge! If you select the preferences option under the window menu you'll be presented with the dialog that appears in Figure 5. Here you can change the default behavior of almost every aspect of this IDE. From the editor to the SQL connections to the Internet settings it's all here. Specifically shown in Figure 5 are the options you have for altering the syntax colorization of the PHP code. Since there are so many options for you to choose from be sure to change only one or two features at a time so that you can see what the alteration really does, and so you don't have that many changes to roll back that you forget which option made the change you really wanted.

SQL Connections
Studio for Eclipse also has a very nice SQL Perspective where you can interact with any local or remote data source. As shown in Figure 6, I have a local MySQL data source selected in the left pane, the Data Source Explorer, with some executed SQL select statements running in the lower central portion of the screen. On the lower right the results of the most recently executed SQL command is displayed, and at the top is a SQL editor file where you can write your own more complex SQL commands to be executed.

This SQL interface has many features and options as well. In the Data Source Explorer a number of options are presented when you click the right-mouse button. You can even edit the data in a table directly within this perspective.

Code Gallery
One other feature that's great for team development is the code gallery that Zend has implemented into Studio for Eclipse. This is a two-pronged repository of tried and tested code snippets that can be repeatedly used in multiple projects. The idea is that you can come up with some great code segments and save them into this gallery for others to use. Figure 7 has a screen shot of an entry being made into the gallery. Once you have a library of code to draw from you can open its defined view and simply click the 'insert' button on its tool bar to insert the code at the current location of your cursor within the code you're developing.

The second prong of this code gallery is that Zend has a global gallery where it's collected some of the best code ideas of the PHP community. With your Zend username and password you can access this repository and use the code in your own projects. And if you come up with a great segment of code on your own, you can also 'suggest' it to the Zend gallery, and on review it may be included in Zend's gallery for all the world to peruse.

Summary
Zend's Studio for Eclipse has many more features that I haven't mentioned here. Below is a brief list of what else is in store for you.
•  Zend Framework integration
•  CVS file management
•  FTP/ SFTP connection
•  WYSIWYG editor
•  Zend platform integration
•  Code refactoring

As I mentioned when I started I've been looking for the perfect IDE for years and have experienced many different stages of their incantations. Zend Studio for Eclipse is still young and unseasoned, but I think it will definitely be in the running for a top icon spot on my desktop and used on a regular basis as I continue my development journey with PHP. As Studio for Eclipse matures and versions 2 and 3 show up over time I'm sure that Zend will be continually adding features to it, so it can only get better.

About Peter MacIntyre
Peter MacIntyre lives and works in Prince Edward Island, Canada where he has been in the IT business for over 18 years. Peter and co-author Ian Morse are nearing the completion of a guidebook for Zend Studio for Eclipse soon to be published by Pearson Publishers. Peter’s website is: http://www.paladin-bs.com

YOUR FEEDBACK
Taylor wrote: This is the best explanation of grouping data I have found yet. Thanks so much for the article and especiallly showing the progression you went through to reach more optimized code. You helped fix an issue I was having (missed a small step) and I greatly appreciate it.
D wrote: Is there some way to limit the output in the inner loop? For example, if I wanted to display the first five records for a specific group then move on to the next group. MAXROWS is only available for the outer loop, not the inner loop.
CFDJ LATEST STORIES . . .
SQL Injection attacks are one of the easiest ways to hack into a website. One recent hack, using a script from verynx.cn, involves injecting sql into a web form that then appends some JavaScript code into fields in a database that then gets executed on the client side when a user views...
Mike Neil is general manager for virtualization strategy in the Windows Server Division at Microsoft. Mike is focused on the delivery of the Windows virtualization technology, including Windows Server 2008 Hyper-V, Microsoft Hyper-V Server and Virtual PC 2007. Mike also directs the tec...
Two of the biggest launches in Rich Internet Application history took place in 2007/2008 when Adobe launched AIR 1.0 in February '08 and Microsoft launched Silverlight (September '07). At the 6th International AJAXWorld RIA Conference & Expo in October SYS-CON Events is delighted to be...
Recursion Software released a private beta version of their Voyager mobile platform, with powerful interoperability for Android, Microsoft .NET and Compact Framework (CF), all Java editions (JME CDC, JSE and JEE), and more than 15 embedded operating systems. The Voyager platform is a p...
2008 is going to be an important year for Rich Internet Applications. Most organizations are delivering or planning to deliver Rich Internet Applications; however, at the same time, most IT managers are facing a dilemma: which Rich Internet Application technology and platform to use? T...
CFDynamics, a ColdFusion web host, has renewed an agreement with SmarterTools that will allow them to pass on immediate value to their customers. When a customers signs up for a dedicated hosting account they will now receive $750 worth of features including SmarterMail, SmarterStats a...
SUBSCRIBE TO THE WORLD'S MOST POWERFUL NEWSLETTERS
SUBSCRIBE TO OUR RSS FEEDS & GET YOUR SYS-CON NEWS LIVE!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021


SYS-CON FEATURED WHITEPAPERS

ADS BY GOOGLE