ICT_10 класс_Linking a web page to a database. lesson 1

What is the difference between these sites and the sites you developed earlier?

Determine the theme of the lesson

link a web page to a database

What are Web pages?
Static-ready files *.htm,*.html
loads quickly
does not load the server

does not work with databases (comments, Web 2.0)

When a dynamic request is made on the server in whole or in part compiled



Working with databases

slow to load
additional load on the server

1. Most importantly, MySql is a free database! You do not need to pay for using MySql on websites. Thanks to the built-in support of MySql in the free PHP application, in the development of sites often use a bunch of "PHP+MySql".
2. The database is suitable for most sites with average amounts of information. 99 % of websites on the Internet are like this. Only a small percentage of sites have certain "contraindications"to work with MySql database. For example, large sites with high traffic may require a special approach to the development and selection of a suitable database.
3. Easy to use and administer.
4. MySql is supported by popular hosting providers that provide PHP service. Having programmed the site in PHP and work with the MySql database, You will not have problems with the choice of a suitable hosting and placement of the site on the Internet.

Denwer;
Xampp;
Winginx;
OpenServer.

phpMyAdmin is an open source web application written in PHP, which is a web interface for MySQL database administration. PHPMyAdmin allows you to use a browser and not only to administer the MySQL server, run SQL commands and view the contents of tables and databases.

Task 2.
Fill in the tables with the data for the teachers, courses, and lessons table

Task 3. Link the tables together through the values of the id and tid records.

- I learned in class…
- I was wondering…
I had to think .…
- I can tell others . …