12/1/2023 0 Comments Php connect to sqlproPerform an action that requires interaction with the database. For example, once you run a query.įor a table, the session is connected automatically, as PhpStorm requires an active connection to request the table data from the database, receive it, and display it in the data editor. Open a query console or view database object's data in data editor.Īs a result, under the data source node in the Services tool window, the new session node appears with a client node under it.įor a query console, the session will be connected once you perform an action that requires interaction with the database. You can create a new session by doing either of the following: Green dot in the corner of session's icon indicates the connected status. Data editor can also be a client for a session.ĭepending on the way you create a new session, it can be connected either automatically, or after a certain action. Sessions can have clients - files, whose queries are sent via the connection that the session holds. Each session is a wrapper over a single connection, and it stores the connection's information (for example, whether it is active or not, transaction control mode, and other settings). For every database, the connection details are stored in a dedicated connection configuration - data source.įor a data source, connections to the database are established in special wrappers - sessions. To connect to a database, PhpStorm requires connection details (for example, host, port, password, SSH configuration settings, and so on). Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name. Press Control+Alt+S to open the IDE settings and then select Plugins. If the relevant features aren't available, make sure that you didn't disable the plugin. This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in PhpStorm by default.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |