Home > Article > Backend Development > The third day of learning PHP in ten days_PHP tutorial
The third day of learning PHP in ten days_PHP tutorial
- WBOYOriginal
- 2016-07-21 16:08:02926browse
Learning purpose: Learn to build a database
In ASP, if it is an ACCESS database, you can directly open ACCESS to edit the MDB file. If it is SQL SERVER, you can open the Enterprise Manager to edit the SQL SERVER database, but In PHP, the command line editing of MY SQL may be troublesome for beginners. It doesn't matter. You can download PHPMYADMIN and install it. You can rely on it to build and edit the database in the future.
Let’s talk about its use.
After entering phpmyadmin, we first need to create a database. Select Chinese Simplified Language (*) here, then create a new database on the left, fill in the database name here, and click Create.
Then select the created database in the drop-down menu on the left. In the following
create a new table in the database shop:
Name:
Number of fields:
Fill in the table name and the approximate number of fields you think (not enough or too many) It doesn’t matter, you can add it later or default it), press execute.
Then you can start creating the table.
The first column is the name of the field; the second column selects the field type:
We commonly use the following ones:
1) VARCHAR, text type
2) INT, integer type
3) FLOAT, floating point type
4) DATE, date type
5) You may ask, where is the automatically added ID? Just select the INT type and select auto_increment in the following extras.
After creating the table, you can see the table you created on the left. After clicking, you can:
1) Click on the structure on the right: View and modify the table structure
2) Click on the browse on the right : View the data in the table
3) Press SQL on the right: run the SQL statement
4) Press Insert on the right: insert a row of records
5) Press Clear on the right: delete all records in the table
6) Press delete on the right: delete table
Another very important function is import and export. When we have completed the program and database locally, we need to have a local mirror on the server. If ASP's ACCESS is simple. You can directly upload the MDB file. If it is SQL SERVER, you can also connect to the remote server for import. Then you can export all SQL statements in MY SQL, go to PHPMYADMIN on the remote server, press SQL after creating the database, and paste all the SQL statements generated by this level that you just copied.
That’s it for today, and we will continue talking about database operations tomorrow.