Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use phpMyAdmin, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

What is phpMyAdmin?

PhpMyAdmin is one of the most widely used MySQL graphical management tools. It is a MySQL client software developed using PHP based on Web S mode. The tool is based on the Web cross-platform management program and supports simplified Chinese. Users can download the latest version on the official website.

PhpMyAdmin provides Web developers with a graphical database operation interface similar to Access,SQL Server. Through this management tool, you can perform various operations on MySQL, how to create databases, data tables and generate MySQL database script files.

Functional features

PHP is a scripting language that creates a dynamic website based on the server. You can use PHP and HTML to generate the home page of the site. When a visitor opens the home page, the server executes the PHP command and sends the execution result to the visitor's browser, which is similar to ASP and CoildFusion, but PHP differs from them in that PHP is open source and cross-platform, and PHP can run on WINDOWSNT and multiple versions of UNIX. It does not require any pre-processing to quickly feedback the results, nor does it require mod_perl adjustments to reduce the memory image of your server. PHP consumes less resources, and when PHP is part of the ApacheWeb server, there is no need to call external binary programs to run the code, and the server does not need to bear any additional burden.

In addition to being able to manipulate your page, PHP can also send the title of HIIP. You can set up cookie, manage digital signatures and redirect users, and it provides excellent connectivity to other databases (and ODBC), integrating a variety of external libraries to do anything to parse XML with PDF documents.

PhpMyAdmin is a software tool written in PHP, which can control and operate MySQL database through web. Through phpMyAdmin, you can fully operate on the database, such as creating, copying, deleting data, and so on. If you use the right tools, the administration of the MySQL database will be quite simple. Applying the MySQL command-line approach requires a lot of knowledge of MySQL, as well as the SQL language. Not only that, if there is a large amount of access to the database, it will be quite difficult to read the data in the list.

At present, there are many GUI MySQL clients, the most outstanding of which is the Web-based phpMyAdmin tool. This is a PHP-based tool for MySQL database foreground.

The disadvantage of PhpMyAdmin is that it must be installed in the Web server, so without proper access, other users may compromise SQL data.

Installation process

If you use an integrated installation package to configure PHP's development environment, you do not need to download phpMyAdmin graphical management tools separately, because the integrated installation package basically contains graphical management tools. We use the integrated installation package phpStudy here.

If you are not using an integrated installation package, then you need to install phpMyAdmin graphical management tools on your own. You can go to the official website to download the latest version. We will not introduce the installation process in detail here. You can read the article "http://www.php.cn/php-weizijiaocheng-357397.html", which describes the installation process of phpMyAdmin in detail.

Use

PhpMyAdmin is a database management tool of MySQL based on PHP and constructed on the host of the website in the way of Web-Base.

You can manage the entire MySQL server (superuser is required), or you can manage a single database. In order to implement the latter, you will need to properly set up the MySQL user, who can only read / write to the allowed database. That's not until you read the relevant parts of the MySQL manual.

PhpMyAdmin graphical management tools are used in the same way in both Windows and Linux operating systems.

Operating database in the visual interface of phpMyAdmin graphical management tool

Operate the database

Enter "localhost/phpMyAdmin/, enter" in the browser's address bar to enter the phpMyAdmin main interface. Then you can operate on the MySQL database.

1. Create a database

In the main interface of phpMyAdmin, you can see the drop-down box of "language-languange". We can select the "Chinese-Chinese simplified" option in the drop-down box, and then there is a "server connection check". We generally choose utf8_general_ci simplified Chinese coding format to prevent garbled.

When the above settings are set up, I will start to create the database. Clicking on the database at the top left will bring up the following interface:

Then enter your database name in the text box. Here is "php.cn". Although we have set this encoding format at the beginning, we can select "utf8_general_ci" again here, and then click the create button in the left column to see the database you created, as shown below:

We can manage the database by clicking on the database we created:

The above is that the database has been created successfully!

two。 Modify the database

In the database management interface (above), there is an "Action" button, click to go to the page to modify the operation of the database.

1. Go to the top left of the modification page and perform the operation of creating a data table on the current database. Enter the name of the data table and the total number of fields to be created in the two text boxes under the prompt information of the data table, respectively, and click the "execute" button. We will go to the create data table structure page, which will be described in detail in the following article.

two。 At the top right of the modification page, you can rename the database, enter the database name in the text box of "rename the database to:", and click "execute" to change the database name successfully.

3. Delete database

Also click the "Action" button to enter the modification page, directly below the "New data Table" is to delete the database, click to delete the database

Note:

Database in our daily development is very heavy, there is a lot of data, if you want to delete must be careful, once deleted can not be restored, it is recommended to back up the database before deletion!

Manipulate the datasheet on the premise of selecting the specified database, and then create and manage the datasheet in that database. Below we will describe in detail how to create, modify, and delete data tables!

1. Create a datasheet

Let's use the user's account as an example to introduce in detail the method of creating a data table.

After creating the php.cn database, click the php.cn database, enter the name of the data table and the number of fields in the text box under "New data Table", and then click the "execute" button to create the data table, as shown below:

After the data table is successfully created, the interface of the data table structure is displayed, in which the detailed information of each field is entered in the form, including field name, data type, length / value, encoding format, empty and primary key, etc., to complete the detailed setting of the table structure. When all the information is completed, click Save to create the data table structure, as shown in the following figure.

Tips:

After clicking the "Save" button, click "Datasheet Table name", you can display the data table structure in horizontal version, which is easy to edit the structure!

two。 Modify the data table

After a new data table is created, go to the data table structure page, where you can modify the table by changing the structure of the data table. You can add a column, delete a column, index a column, modify the data type of a column or the length / value of a field, as shown below:

3. Delete data tabl

Delete the data table is more or less the same as the database, click on the data table to enter the data table structure page, and then there is an "operation button" in the upper right corner. Click to enter the operation page, where the table is sorted and modified. The table can be moved to other databases, table options can be modified, and table maintenance. In the lower right corner, there is a "delete data or data table". Click "delete data table" to delete the data table! As shown below:

The detailed explanation of the picture and text of the data table using SQL statement

Click the "SQL" button in the phpMyAdmin main interface, open the SQL statement editing area, and enter the complete SQL statement to query, add, modify and delete data!

1. Insert data using SQL statements

Use the insert clause item data table php.cn in the SQL statement editing area to insert data, and click "execute" button to insert a piece of data into the data table. If there is an error in the submitted SQL statement, the system will give a warning and prompt the user to modify it, as shown below:

If there are no errors in the SQL statement, click the "Browse" button in the upper left corner to enter the data display page, as shown below:

Tips:

For ease of writing, you can use the property list on the right to select the column you want to operate on, just select the column you want to add, double-click its option, or click "

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.