Could you point the better tools to develop PHP/ MySQL on Ubuntu?

Hi Experts

Could you point the better tools to develop PHP/ MySQL on Ubuntu?
Possibly free.
I'm using PHPDesigner/ dbForge on Winodows environment and had to change.

Thanks in advance
Eduardo FuerteAsked:
Who is Participating?
 
gr8gonzoConsultantCommented:
For MySQL, just use HeidiSQL over Wine.
https://appdb.winehq.org/appview.php?iAppId=3326

And for PHP, use PHPStorm:
http://www.jetbrains.com/phpstorm/download/#section=linux

Or if you want to just look around at anything that supports XDebug, check out its own published list of clients:
https://xdebug.org/docs/remote

I published the link so that you can check it for the latest list, but from that list today, there's NetBeans, KDevelop, Eclipse, and plenty more - several are free. I just recommended PHPStorm since it's focused on PHP rather than being a generic IDE with a PHP plugin.
0
 
Jason CarsonFreelance Computer TechnicianCommented:
There are a lot of editors out there for ubuntu. Click here for a partial list and how to install them.

I use Sublime Text for HTML/CSS/Javascript/PHP/MySQL development. Simple interface, lots of options.It's free to download and evaluate but a license costs $80.00. Whenever version 4 comes out you have to buy a new license. It works on Windows/Linux/Mac and you can have it installed on all 3 operating systems at once without violating the license terms.
0
 
Eduardo FuerteAuthor Commented:
Hi

I just installed and start testing Sublime...
Any suggestions on using MySQL?
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
Jason CarsonFreelance Computer TechnicianCommented:
As per MySQL what exactly are you looking for? Just start typing out your PHP/MySQL code.

If you are looking for a wysiwyg type editor then sublime is not what your looking for.

Quick tip, to have your development directories shown on the left hand side for your various projects click Project -> Add folder to project
0
 
Eduardo FuerteAuthor Commented:
I had been using dbforge studio for MySQL
0
 
Eduardo FuerteAuthor Commented:
and just one doubt... by using Sublime is it possible to use X-Debug?
0
 
Chris StanyonCommented:
I'd second Sublime Text. Fantastic editor with lots of plugins to help with development. And Yes - you can use XDebug with it (via a plugin). Allows you to add breakpoints / watches / step through code etc. Also has Project Manager plugins, Bracket Hilighter (a huge help with HTML / PHP etc), snippets etc.

Regarding MySQL, don't overlook PHPMyAdmin - runs through the browser so platform doesn't matter. Whether it will do what you need will depend on what you need! You also have MySQL Workbench which is available on Windows / Ubuntu / Mac, so may be a good option if you're wanting a consistent dev environment between platforms.
0
 
Jason CarsonFreelance Computer TechnicianCommented:
if you are looking for something to maintain your databases I'd second Chris's recommendation of phpMyAdmin.
0
 
gr8gonzoConsultantCommented:
I don't really recommend phpMyAdmin anymore to most people. If they're asking for recommendations, it's my opinion that they're more than likely to install it in a way that will leave their database exposed.

Go check your web access logs for bot hits to "/my" and "/phpymyadmin" and "/pma" - you'll likely find a group of hits that target common install paths for phpMyAdmin (because that's where people generally choose to install it). Plus, the popularity of it makes it a bigger target for vulnerability attacks (and too often, it's installed alongside a production site).

External SQL tools like dbForge and HeidiSQL and Workbench are all good options for MySQL administration and are usually smaller targets (common control panels like CPanel try to enforce IP whitelisting by default, and there are multiple layers to trying to hack a listening MySQL server).
0
 
Eduardo FuerteAuthor Commented:
Thank you for your significant replies

I just installed PHPStorm (demo)  also, it looks to facilitate debug with its own resources (without X-Debug use) Am I right?

Just another doubt: to use HEIDI on Ubuntu environment is it necessary a previous instalation of Wine to simulate Win env, isn't it?
Is it a complex task?
0
 
Chris StanyonCommented:
To do any debugging in PHP, you will need to install a Debugging Engine onto your server (X-Debug / Zend etc). PHPStorm (or Sublime) won't run debugging without it!
0
 
Eduardo FuerteAuthor Commented:
Thank you for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.