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

link a web page to a database

1. In PhpMyAdmin, create a database named Institute.
2. Fill in the tables with the data for the teachers, courses, and lessons table
3. Link the tables together through the values of the id and tid records.

To open a connection to the server
Select database
Send query to database
Closing database (not always)

Php function mysql_connect-opens a connection to a MySQL server.
Three parameters of the function:
"localhost" - server, when working locally, the value "localhost" is specified»
"root" — the user name, when working locally is usually specified " root»
""- the third parameter is password, no password locally

or die (mysql_error()) The php mysql_error () function returns the error string of the last MySQL operation and can be used not only when trying to connect to the server, but also in other variants of working with the mysql database

Php function mysql_connect-selects MySQL database. Two function parameters:
 "db_name" — database name
 $conn — a pointer to the connection

Php mysql_query function-sends a request to the active database of the server referenced by the passed pointer. Two function parameters:
 $sql — request
 $conn — a pointer to the connection

Important: to find the error easier, you can print a query:

Php function mysql_fetch_array-returns an array with the processed query result series or FALSE if there are no rows that meet the query parameters

The print_r() function in php is used to output human-readable information about a variable
Important: absolutely the same result will be an appeal to the field by its name and by its number:

mysql_result($result, 1, "name")

assessment