PHP and MySQL Object relational mapping Visualization with PhpStorm

Last Updated : |  

Not all editors allow you to visualize the mappings that exist in the database, but there are some who do it, so as a developer you should get programs that make your work easier.

You can not lose the overview, the bigger a project grows or you need better structures. This is not only true for programs you use but much more about the software you develop. Again and again you see that projects are underestimated and not created with the right structures, this has the consequence that the project gets completely out of control, but the development is published in spite of everything. No matter which system you set up or left to others, each system can be optimized and freed of unnecessary ones.

Even giant companies are using an open source CMS which in my opinion is absurd for a company, as this company either has no development department or does not appreciate it. After all, a company should have its own system and thus be independent, efficient, optimally flexible in order to be able to react to all changes in the rapidly growing web. Every system can be documented, with the right tools you can do everything without a lot of work. So any developer who comes to this can still understand everything, as e.g. every function he moves with the mouse fades in a function docu;)

But here is a paid program  PhpStorm what I like to use to visualize ORM (object-relational mapping), because I have not found a free program for it or know.



MySQL database connect

You can connect any number of databases, even those that are not exactly your current project. To access the database, proceed as follows on the screenshot.


PhpStorm - Database

Now you can see the database listing which should be empty the first time you call this or restart PhpStorm. Now go to the top left on the plus sign with the arrow down, see screenshot.


PhpStorm - Database Connect

If you are now on e.g. MySQL clicks will pop up a window to enter the database connection. Here you fill out as well as with PhpMyAdmin the user data and additionally you can specify a database directly and then confirm with OK.


PhpStorm - DB login

Visualization of the database

Now that you have done this, you can right-click on the created database and select the following.


PhpStorm - SQL Table Visualisierung

Mapping in the database

Now the visualization of your database will appear and be mapped, you can see the mapping and more Primary Keys, One To Many, Many To One, or Many To Many. Among other things, you can also read database tables from the edit and edit directly.


PhpStorm - Database Mapping

That's all, more is not necessary to make sure that the desired connection has been made, you can use this very well.

Your Comment

* This fields are required, email don't publish
You can use this tags: <p>, <em>, <strong>, <u>, <s>, <pre>, <blockquote>
?

This field is optional
Fill this field link your name to your website.

Data entered in this contact form will be stored in our system to ensure the output of the comment. Your e-mail address will be saved to determine the number of comments and for registration in the future

I have read the Privacy policy and Terms. I Confirm the submission of the form and the submission of my data.
tnado © 2019 | All Rights Reserved
In cooperation with Hyperly