For quite a while we have been sharing this blog and other resources for both PhpStorm and WebStorm IDEs, but we came to a conclusion it’s the very time to let these products have their own separate resources to make our visitors get the most relevant information on the product they use without any distraction or inconvenience.

From this moment this blog is closed, no new comments or posts will be published to this blog. Everything already published will remain available in this blog. And please check the new PhpStorm and WebStorm blogs to get the most relevant information about the product you use.

Please note that @webide twitter channel is now renamed to @PhpStorm and will tweet only PhpStorm-related information – make sure you follow us – all the current followers of former @webide twitter account don’t need to re-follow a new account, all the followers have been transferred automatically during the rename process. WebStorm has got its own twitter account @WebStormIDE – make sure you follow it if you want to get all the tweets on WebStorm IDE.

And, if you found a good replacement for Google Reader, it is also a good idea to subscribe to PhpStorm blog RSS or WebStorm blog RSS to receive all the updates immediately.

Plugin repositories are already separated, and discussion forums will be separated soon.

Develop with pleasure and follow the right JetBrains’ resources!
– Your JetBrains PhpStorm & WebStorm Teams

The generic Factory Method pattern support was added. By adding simple external metadata you can help IDE to deduce return types from the invocation arguments. This will reduce the number of required @var annotations in code employing the pattern, wich is quite common in modern frameworks. More info on using metadata.

The feature above is implemented using PHP open API. The introduced Extension Point also allows 3rd party plugin creators to provide type info automatically using framework’s established practices and configuration. The API is still highly unstable (and has already evolved since this build) but we will provide guidance. Check out tutorials on plugin development.

Other notable changes

• PHP type inference for variables should now correctly work with Fluent Interface style call chains – again removing the need for @var annotations.
• PHP completion for array indexes has been significantly improved
• PHP inspection got a couple of new ones – division by zero and invalid string operation
• Details on resolved tracker issues

Download PhpStorm 6.0.1 EAP for your platform and please report any bugs and feature request to out Issue Tracker. Automatic update via patch is also available.

Develop with pleasure!
-JetBrains Web IDE Team

• Setting up a database connection
• Creating a table
• Inserting and updating data
• Using the database console
• Generating a database diagram
• Database refactoring

If you are familiar with Windows Azure SQL Database, make sure to configure the database firewall correctly so you can connect to it from your current machine.

Setting up a database connection

Database support can be found on the right-hand side of the IDE or by using the Ctrl+Alt+A (Cmd+Alt+A on Mac) and searching for “Database”.

Opening the database pane, we can create a new connection or Data Source. We’ll have to specify the JDBC database driver to be used to connect to our database. Since Windows Azure SQL Database is just “SQL Server” in essence, we can use the  SQL Server driver available in the list of drivers. PhpStorm doesn’t ship these drivers but a simple click (on “Click here”) fetches the correct JDBC driver from the Internet.

Next, we’ll have to enter our connection details. As the JDBC driver class, select the com.microsoft.sqlserver.jdbc driver. The Database URL should be a connection string to our SQL Database and typically comes in the following form:

jdbc:sqlserver://<servername>.database.windows.net;database=<databasename>

The username to use comes in a different form. Due to a protocol change that was required for Windows Azure SQL Database, we have to suffix the username with the server name.

After filling out the necessary information, we can use the Test Connection button to test the database connection.

Congratulations! Our database connection is a fact and we can store it by closing the Data Source dialog using the Ok button.

Creating a table

If we right click a schema discovered in our Data Source, we can use the New | Table menu item to create a table.

We can use the Create New Table dialog to define columns on our to-be-created table. PhpStorm provides us with a user interface which allows us to graphically specify columns and generates the DDL for us.

Clicking Ok will close the dialog and create the table for us. We can now right-click our table and modify existing columns or add additional columns and generate DDL which alters the table.

Inserting and updating data

After creating a table, we can insert data (or update data from an existing table). Upon connecting to the database, PhpStorm will display a list of all tables and their columns. We can select a table and press F4 (or right-click and use the Table Editor context menu).

We can add new rows and/or edit existing rows by using the + and - buttons in the toolbar. By default, auto-commit is enabled and changes are committed automatically to the database. We can disable this option and manually commit and rollback any changes that have been made in the table editor.

Using the database console

Sometimes there is no better tool than a database console. We can bring up the Console by right-clicking a table and selecting the Console menu item or simply by pressing Ctrl+Shift+F10 (Cmd+Shift+F10 on Mac).

We can enter any SQL statement in the console and run it against our database. As you can see from the screenshot above, we even get autocompletion on table names and column names!

If we have multiple tables with foreign keys between them, we can easily generate a database diagram by selecting the tables to be included in the diagram and selecting Diagrams | Show Visualization… from the context menu or using the Ctrl+Alt+Shift+U (Cmd+Alt+Shift+U on Mac).

As you can see from the above screenshot, PhpStorm will generate a database diagram for the selected tables, displaying how they relate to each other.

Database refactoring

Renaming a table or column often is tedious. PhpStorm includes a Rename refactoring (Shift-F6) which generates the required SQL code for renaming tables or columns.

