ICT_10 класс_Linking a web page to a database. lesson 1
Оценка 4.6

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

Оценка 4.6
pptx
09.05.2020
ICT_10 класс_Linking a web page to a database. lesson 1
ICT_10 класс_Linking a web page to a database. lesson 1.pptx

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

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

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

Determine the theme of the lesson

Determine the theme of the lesson

Determine the theme of the lesson

Linking a web page to a database

Linking a web page to a database

Linking a web page to a database

Learning objective :

link a web page to a database

The theme of the lesson :

What are Web pages? Static-ready files *

What are Web pages? Static-ready files *

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

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

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

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

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

Most importantly, MySql is a free database!

Most importantly, MySql is a free database!

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.

Why MySql?

Choosing a free hosting or software :

Choosing a free hosting or software :

Choosing a free hosting
or software :

Denwer;
Xampp;
Winginx;
OpenServer.

Creating a database in phpMyAdmin

Creating a database in phpMyAdmin

Creating a database in phpMyAdmin

Working with PhpMyAdmin:
1. database creation
2.create multiple tables specifying types, field length, key field, etc.
3.linking tables

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 1. In PhpMyAdmin, create a database named

Task 1. In PhpMyAdmin, create a database named

Task 1. In PhpMyAdmin, create a database named Institute and tables:

Practical task

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

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

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.

Practical task

Reflection - I learned in class… -

Reflection - I learned in class… -

Reflection

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

Скачать файл