Chapter 1 - Dynamic Web Content

Question 1

What is Apache?

Answer 1

The web server we use.

Question 2

What does Apache web server do?

Answer 2

It responds to web requests and triggers other software to run on the server, such as:

PHP, operating as a module embedded into Apache.

MySQL, which acts as the database.

Question 3

What does Apache web server do?

Answer 3

It responds to web requests and triggers other software to run on the server, such as:

PHP, operating as a module embedded into Apache.

MySQL, which acts as the database.

Question 4

What is a request response process?

Answer 4

It consists of a web browser asking the web server to send it a web page, and the server sending it back to the page. the browser then takes care of displaying the page.

Question 5

What does DNS stand for?

Answer 5

Domain Name Service

Question 6

Give an example of an INSERT statement

Answer 6

INSERT INTO users VALUES(‘Smith’, ‘John’, ‘jsmith@mysite.com’);

Question 7

Give an example of a SELECT statement

Answer 7

SELECT surname,firstname FROM users WHERE email=’jsmith@mysite.com’;

Question 8

What does SQL stand for?

Answer 8

Structured Query Language

Question 9

What is an RSS?

Answer 9

Really Simple Syndication

Question 10

What does the Rewrite module do?

Answer 10

Enables the web server to handle a varying range of URL types and rewrite them to its own internal requirements.

Question 11

What does the proxy module do?

Answer 11

You can use this to serve up often-requested pages from a cache to ease the load on the server.

Question 12

What does PHP handle?

Answer 12

All the main work on the web server

Question 13

What does mySQL handle?

Answer 13

Manages all the data

Question 14

What do CSS and Javascript handle?

Answer 14

How the web page is presented

Question 15

What are the four components at minimum, needed to create a fully dynamic web page?

Answer 15

A web server (such as Apache)

a server-side scripting language (PHP)

a database (MySQL)

a client-side scripting language (JavaScript).

Question 16

What does HTML stand for?

Answer 16

HyperText Markup Language: the web page itself, including text and markup tags.

Question 17

Why does the name MYSQL contain the letters SQL?

Answer 17

Like nearly all database engines, MySQL accepts commands in Structured Query Language (SQL). SQL is the way that every user (including a PHP program) communicates with MySQL.

Question 18

PHP and JAvaScript are both programming languages that generate dynamic results for web pages. What is their main difference, and why would you use both of them?

Answer 18

PHP runs on the server, whereas JavaScript runs on the client. PHP can communicate with the database to store and retrieve data, but it can’t alter the user’s web page quickly and dynamically. JavaScript has the opposite benefits and drawbacks.

Question 19

What does CSS stand for?

Answer 19

Cascading Style Sheets: styling and layout rules applied to the elements in an HTML document.

Question 20

List three major new elements introduced in HTML5.

Answer 20

Probably the most interesting new elements in HTML5 are , , and , although there are many others such as , , , and more.

Question 21

If you encounter a bug in one of the open source tools, how do you think you could get it fixed?

Answer 21

Some of these technologies are controlled by companies that accept bug reports and fix the errors like any software company. But open source software also depends on a community, so your bug report may be handled by any user who understands the code well enough. You may someday fix bugs in an open source tool yourself.