Hi guys. Need your suggestion on php/mysql software. I develop PHP websites using Dreamweaver, I also have to use phpmyadmin, sql query editor (to work with database) and WinSCP (to upload/backup files over SFTP).
Could you suggest me please some software which contains all in one (PHP syntax highlighting, db connections and running sql queries, etc..)?
Thanks in advance.
If you don't want to spend as much as Zend Studio ($399 one year) try Aptana Studio. It is free and for $99 you get the Pro version with extra features like SFTP support.
There is a stand-alone version and an Eclipse plugin.
Netbeans has PHP highlighting, code completition, db manager and ftp/sftp + xdebug (your next step:) ) support.
Try Eclipse. Go here: http://www.eclipse.org/downloads/ it is the third one down in the list (platforms on the right). You can connect to DB's, have intelli-sense (code completion) and more all for FREE!
My personal favorite text editor: e texteditor which a clone of a mac app called textmate.
There is a lot of support for many languages, although Zend Studio will give you more "integration" features.
When I'm forced to use Windows, JEdit is my editor of choice. It has syntax highlighting for almost any language, FTP/SFTP remote editing, SQL plugins, code completion plugins, and so many others that I can't even begin to list them.
And, it's FOSS!
You can find the JEdit project at http://www.jedit.org
Your question is correctly tagged - you need an Integrated Development Environment (IDE)! Dreamweaver wants to be one but unfortunately it isn't.
If you're on a Mac I highly recommend Coda.
For any platform; I've had a great experience with Aptana (a fork of Eclipse) and these open-source IDEs are just bursting with useful plugins. Even Aptana's default project templates were useful instead of fluff!
One guy in my team loves NetBeans to bits.
Right now I'm addicted to shelling into the server and using command-line tools like vi or nano, svn, mysql. A steep (and important) learning curve but everything is possible on the command line. And with minimal client requirements. Do anything from anywhere!
I think the true answer is subjective - you'll need to dive in and try each one to see how they fit your working style.
Hope that helps!