ZendStudio8SQL database resource manager instance tutorial

After continuing to introduce ZendStudio7 getting started tutorials, ZendStudio8 Chinese, ZendStudio debugging and other tutorials, we will continue the ZendStudio tutorial. This section describes how to use ZendStudio8SQL database resource manager. As a powerful PHP development tool, ZendStudio provides continuous tutorials on Zend Studio7, Zend Studio8 in Chinese, and Zend Studio debugging. This section describes how to use the Zend Studio8 sqldatabase resource manager. Zend Studio, as a powerful PHP development tool, provides powerful database source management and SQL statement operations, allowing us to centrally manage databases in PHP website development, therefore, learning to use Zend Studio to manage, develop, and debug databases is very helpful for PHP development. To some extent, Zend Studio can also replace the functions of some SQL database tools.

When Zend Studio is used for PHP Development, Zend Studio provides powerful SQL database management functions and supports the development and debugging of more than 10 databases, including Mysql, DB2, Oracle, and SQL Server. The following uses Mysql as an example to describe how Zend Studio8 manages sqldatabase sources.

　　Zend Studio 8 SQL database resource manager tutorial

　　Step 1: Create an SQL connection configuration file and select the corresponding database

Use Zend Studio8 to create the sqldatabase connection configuration file, and select Mysql database

　　Step 2: Select the sqldatabase driver and configure Mysql login information

Select the sqldatabase driver and configure Mysql login information

Description:

1. Please select the Mysql driver corresponding to your Mysql database version. since I used Mysql5.1 in the PHP environment, I chose JDBC Mysql5.1.

2. fill in the specific database to be managed by Zend Studio SQL manager, log on password, and select save password. The modification of the URL option is easy to ignore here. make sure that the database name in the URL is the same as the name in the database option; otherwise, the test connection cannot be pinged.

3. automatically connect to the corresponding database after the default configuration ends. you can also choose to automatically connect to the database each time you start using Zend Studio.

　　Step 3: list the managed Mysql configuration summary after the connection passes the test.

Zend Studio8 connection to Mysql configuration abstract information

After these configurations, the configuration of connecting Zend Studio to the Mysql database is complete. The following describes how to use Zend Studio8 sqldatabase resource manager to manage and operate databases.

　　Zend Studio8 SQL database Source Manager database operation tutorial

In fact, the Zend Studio8 sqldatabase Source Manager is basically the same as the Mysql command or phpmyadmin sqldatabase tool for database management.

1. right-click the connected database table and use the following functions to generate DLL, extract, and load.

　　Generate DLL: Mainly used to generate the corresponding database table structure

　　Extract: Export data in a data table to an external table in the specified format as a file.

　　Load: Import the previously extracted data files to the database.

These three functions are similar to the phpmyadmin import and export function.

2. the Zend Studio8 SQL data resource manager on the left mainly provides the import, export, SQL clipboard, and new SQL connection functions.

Zend Studio8 SQL data resource manager menu

　　Export: It is mainly used to export the previously created SQL connection configuration information in file form for ease of management. by default, the configuration file is encrypted and saved during creation.

　　Import: Import the SQL connection configuration file.

There is no doubt that Zend Studio is more convenient when the import/export function encounters platform migration and other problems.

　　Open SQL scrapbook (SQL clipboard): You can enter an SQL statement to operate the SQL database. It provides the function of saving SQL statements. if you want to execute the entered SQL statement, right-click to select all execution or execute selected text options in the menu. the SQL execution result set can be displayed in tabs or text mode (in the lower right corner of the Zend Studio8 work interface)

Zend Studio SQL Scrapbook interface

So far, the use and operation methods of Zend Studio8 sqldatabase resource manager have been introduced. as long as you are familiar with it, it is very convenient to use Zend Studio to develop or debug the database.