As we’ve seen in this post, working with Windows Azure SQL Database is pretty simple from within PhpStorm using the built-in database support.

Develop with pleasure!

– JetBrains Web IDE Team

We looked at:

• New refactorings: Change signature, Pull Up/Push Down class members, Move class
• Composer dependency manager for PHP support
• Smarter namespace handling
• Auto-import, Optimize Imports and more
• Code (re)arranger – control the structure of your existing and generated code
• Fully customizable templates, including PHPDoc

Maarten also did an overview of the brand new web toolkit featured in this release:

• Full-featured debugging of TypeScript, Dart or CoffeeScript with source maps
• Refined handling of JS libraries, including minified versions detection
• REST Client to test RESTful web services right from the IDE
• Re-worked HTML structure view
• Improved HTML and CSS coding including Emmet
• New database schema editor and change tracking tools

During the webinar, a lot of questions and feature requests were made. As promised, we’re providing you with the questions and answers in this PDF.

As always, we appreciate your feedback in the comments below or in our forums!

Develop with pleasure!
– JetBrains Web IDE Team

Take the searchUser function in a class called UserReporsitory.

There is no real use for this method as it is now. It’s private, so no other classes can make use of this function. It also has no parameters where we want to be able to search users based on their username. Using the Refactor | Change Signature… context menu (Ctrl+F6 or Cmd+F6 on Mac) we can open the Change Signature dialog.

In this dialog, we can change the function’s visibility from private to protected or public. We can rename it to searchUserByUsername so that the intent of this function is clearer to the caller. Next, we can add a parameter $username and give it a default value, in this case an empty string. Note that we can also add the parameter type (e.g. MyNamespace\MyType $username) as well as an initializer (e.g. $username = null). We can reorder parameters using the buttons on the right.

The Change Signature dialog shows us a preview of the new function signature. We can use the Refactor button to immediately carry out the refactoring or the Preview button to see a list of all code that is about to be updated with this new signature. Once done, our new searchUserByUsername function will look like this:

What’s really interesting is that all calls to this method have been updated as well. For example, the following call has been updated to use the default value we entered in the Change Signature dialog earlier:

The Change Signature refactoring will update the function itself, all calling code, and overloading functions in the case of interfaces or abstract class functions being refactored. Using the Alt+G shortcut (or clicking the Propagate Parameters button) lets us add new parameters to all calling functions as well.

As always, we appreciate your feedback in the comments below or in our forums!

Develop with pleasure!
– JetBrains Web IDE Team

Just a couple of weeks after the major 6.0 update we are ready to deliver fresh build to be tested.

On PHP side we are focused on bugfixes and new features, including:

• Change Signature refactoring now supports anonymous functions
• New action “move method up/down”
• Code formatting and indentation fixes
• Smarty template engine support fixes

All the latest fixes from the Web team are also included, such as:

• Improved formatting for CoffeeScript
• Improved inspections for SASS and TypeScript

Apart from than a new build features general performance and stability improvements.

Download PhpStorm 6.0.1 EAP build 129.91 for your platform from project EAP page and please report any bugs and feature request to out Issue Tracker. No patch-update available for this build.

Develop with pleasure!
-JetBrains Web IDE Team

The feature is enabled by default and can be configured under the IDE settings in the Editor | Code Folding | PHP imports pane.

Please download the latest build, provide as much feedback for bugs and feature requests here, and leave questions in the comments below or in our forums!

Develop with pleasure!
– JetBrains Web IDE Team

This functionality is available in IntelliJ Idea, PyCharm, WebStorm, PhpStorm, and RubyMine.

To add a remote host, select Tools | Deployment | Configuration and provide the necessary details to connect to the remote host. Once finished, Tools | Deployment | Browse Remote Host will reveal the remote file browser.

We can now drag a file from the project pane to the remote host pane and initiate an upload of the selected file(s) to the remote host:

Copy/paste between both panes is supported as well:

And of course, the inverse direction is supported as well: we can select files on the remote host and drag them to our local project to download them from the remote server:

Please download the latest build, provide feedback for bugs and feature requests here, and leave questions in the comments below or in our forums!

Develop with pleasure!
– JetBrains Web IDE Team

The Optimize Imports action is designed to help you maintain (sometimes very long) lists of imports. It performs the following optimizations for you:

1. Removes unused imports
2. Sort imports alphabetically (ascending order)
3. Splits multiple use statement imports into single use statement imports.

Note that importing is performed in compile-time, so it is a safe transformation and doesn’t change the semantics of your application.

For example, before Optimize Imports, the list of imports is a bit cluttered:

After Optimize Imports, we can see (diff) that imports have been sorted by namespace:

The Optimize Imports action can be invoked directly on a file, or on a directory, by pressing Ctrl+Alt+O or Cmd+Opt+O on Mac. Optimize imports is also an option in the Commit and Reformat Code dialogs.

Before committing code to source control, we can select the Optimize imports checkbox to perform the optimize imports action before the actual commit:

The Reformat Code dialog also allows us to optimize imports in one go:

Please download the latest build, provide feedback for bugs and feature requests here, and leave questions in the comments below or in our forums!

Develop with pleasure!
– JetBrains Web IDE Team