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 FuerteDeveloper and AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason CarsonComputer 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 FuerteDeveloper and AnalystAuthor Commented:
Hi

I just installed and start testing Sublime...
Any suggestions on using MySQL?
0
Jason CarsonComputer 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
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Eduardo FuerteDeveloper and AnalystAuthor Commented:
I had been using dbforge studio for MySQL
0
Eduardo FuerteDeveloper and AnalystAuthor Commented:
and just one doubt... by using Sublime is it possible to use X-Debug?
0
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chris StanyonWebDevCommented:
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 CarsonComputer 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 FuerteDeveloper and AnalystAuthor 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 StanyonWebDevCommented:
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 FuerteDeveloper and AnalystAuthor Commented:
Thank you for the help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.